Show HN: PostGIS query editor and visualizer(github.com) |
Show HN: PostGIS query editor and visualizer(github.com) |
So this could be quite useful for PostGIS developers; For instance, often i just need to know how "rough" is the approximate bounding box drawn by PostGIS; a visual comparison with the region's actual borders is often the best and most efficient way to learn this.
What might make sense is to support to display several SQL queries at once. So you can show the the objects within a cluster and the cluster bounds at the same time.
For complex visualizations you can use e.g. QGIS with PostGIS as data source. I used PostGIS editor before to prototype clustering SQL queries. I assign cluster values as attributes and inspect them like this.