Sometimes it's a pain to open up QGIS and load a PostGIS-enabled DB. Sometimes I don't feel like writing a custom tileserver and hooking it up to Leaflet or Mapbox GL just so I can see if my map looks right.
npm install -g geotype
. . . which enables fast and simple maps like this:
Yep. That's New York, alright.
. . . and that sure looks like the population distribution of the District of Columbia.
These maps are nothing to show to customers, but they make QA/QC a lot easier. Here's the syntax, piping
psql output directly into
psql $DB_URL -t -c "SELECT ST_AsGeoJSON(ST_Collect(the_geom)) FROM mytable" | geotype
ST_Collect() coerce the output into the type of data that geotype can read)