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 2013

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

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

*11.523 Ends and 11.524 Begins*

Part III	GIS Project
Session #	Title	Type	Date
14	Project intro (See Projects webpage)		Tues. 2 April
15	Project planning		Thurs. 4 April
16	project work		Tues. 9 April
17	Project planning with Clients		Thurs. 11 April
18	Holiday - no class or lab		Tues. 16 April
19	project work		Thurs. 18 April
20	project work		Tues. 23 April
21	project work		Thurs. 25 Apil
22	project work		Tues. 30 April
23	project work		Thurs. 2 May
24	project work		Tues. 7 May
25	project work		Thurs. 9 May
26	Project Writeup and Class Wrapup		Tues. 14 May
27	Project Presentation		Thurs. 16 May