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 2017


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.  7 Feb.

2

Relational Database Management, Geospatial Data, and Enterprise GIS

Lecture

Thurs. 9 Feb.

3

Land Use and Land Value Patterns in East Boston: Getting Comfortable with Relational Queries and Map-Database-Spreadsheet Interaction

Lab 2

Tues.  14 Feb.

4

Handling One-to-Many Relations + Joins, Grouping, Aggregation, & Subqueries

Lecture

Thurs. 16 Feb.

  President's Day schedule - no class or lab since day follows Monday schedule  +PSet A Tues. 21 Feb.

5

Accumulating and Sharing Local Knowledge: Categorizing Zoning Variances using Database Rules, Lookup Tables

Lecture

Thurs. 23 Feb.

 

 

 

 

Part II 

Integrating Mapping and DBMS

Session #

Title

Type

Date

6

Mapping Boston Parcels and Property Sales

Lab 4

Tues. 28 Feb.

7

Advanced SQL, Referential Integrity and Relational Database Design

Lecture

Thurs. 2 Mar.

8

Developing a Land Value Map for Boston using ArcGIS Spatial Analyst and Model Builder  

Lab 5

Tues. 7   Mar.

9

Review of SQL Homework and GIS-RDBMS Integration

Lecture

Thurs. 9 Mar.

10

Metro Boston Modeling using TINs, Model Builder and Community Viz

Lab 6

Tues. 14 Mar.

11

Database Design, Distributed GIS, and Urban Modeling

Lecture

Thurs.16 Mar.

12

In-lab test

Test

Tues. 21 Mar.

13

Metro Boston Modeling, VMT & Built Environment Measures, Geospatial Services, and Project Intro  / PostGIS and QGIS

Lecture

Thurs. 23   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. 4 Apr.

15 Web mapping exercises with project-related data

Thurs. 6 Apr.
16 Project intro (See Projects webpage)

Tues. 11 April
17 Project planning with Clients

Thurs. 13 April

Holiday - no class or lab

Tues. 18 April
18 project work

Thurs. 20 April
19
project work

Tues. 25 April
20 project work

Thurs. 27 April

21

project work

 

Tues.  2 May

22

project work

 

Thurs. 4 May

23

project work

 

Tues. 9 May

24

project work

 

Thurs. 11 May

25

Project Writeup and Class Wrapup

 

Tues. 16 May

26 Project Presentation

Thurs. 18 May
   

 

Home | Syllabus | Lectures | Labs | CRON | MIT
http://mit.edu/11.521/lectures - last   modified: 25 Jan.. 2017 [jf]