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 |
|
3 | Handling One-to-Many Relations - Grouping and Aggregation |
|
4 | Advanced SQL - Subqueries and Complex joins |
|
5 | Distributed Access to Parcel-Level City Databases |
|
6 |
The Zoning Variance Database & Advanced Query Construction Due: Problem Set 1 |
|
7 | Referential Integrity and Relational Database Design |
|
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 |
|
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 |