I'm happy to once again be participating in a DMV GIS Day event. GIS Day is still months away, but Cercana Systems is partnering again with New Light Technologies on a "Midpoint Meetup." Like the inaugural event, it is a free virtual event. The midyear event will be about two hours long and serves as … Continue reading DMV GIS Midpoint Meetup 2025
Tag: OSM
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