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 2015


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

2

Relational Database Management, Geospatial Data, and Enterprise GIS

Lecture

Thurs. 5 Feb.

3

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

Lab 2

Tues.10 Feb.

4

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

Lecture

Thurs. 12 Feb.

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

5

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

Lecture
+Lab 3

Thurs. 19 Feb.

 

 

 

 

Part II 

Integrating Mapping and DBMS

Session #

Title

Type

Date

6

Mapping Boston Parcels and Property Sales

Lab 4

Tues. 24 Feb.

7

Advanced SQL, Referential Integrity and Relational Database Design

Lecture

Thurs.26 Feb.

8

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

Lab 5

Tues. 3   Mar.

9

Review of SQL Homework and GIS-RDBMS Integration

Lecture

Thurs. 5 Mar.

10

Metro Boston Modeling using TINs, Model Builder and Community Viz

Lab 6

Tues. 10 Mar.

11

Database Design, Distributed GIS, and Urban Modeling

Lecture

Thurs.12 Mar.

12

In-lab test

Test

Tues. 17 Mar.

13

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

Lecture

Thurs. 19   Mar.

 

 

 

 

11.523 Ends and 11.524 Begins

 

 

 

 

Part III 

GIS Project

Session #

Title

Type

Date

14

Project intro (See Projects webpage)

 

Tues. 31 Mar

15 Project planning

Thurs. 2 April
16 project work

Tues. 7 April
17 Project planning with Clients

Thurs. 9 April
18 project work

Tues. 14 April
19 project work

Thurs. 16 April

Holiday - no class or lab

Tues. 21 April
20 project work

Thurs. 23 Apil

21

project work

 

Tues. 28 April

22

project work

 

Thurs. 30 April

23

project work

 

Tues. 5 May

24

project work

 

Thurs. 8 May

25

Project Writeup and Class Wrapup

 

Tues. 12 May

26 Project Presentation

Thurs. 14 May
   

 

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