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

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

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

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.

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

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

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

Production PostGIS patterns & best practices for PostgreSQL spatial databases: GiST/SP-GiST/BRIN spatial indexing, spatial joins & nearest-neighbor queries, SRID & coordinate systems, vector tiles (ST_AsMVT), geometry data quality, partitioning. Runnable SQL examples with Docker.

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.

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

DuckDB Spatial patterns for analytical geospatial SQL: reading GeoJSON, GeoParquet & CSV in place, spatial joins, nearest-neighbor (KNN), coordinate systems & the EPSG axis-order trap, GeoParquet export & partitioning, and H3 hexagon aggregation — runnable examples with checks, no database server required.