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 2010

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

Part II	Integrating Mapping and DBMS
Session #	Title	Type	Date
6	Mapping Boston Parcels and Property Sales	Lab 4	Tues. 23 Feb.
7	Advanced SQL, Referential Integrity and Relational Database Design	Lecture	Thurs. 25 Feb.
8	Developing a Land Value Map for Boston using ArcGIS Spatial Analyst and Model Builder	Lab 5	Tues. 2 Mar.
9	Model Builder, Spatial Analyst, and SQL Review	Lecture	Thurs. 4 Mar.
10	In-lab test	Test	Tues. 9 Mar.
11	Database Design, Distributed GIS, and Urban Modeling	Lecture	Thurs.11 Mar.
12	Boston Metro Modeling using Community Viz	Lab 6	Tues. 16 Mar.
13	Metro Boston Modeling, Community Viz, Geospatial Services, and Project Intro	Lecture	Thurs. 18 Mar.

*11.523 Ends and 11.524 Begins*

Part III	GIS Project
Session #	Title	Type	Date
14	Project intro		Tues. 30 Mar.
15	Project planning		Thurs. 1 April
16	project work		Tues. 6 April
17	Project planning with Clients		Thurs. 8 April
18	project work		Tues. 13 April
19	project work		Thurs. 16 April
20	Holiday - no class or lab		Tues. 20 April
21	project work		Thurs. 22 Apil
22	lab		Tues. 26 April
23	project work		Thurs. 29 April
24	lab		Tues. 4 May
25	project work		Thurs. 6 May
26	Project Writeup and Class Wrapup		Tues. 11 May
27	Project Presentation		Thurs. 13 May