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)