Spatial Database Management and Advanced Geographic Information Systems

Lecture Notes

Please note: all associated databases for the course are in the tools section. Any references to ‘Athena’ refer to MIT’s campus-wide, UNIX based computing environment.

Lecture 1 - Introduction:  Planners and Data (PDF)

• The Marriage: Planners & Data (PDF)

Lecture 2 - Relational Database Management (PDF)

• PARCELS database (Please see the tools section.)
• SQL Notes (Please see the tools section.)
• Lab 1 (PDF)
• SQL Help Notes (PDF)
• PARCELS sample database (PDF)

Lecture 3 - Handling One to Many Relations (PDF)

• PARCELS Database (Please see the tools section.)
• SQL Notes (Please see the tools section.)
• Lab 1 (PDF)
• PARCELS sample database (PDF)
• URISA database (PDF)

Lecture 4 - Subqueries and Complex Joins (PDF)

• URISA database (PDF)
• SQL Notes (Please see the tools section.) 
• Zoning Variance / Sub-Neighborhood lookup table (PDF)
• SQL examples using zoning variances (PDF)
• 1980 Census data / Schema of Decision, Use, NSA, Neighborhood Lookup Tables (by Boston NSA) (PDF)
• Grouping zoning applicants via ’lookup’ tables (PDF)
• Zoning Variance Database Evolution Chart (PDF)

Lecture 5 - Parcel Level City Databases (PDF)

• SQL Notes (Please see the tools section.)
• Zoning Variance data dictionary (PDF)
• SQL examples using zoning variances (PDF)
• Queries that we will run (PDF)
• PowerPoint slides (PDF)
• Grouping zoning applicants via ’lookup’ tables (PDF)

Lecture 6 - Zoning Variance Databases (PDF)

• Zoning Variance / Sub-Neighborhood lookup table (PDF)
• 1980 Census data / Schema of Decision, Use, NSA, Neighborhood Lookup Tables (by Boston NSA) (PDF)
• SQL examples using zoning variances (PDF)
• Grouping zoning applicants via ’lookup’ tables (PDF)
• Zoning Variance Database Evolution Chart (PDF)
• Additional class notes on outer joins (PDF)
• URISA database examples (PDF)

Lecture 7 - Referential Integrity (PDF)

• Problem Statement (PDF)
• Proposed Solution (PDF)
• Parcel Database (PDF)

Lecture 8 - Querying Oracle (PDF)

Lecture 9 - Database Design (PDF)

• Problem Set 3 (PDF)
• Schema Version I (PDF)
• Schema Version II (PDF)
• Schema Version III (PDF)
• Schema Version III-2 (PDF)
• Schema Version III-3 (PDF)
• Schema Version IV (PDF)
• create.sql (PDF)
• insert.sql (PDF)

Lecture 10 - Lab 5 (PDF)

• ZONING / ZONING  table / ZONING  database   ( PDF)
• 1980 Census characteristics ( PDF)

Lecture 11 - Practice Exam (PDF)

Lecture 12 - Lab 6 (PDF)

Lecture 13 - Wrap up of Modeling (PDF)

• Review of Raster Modeling - Lorlene Hoyt’s Spring 2002 notes (PDF)
• Density maps, contour plots - Lorlene Hoyt’s Spring 2002 notes (PDF)
  • Approach (PDF)
• Adding ‘Z’: 3D CAD models & 2.5D surface models: lattice mesh - Lorlene Hoyt’s Spring 2002 notes (PDF)