Popular repositories Loading

1. postgis-python.com postgis-python.com Public

   Production-grade PostGIS + Python documentation: spatial queries, GiST indexing, SQLAlchemy/GeoAlchemy2 integration, schema migrations, and performance tuning — runnable SQL + Python, no pseudocode.

   Nunjucks

2. postgis-explain-visualizer postgis-explain-visualizer Public

   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_…

   Python

3. spatial-index-advisor spatial-index-advisor Public

   Analyses PostgreSQL query workloads and PostGIS table statistics, then recommends spatial indexes — GiST, SP-GiST, BRIN, partial, composite — plus clustering, index drops and query rewrites. Reads …

   Python

4. postgis-fixtures postgis-fixtures Public

   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…

   Python

5. geoalchemy-model-generator geoalchemy-model-generator Public

   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 spati…

   Python

6. st-function-cheatsheet st-function-cheatsheet Public

   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…

   Python