My PostGIS tracks land acquisition and field work for an energy company, and I needed to share a map with my boss.
First I tried QGIS Cloud. It worked but drove me crazy. It copies your PostGIS instead of using the existing connection, so every database update requires a full redeploy to be seen on the map. I gave up on it
Felt was next, but PostGIS connections require an Enterprise subscription. Similar thing with Atlas: $89/month for PostGIS connections.
Finally, I found Dekart, an impressive project built on kepler.gl. I had a blast playing around with Dekart. However, it runs SQL queries and ships static files to the browser. I wanted live-streamed data from PostGIS to the web.
So I built my own solution. PostGIS Frontend is open-source, self-hosted, and free. It's an interface designed for both GIS analysts and non-technical users to:
- Connect to any PostGIS database from the browser
- Import any spatial format (ArcGIS Feature Server, GeoPackage, GeoJSON, KML, SHP, CSV, XLSX) into PostGIS
- Visualize large datasets
- Share live maps with anyone
You can check it out here: