Course handouts

• Course Syllabus (Spring 2019)
• Installing PostgreSQL & PostGIS
• Accessing PostgreSQL & PostGIS Databases
• Homework Submission Guidelines
• SQL Homework Template
• Final Project

Textbooks

• Practical SQL by Anthony DeBarros, No Starch Press 2018
• PostGIS in Action 2nd edition by Regina Obe and Leo Hsu, Manning Publications 2015

Course Reserves

• Additional readings are available on the Lehman library’s e-reserve page.

In-Class Exercises (Frank’s Notes)

• exercise2_inclass – SQL SELECT
• exercise3_inclass – SQL CREATE
• exercise3_inclass – Continent GDP CSV
• exercise4_inclass – ER Model
• exercise4_inclass – ER Model GIS Workshop Example
• exercise5_inclass – Data Cleaning
• exercise6_inclass – Geometry Basics
• exercise7_inclass – Spatial Reference Systems
• exercise8_inclass – Spatial Relationships
• exercise8_inclass – Hurricane Evac Shapefile
• exercise9_inclass – Geography vs Geometry Example
• exercise10_inclass – Validating Geometry
• exercise11_inclass – 2PFCA
• exercise12_inclass – Rasters
• exercise14_inclass – Python

Software documentation

• PostgreSQL 10 Manual
• PostgresSQL Commands Reference
• psql Slash Commands
• SQL Cheat Sheet (Will be used for the midterm)
• Another SQL Cheat Sheet
• PostGIS 2.4 Manual