| Lecture 1 |
- Introduction To 11.208 And Thematic Mapping
Producing and printing thematic maps
|
|
| 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)
|
|
| 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
|
|
| 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 |
|
|