Awesome
PostGIS Query Editor
:warning: This repository is no longer maintained by Lukas Martinelli.
A very accessible PostGIS query editor and visualizer. Getting started with PostGIS is harder than it should be. We spent much time in psql and wished to visualize our queries quickly without big complicated tools.
Features:
- Just type your query - we try to figure out the geometry/projection
- Beautiful MapboxGL based visualization
- Click on any feature for full information
- Table view to jump to important features
- Display 100k objects with ease
- Cross platform support for Windows, OSX and Linux
Install
Download the app for your platform from the releases page.
Now unzip the release and either execute postgis-editor.app for OSX, postgis-editor.exe for Windows or postgis-editor for Linux.
If this project gains traction we can start building installers for Windows and create packages for different Linux distros. You can also clone the repo and run postgis-editor directly with npm.
Introduction
Video introduction into using PostGIS editor with Natural Earth data.
https://www.youtube.com/watch?v=NSIUAca_DEU
Develop
The PostGIS query editor is based on Electron using React and MapboxGL.
Install node dependencies and generate dist
.
npm install
npm run build
Run Electron app.
npm start
Create releases.
npm run package-all
The cross platform artifacts on the release page are automatically build by either Travis (for OSX and Linux) and by AppVeyor (for Windows).