Producing GeoJSON with SQL

A couple of weeks ago, I had a need to return GeoJSON from PostGIS. This is something I've done many times, but I usually do the final formatting in the application/API layer with Javascript or Python. Basically, my workflow has been to SELECT, using the built-in ST_AsGeoJSON function to convert the geometry to GeoJSON. I … Continue reading Producing GeoJSON with SQL →

Reflections, Twenty-One Years On

Yesterday was the 21st anniversary of 9/11. I tend to let that day go by without comment. My recollections of the day itself add nothing as I was 50 miles outside of DC at the time. Even that far away, the roads were filled with panicked people and the phone networks were crashing, but I … Continue reading Reflections, Twenty-One Years On →

Thoughts on HERE

Give a Little Bit for OpenStreetMap

Tag: OSM

Producing GeoJSON with SQL

Reflections, Twenty-One Years On

Thoughts on HERE

Give a Little Bit for OpenStreetMap

Ten-Second Tidy