| Ses # | Topics | Notes |
|---|---|---|
| Lecture 1 |
Introduction To 11.208 And Thematic Mapping Producing and printing thematic maps |
Part I: (PDF) Part II: (PDF) |
| Lab A | Building and printing a simple map from database tables and boundary files | |
| Lecture 2 |
Crime Case Study and Elementary Database Management Case study in analytic mapping Getting data into a database (data import, entry) Simple queries on a database (selecting fields and records, simple aggregation) Getting data out of the database (data export) |
Part I: (PDF) Part II: (PDF) |
| Lab B | Essential database operations: data input, simple queries, output. | |
| Lecture 3 |
Making Sense Of The Census, Part I The 1990 Census of Population and Housing Tools to extract census data Using census data: normalization, comparisons over time | (PDF) |
| Lecture 4 |
Introduction To Relational Databases, Part I Introduction to the relational model Intermediate queries: aggregation functions (grouping), multi-table queries | (PDF) |
| Lab C | Build and run queries on survey data and urban management records | |
| Lecture 5 |
Making Sense Of The Census, Part II The 1990 Census of Population and Housing Tools to extract census data Using census data: normalization, comparisons over time |
Part I: (PDF) Part II: (PDF) Part III: (PDF) Part IV: (PDF) Part V: (PDF) |
| Lab D | Extracting Census data from STF files | |
| Lecture 6 |
Principles Of Relational Databases, Part II Problem Set handed out prior day. Elements of database design The relational model of data including "One-to-many" relationships among data tables Introduction to Structured Query Language (SQL) | (PDF) |
| Lecture 7 |
Database Management In Planning An overview of planning uses of database management, both now and in the future. | (PDF) |
| Lab E | Lab session emphasizing Census data and applying the relational model | |
| Lecture 8 |
Preparing Effective Maps Tips on preparing maps that communicate accurately, clearly, and persuasively | (PDF) |
| Lab F | Enhancing the accuracy, clarity and persuasiveness of the map | |
| Lecture 9 |
Spatial Analysis And Internet Overview Introduction to Internet and GIS mapping resources Web mapping resources | (PDF) |
| Lab G | Integrating orthophotos with census data | |
| Project Demo |
Exhibition Of Planning Software And PSS Research Demonstrations of software tools for mapping and spatial analysis | |
| Lecture 10 |
Course Summary Introduction to geographical information systems and course summary | (PDF) |
| Panel Discussion |