Spatial decomposition without space filling curves

An Approximate Deep Spatial Catalog and Search

Pirate Puzzle Game

Check and force SDE databases back online after they were taken offline for automated maintenance, etc.

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.

Generate GeoAlchemy2 and SQLAlchemy 2.0 declarative models from a live PostGIS database, complete with geometry types, SRIDs, spatial indexes, enums and foreign-key relationships — plus typed spatial query helpers for ST_DWithin, KNN and bounding-box searches. Works from a live DSN or a shareable JSON schema description.

Spatial & metric-space indexing from scratch in Python: an STR bulk-loaded R-tree and an iDistance/pivot similarity-search index, with range + kNN queries and benchmarks.

Python-based user interaction with a spatial database via Psycopg2. In the context of a simulated festival, a user can dynamically query information about food stalls, performers, tents, etc. Includes a map result in a pop-up window.

Diagnose PostGIS performance problems from a PostgreSQL EXPLAIN plan. Parses JSON and text EXPLAIN (ANALYZE, BUFFERS) output, runs ten spatial rules — missing GiST index, ST_Distance instead of ST_DWithin, loose bounding-box rechecks, un-indexed KNN, SRID transforms defeating the index — and prints an annotated tree, JSON or Markdown.

Spatial database layer for ndstore

Pytest plugin providing an ephemeral PostGIS database and deterministic, realistic spatial fixture data. Seeded generators for clustered points, routes and polygons across multiple CRSs, ready-made datasets with GiST/BRIN DDL, a COPY bulk loader, an edge-case catalogue, and spatial assertion helpers including EXPLAIN index checks.