Course data

• GEP 664 Sample Database (please read the instructions for accessing databases)
• ZIP File for Practical SQL tutorial data (the host website is here)
• ZIP file for PostGIS in Action tutorial data (the host website is here)

Metadata

Basic and detailed documentation for the NOAA weather data in the course database

Data for homework assignments

• Class 3 Data (SQL DDL) NYS ACS table: county workers by MCD
• Class 5 Data (Data processing) Original Unprocessed Copper data
• Class 5 Data (3 processed tables) copper_working.xlsx
• Class 7 Data (Spatial Reference Systems) tract pop centers, zctas, countries, copper backup
• Class 9 Data – Airports Backup Table
• Extra Credit Data

Software

• PostgreSQL & PostGIS from EnterpriseDB (please read the instructions for installing the database software)
• QGIS 3.4 Madeira