Tools

This is an in-depth introduction to using SQL, and includes the databases for the class.

SQL HELP (PDF)

SQL setup (Lab 1 exercise for running SQL*Plus from CRL and WinAthena PCs) (PDF)
SQL help (PDF)
PARCELS database (PDF)
- FIRES (PDF)
- OWNERS (PDF)
- PARCELS (PDF)
- PERMITS (PDF)
- SALES (PDF)
- TAX (PDF)
- ZONING (PDF)
URISA database (PDF)
Outer Join help (PDF)
ZONING database
- Zoning Variances / Sub-Neighborhood lookup table (PDF)
- 1980 Census data (by Boston NSA) / Schema of Decision, Use, NSA, Neighbrhd Lookup Tables (PDF)
- SQL examples using zoning variances (PDF)
- Grouping zoning applicants via ’lookup’ tables (PDF)
  - Clark Broida’s Zoning database (PDF)
- Zoning Variance Database Evolution Chart (PDF)
SQL*Plus Formatting and Documentation Notes (PDF)