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
   

 

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