Core Fundamentals & Architecture
The execution boundaries that separate a brittle GIS script from a reproducible dbt pipeline. Choose the right spatial adapter, set up PostGIS or DuckDB, design dependency graphs, and wire spatial validation into CI.
dbt + Geospatial Transforming Spatial Data in the Modern Stack
This site exists to help analytics engineers, data platform teams, GIS backend developers, and spatial data scientists build production-grade spatial data pipelines using dbt, PostGIS, and DuckDB. It focuses on practical implementation, spatial accuracy, and pipeline reliability — not theoretical GIS concepts.
Each guide is structured around the realities of running spatial workloads inside a version-controlled, DAG-driven warehouse: enforcing CRS governance, materializing GIST indexes via post-hooks, isolating heavy spatial joins from the mart layer, and wiring topology checks into CI so coordinate drift never reaches production.
What you'll find here
Spatial Data Architecture & Governance
Treat geometry, topology, and coordinate systems as first-class citizens. Manage SRIDs, version spatial schemas, scope access for location data, and handle datasets that exceed warehouse memory budgets.
Advanced Spatial Macros & UDF Patterns
Compile-time abstraction vs. runtime execution. Build reusable spatial macros, optimize proximity joins, use index hints intelligently, and chain deterministic geometry transformation pipelines.
Designed for the modern analytics stack
Every page assumes you already speak SQL, Jinja, and DAGs. Code samples target PostGIS,
DuckDB Spatial, Snowflake GEOGRAPHY, and BigQuery
GEOGRAPHY — with explicit notes when behaviour diverges.