MIT 11.521/11.523/11.524 Lecture Notes

Massachusetts Institute of Technology - Department of Urban Studies and Planning

11.521	Spatial Database Management and Advanced Geographic Information Systems
11.523	Fundamentals of Spatial Database Management
11.524	Advanced Geographic Information System Project

Lecture Notes - Spring 2018

Part I	Spatial Information and Database Management
Session #	Title	Type	Date
1	Review of ArcMap & Introduction to Data Management with Postgres, Access, Excel	Lab 1	Tues. 6 Feb.
2	Relational Database Management, Geospatial Data, and Enterprise GIS	Lecture	Thurs. 8 Feb.
3	Land Use and Land Value Patterns in East Boston: Getting Comfortable with Relational Queries and Map-Database-Spreadsheet Interaction	Lab 2	Tues. 13 Feb.
4	Handling One-to-Many Relations + Joins, Grouping, Aggregation, & Subqueries	Lecture	Thurs. 15 Feb.
	President's Day schedule - no class or lab since day follows Monday schedule	+PSet A	Tues. 20 Feb.
5	Accumulating and Sharing Local Knowledge: Categorizing Zoning Variances using Database Rules, Lookup Tables	Lecture	Thurs. 22 Feb.

Part II	Integrating Mapping and DBMS
Session #	Title	Type	Date
6	Mapping Boston Parcels and Property Sales	Lab 4	Tues. 27 Feb.
7	Advanced SQL, Referential Integrity and Relational Database Design	Lecture	Thurs. 1 Mar.
8	Developing a Land Value Map for Boston using ArcGIS Spatial Analyst and Model Builder	Lab 5	Tues. 6 Mar.
9	Review of SQL Homework and GIS-RDBMS Integration	Lecture	Thurs. 8 Mar.
10	Metro Boston Modeling using TINs, Model Builder and Community Viz	Lab 6	Tues. 13 Mar.
11	Database Design, Distributed GIS, and Urban Modeling	Lecture	Thurs.15 Mar.
12	In-lab test	Test	Tues. 20 Mar.
13	Metro Boston Modeling, VMT & Built Environment Measures, Geospatial Services, and Project Intro / PostGIS and QGIS	Lecture	Thurs. 22 Mar.

*11.523 Ends and 11.524 Begins*

Part III	GIS Project
Session #	Title	Type	Date
14	Intro to Web Mapping and Geoprocessing Services		Tues. 3 Apr.
15	Web mapping exercises with project-related data		Thurs. 5 Apr.
16	Project intro (See Projects webpage)		Tues. 10 April
17	Project planning with Clients		Thurs. 12 April
	Holiday - no class or lab		Tues. 17 April
18	project work		Thurs. 19 April
19	project work		Tues. 24 April
20	project work		Thurs. 26 April
21	project work		Tues. 1 May
22	project work		Thurs. 3 May
23	project work		Tues. 8 May
24	project work		Thurs. 10 May
25	Project Writeup and Class Wrapup		Tues. 15 May
26	Project Presentation		Thurs. 17 May