Calendar

LEC # TOPICS READINGS
           Part I: Spatial Information and Database Management
1

Introduction to the Course, Oracle, and SQLplus

The ‘Marriage’ of Planners and Data

 
2 Relational Database Management, Geospatial Data

  • Worboys , Michael F. GIS: A Computing Perspective. London: Taylor & Francis, 1995. Pp. 45-67.
  • Trimble, J. Harvey, Jr., and David Chappell.  A Visual Introduction to SQL. New York: John Wiley & Sons, 1989. Chapters 1, 3, and 4.

3 Handling One-to-Many Relations - Grouping and Aggregation

  • Trimble and Chappell. Chapters 5, 7, and 8.

4 Advanced SQL - Subqueries and Complex joins

  • Trimble and Chappell. Chapter 6.

5 Distributed Access to Parcel-Level City Databases

  • Zoning variance database help pages
  • Ferreira, Joseph Jr. “Information Technologies that Change Relationships between Low-Income Communities and the Public and Non-profit Agencies that Serve Them.” Forthcoming Chapter 7 in MIT Press Book from Spring 1996 DUSP colloquium on High Technology and Low-Income Communities.
  • Top-down and bottom-up strategies for ‘cleaning’ official administrative databases
  • Using lookup tables to interpret read-only city data
  • Strategies for encoding, accumulating, and utilizing local knowlege

6

The Zoning Variance Database & Advanced Query Construction

Due: Problem Set 1

  • Trimble and Chappell. Chapters 9 and 11.

7 Referential Integrity and Relational Database Design

  • Worboys. Pp. 68-84 (Optional: pp. 84-95).

8 Querying Oracle from a Client Application and Databases on Web  
Part II: Integrating Mapping and DBMS
9

Adding Z and Integrating Mapping with RDBMS Tools I

Due: Problem Set 2

  • Flowerdew, R. “Spatial data integration.” Chap. 24 in Geographical Information Systems: Principles and Applications. Vol. 1. Edited by D. J. Maguire, M. F. Goodchild, and D. W. Rhind. 1991. [In Reader]
  • Craig. “Why we couldn’t get the data we wanted.” Journal of the Urban and Regional Information Systems Association (URISA) 4, 2 (1992). [In Reader]

10 Integrating Mapping with RDBMS Tools II  
11 Examination  
12 Using ArcView Spatial Analyst  
13

Using ArcView Spatial Analyst with Oracle Data

Due: Problem Set 3

 

LEC # TOPICS READINGS
11.524 - GIS Project
14

Introduction to Course and Project

Project: Implementing a Neighborhood Information System

15 Metadata and MIT’s Geodata Tool

16 ESRI’s Spatial Database Engine

17 Serving Maps on the Web  
18 On-site Visit and Meeting with Client  
19 Meeting with Consultant  
20 Project Work  
21 On-site Work with Client  
22 Project Work  
23 Project Work  
24

Internal Project Presentation

Project Due: Implementing a Neighborhood Information System

 
25 On-Site Project Presentation  
26 Challenges, Opportunities, and Next Steps  

Course Info

As Taught In
Spring 2003
Level
Learning Resource Types
Problem Sets
Exams
Lecture Notes
Projects
Programming Assignments with Examples