Calendar · Lecture Notes
MIT OpenCourseWare
Spatial Database Management and Advanced Geographic Information Systems
- Instructors
- Prof. Joseph Ferreira, Prof. Lorlene Hoyt
- Term
- Spring 2003
- Level
- Graduate
- What's inside
- 1 exam · 1 lecture note · 1 reading · 68 other files · 7 web pages
- Materials open
- MIT OCW
About this course
Source: MIT OpenCourseWare 11.521 Spatial Database Management and Advanced Geographic Information Systems, Spring 2003, Prof. Joseph Ferreira, Prof. Lorlene Hoyt — original course page on ocw.mit.edu ↗. License: CC BY-NC-SA 4.0. Study order: MIT's own listing order, section by section. Taken from MIT's published course files, downloaded from ocw.mit.edu on September 23, 2026. How RedLectern is built.
Materials are grouped the way MIT organized them. A verified, course-wide order has not been established here.
Before you start
Prerequisites are not listed here. Check MIT's own syllabus for this course.
How this course was organized
What's here, and what isn't
- MIT's own materials here did not support a verified, course-wide order, so they are grouped by section instead.
Not included here
26 items from the source could not be safely included:
- MIT's page format for this item wasn't recognized clearly enough to place it safely. (26 items)
Materials by section
Grouped by section, as MIT organized them. Not sequenced or ordered.
Lecture Notes
30 files
- Lab 6 Download
- Lecture 1 - Introduction: Planners and Data Download
- The Marriage: Planners & Data Download
- Lecture 2 - Relational Database Management Download
- Lecture 3 - Handling One to Many Relations Download
- Lecture 4 - Subqueries and Complex Joins Download
- Lecture 5 - Parcel Level City Databases Download
- PowerPoint slides Download
- Queries that we will run Download
- Lecture 6 - Zoning Variance Databases Download
- Lecture 7 - Referential Integrity Download
- Problem Statement Download
- Proposed Solution Download
- Lecture 8 - Querying Oracle Download
- Lecture 9 - Database Design Download
- Create SQL (lect9createsql.pdf) Download
- Insert SQL (lect9insertsql.pdf) Download
- Schema Version I Download
- Schema Version II Download
- Schema Version III Download
- Schema Version III-2 Download
- Schema Version III-3 Download
- Schema Version IV Download
- Lecture 10 - Lab 5 Download
- Lecture 13 - Wrap up of Modeling Download
- Review of Raster Modeling - Lorlene Hoyt’s Spring 2002 notes Download
- Density maps, contour plots - Lorlene Hoyt’s Spring 2002 notes Download
- Adding ‘Z’: 3D CAD models & 2.5D surface models: lattice mesh - Lorlene Hoyt’s Spring 2002 notes Download
- Problem Set 3 Download
- Practice Exam Download
Labs
Exams
Projects
12 files
- Here is the list for all the data layers available now: ( data layer list ) Download
- Baltimore Download
- Los Angeles Download
- Oakland Download
- Philadelphia Download
- Providence Download
- Map of the Reviviendo Gateway Overlay (RGO) District Download
- Submitted Zoning Description Download
- Zoning Analysis Download
- Zoning Overlay District Overview Download
- Zoning Process and Timeline Download
- Question and Answers about RGO Download
Tools
19 files
- Lab 1 Download
- 1980 Census data (by Boston NSA) / Schema of Decision, Use, NSA, Neighbrhd Lookup Tables Download
- SQL HELP Download
- SQL help Download
- PARCELS database Download
- FIRES Download
- OWNERS Download
- PARCELS Download
- PERMITS Download
- SALES Download
- TAX Download
- ZONING Download
- URISA database Download
- Outer Join help Download
- ZONING database Zoning Variances / Sub-Neighborhood lookup table Download
- SQL examples using zoning variances Download
- Grouping zoning applicants via ’lookup’ tables Download
- Zoning Variance Database Evolution Chart Download
- SQL*Plus Formatting and Documentation Notes Download
Other materials from this course
Course outline
Calendar · Lecture Notes
Lecture 2: Relational Database Management, Geospatial Data
Calendar · Lecture Notes
Lecture 3: Handling One-to-Many Relations - Grouping and Aggregation
Calendar · Lecture Notes
Lecture 4: Advanced SQL - Subqueries and Complex joins
Calendar · Lecture Notes
Lecture 5: Distributed Access to Parcel-Level City Databases
Calendar · Lecture Notes
Lecture 6: The Zoning Variance Database & Advanced Query Construction Due: Problem Set 1
Calendar · Lecture Notes
Lecture 7: Referential Integrity and Relational Database Design
Calendar · Lecture Notes
Lecture 8: Querying Oracle from a Client Application and Databases on Web
Calendar · Lecture Notes
Lecture 9: Adding Z and Integrating Mapping with RDBMS Tools I Due: Problem Set 2
Calendar · Lecture Notes
Lecture 10: Integrating Mapping with RDBMS Tools II
Calendar · Lecture Notes
Lecture 11: Examination
Calendar · Lecture Notes
Lecture 12: Using ArcView Spatial Analyst
Calendar · Lecture Notes
Lecture 13: Using ArcView Spatial Analyst with Oracle Data Due: Problem Set 3
MIT OpenCourseWare, Prof. Joseph Ferreira, Prof. Lorlene Hoyt, 11.521 Spatial Database Management and Advanced Geographic Information Systems, Spring 2003.
License: CC BY-NC-SA 4.0 · Edition: Spring 2003 · Open the original course on OCW ↗
Organized by RedLectern, independent of MIT and not endorsed by MIT.
Per-resource rights are recorded on each resource; All-Rights-Reserved items are link-only, never mirrored.
