Modern GIS Workshop

Welcome! This repo contains the code and guides used for the I-Guide Forum 2023 at Columbia University. The slides for this workshop can be found here.

Requirements

• VS Code (preferred but any IDE will work)
• Docker
• DuckDB
• dbt
• pgAdmin
• Optional
  • GDAL (will install with Docker)
  • QGIS

Data Downloads

• NYC Flood Plains
• NYC Building Footprints
• NYC 1-foot DEM
  • Clipped DEM
• NOAA Historical Weather Events

Workshop

Part 1: GeoParquet

• Link to code

Part 2: PostGIS

• Link to code

Part 3: DuckDB

• DuckDB Docs
• Link to code

Part 4: dbt

• Installing dbt
• Link to code

Part 5: H3

• Link to code