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 2014


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

2

Relational Database Management, Geospatial Data, and Enterprise GIS

Lecture

Thurs. 6 Feb.

3

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

Lab 2

Tues.11 Feb.

4

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

Lecture

Thurs. 13 Feb.

  President's Day schedule - no class or lab since day follows Monday schedule   Tues. 18 Feb.

5

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

Lecture
+Lab 3

Thurs. 20 Feb.

 

 

 

 

Part II 

Integrating Mapping and DBMS

Session #

Title

Type

Date

6

Mapping Boston Parcels and Property Sales

Lab 4

Tues. 25 Feb.

7

Advanced SQL, Referential Integrity and Relational Database Design

Lecture

Thurs.27 Feb.

8

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

Lab 5

Tues. 4  Mar.

9

Review of SQL Homework and GIS-RDBMS Integration

Lecture

Thurs. 6 Mar.

10

Metro Boston Modeling using TINs, Model Builder and Community Viz

Lab 6

Tues. 11 Mar.

11

Database Design, Distributed GIS, and Urban Modeling

Lecture

Thurs.13 Mar.

12

In-lab test

Test

Tues. 18 Mar.

13

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

Lecture

Thurs. 20  Mar.

 

 

 

 

11.523 Ends and 11.524 Begins

 

 

 

 

Part III 

GIS Project

Session #

Title

Type

Date

14

Project intro (See Projects webpage)

 

Tues. 1 April

15 Project planning

Thurs. 3 April
16 project work

Tues. 8 April
17 Project planning with Clients

Thurs. 10 April
18 project work

Tues. 15 April
19 project work

Thurs. 17 April

Holiday - no class or lab

Tues. 22 April
20 project work

Thurs. 24 Apil

21

project work

 

Tues. 29 April

22

project work

 

Thurs. 1 May

23

project work

 

Tues. 6 May

24

project work

 

Thurs. 8 May

25

Project Writeup and Class Wrapup

 

Tues. 13 May

26 Project Presentation

Thurs. 15 May
   

 

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