2D R-Tree spatial indexing with Minimum Bounding Boxes (MBR) and spatial range intersection queries
2D R-Tree spatial indexing with Minimum Bounding Boxes (MBR) and spatial range intersection queries
Spatial decomposition without space filling curves
A full-stack wilderness editor for LuminariMUD with advanced drawing tools, precision coordinate system, and real-time validation.
An Approximate Deep Spatial Catalog and Search
Pirate Puzzle Game
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.
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.
Check and force SDE databases back online after they were taken offline for automated maintenance, etc.
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.
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.
Spatiotemporal database and architecture for campus last-mile food delivery
To associate your repository with the spatial-database topic, visit your repo's landing page and select "manage topics."