spatial-sql

A cluster computing framework for processing large-scale geospatial data

A single-node analytical database engine with geospatial as a first-class citizen

A benchmark for assessing geospatial SQL analytics query performance across database systems

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.

Esercitazione guidata sui database geospaziali

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

Production-grade engineering reference for automated parcel & property boundary data pipelines — PostGIS/Shapely/GeoPandas ETL, cadastral data architecture & standards, and topology repair.

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

PostGIS analysis of global land surface exposure by geologic period

Production patterns for spatial data on Apache Iceberg and Delta Lake — partitioning, predicate pushdown, query engines (DuckDB/Trino/Sedona), GeoParquet, and Python workflows. An engineering reference site.

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.

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

Production-focused guides and runnable Python, SQL & CLI recipes for automating SpatiaLite & GeoPackage — offline-first spatial databases: format internals, serialization, R-tree indexing, transactions, and field sync.

Interactive scrollytelling map of Austin urban heat: summer land surface temperature vs tree canopy, impervious surface, and income across 65 neighborhoods. Earth Engine, PostGIS, R, Leaflet.

Fully client-side GIS conflict-analysis dashboard: DuckDB-WASM spatial SQL over static GeoParquet + geokit, a Rust→WASM geometry module (geodesic buffer / H3 indexing / KMZ) built on mature Rust geo crates. Runs entirely in the browser, hosted on GitHub Pages.

A PostGIS‑driven geospatial workflow that builds a hex‑grid flood‑risk surface by integrating road geometry, hydrology proximity metrics, and terrain features into a reproducible spatial analysis pipeline.

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.

Production-grade spatial data pipelines with dbt, PostGIS, and DuckDB — practical guides on CRS governance, geometry validation, spatial macros, and CI testing.

Dockerized PostGIS demo screening candidate solar/wind sites against grid proximity and protected land, tagged with real South African municipal boundaries (MDB shapefile).