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 2016


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.  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. 1   Mar.

9

Review of SQL Homework and GIS-RDBMS Integration

Lecture

Thurs. 3 Mar.

10

Metro Boston Modeling using TINs, Model Builder and Community Viz

Lab 6

Tues. 8 Mar.

11

Database Design, Distributed GIS, and Urban Modeling

Lecture

Thurs.10 Mar.

12

In-lab test

Test

Tues. 15 Mar.

13

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

Lecture

Thurs. 17   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. 29 Mar

15 Web mapping exercises with project-related data

Thurs. 31 Mar
16 Project intro (See Projects webpage)

Tues. 5 April
17 Project planning with Clients

Thurs. 7 April
18 project work

Tues. 12 April
19 project work

Thurs. 14 April

Holiday - no class or lab

Tues. 19 April
20 project work

Thurs. 21 Apil

21

project work

 

Tues. 26 April

22

project work

 

Thurs. 28 April

23

project work

 

Tues. 3 May

24

project work

 

Thurs. 5 May

25

Project Writeup and Class Wrapup

 

Tues. 10 May

26 Project Presentation

Thurs. 12 May
   

 

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