spatial-sql

Native DuckDB extension with Jev-style SQL functions backed by a local Laya model, with NorthSea spatial examples

MCP server for spatial analysis over remote GeoParquet files, read in place by DuckDB — no import step, predicate and projection pushdown into the remote Parquet.

AtlasSQL-BR: A Brazilian Portuguese Geospatial Text-to-SQL Dataset with Spatial Hierarchies

High-Performance DuckDB Spatial Studio & Cloud GeoParquet Engine for QGIS

Full-stack GIS routing MVP using PostGIS, pgRouting, Flask, Docker, and Leaflet for route alternatives, blocked zones, and traffic-point simulation.

A reproducible geospatial analytics platform for exploring neighbour change across Toronto.

Reproducible PostGIS spatial-SQL pipeline for geospatial site screening: Docker, pinned open data, tests, CI.

PostGIS analysis of global land surface exposure by geologic period

Spatial-SQL (DuckDB) screen of hospitals, nursing homes, schools and fire/EMS in FEMA flood zones, Texas Gulf Coast

Spatial Queries To MapReduce Translator ( Hadoop GIS functionality for spatial Big Data )

Curated, example-driven reference for 92 PostGIS ST_* functions and spatial operators. Every entry has a SQL example with its real result, psycopg and GeoAlchemy2 snippets, SRID gotchas, GiST index behaviour and common mistakes. Search from the terminal, or generate a single self-contained searchable HTML page.

Databricks pipelines joining demographic records to GB geographic reference data: NHSPD, ODS, LSOA/ICB boundaries, Census 2021; spatial joins, versioning, reconciliation, pseudonymisation, disclosure control

End-to-end geospatial data engineering pipeline using Python, GeoPandas, PostgreSQL/PostGIS, spatial SQL, climate-risk analysis, and pipeline monitoring.

End-to-end GIS data engineering pipeline: Natural Earth → GeoParquet QA → DuckDB Spatial analytics → GitHub Pages Leaflet map.

Serves validated farmland boundaries as RFC 7946 GeoJSON from a PostGIS materialized view. FastAPI, SQLAlchemy, psycopg2, Docker Compose.