Spatial Database Management and Advanced Geographic Information Systems

Labs

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.

Along with assignments, this class contains regular lab sessions to learn how to use the GIS software.

Lab 1 (PDF)

• PARCELS database (Please see the tools section.)
• SELECT command / SQL Help (PDF)

Lab 2 (PDF)

• PARCELS database (Please see the tools section.)
• URISA Database Notes (PDF)
• PARCELS Database Schema (PDF)
• SQL Notes (Please see the Tools section.)
• Creating unique temporary tables / SQL Help (PDF)

Lab 3 (PDF)

• Zoning Variance Database / Zoning Variances / Sub-Neighborhood lookup table (PDF)
• SQL Notes (Please see the tools section.)
• 1980 Census data (by Boston NSA) / Schema of Decision, Use, NSA, Neighborhood Lookup Tables (PDF)
• SQL examples using zoning variances / sample SQL zoning queries (PDF)
• Grouping zoning applicants via ’lookup’ tables (PDF)
• Zoning Variance Database Evolution Chart (PDF)
• the PowerPoint slides that were used to discuss this paper (PDF)

Lab 4 (PDF)

Lab 5 (PDF)

• ZONING table (PDF)
• 1980 census characteristics (PDF)

Lab 6 (PDF)