A geospatial career journey
A few months ago, I wrote a post about how to generate GeoJSON feature collections using pure SQL in PostGIS. After attending FOSS4GNA and learning more about GeoParquet and DuckDB, I wanted to modify the approach to use those tools. What is DuckDB? It is an in-process SQL database management system designed for fast analytical … Continue reading Producing GeoJSON from SQL, Part 2 (DuckDB/Geoparquet Edition)
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
So it seems this thing may be snowballing. The idea of GeoJSON support was originally floated (not by me) on Esri’s ideas.arcgis.com site a few years back. The entry can be found here. A few days after Esri announced support for GeoJSON in AGOL, they updated the above entry as follows: Note from Esri (Dec … Continue reading f=geojson, Part 3
In which I say nice things about Esri. You have been warned… A couple of weeks ago, I gave a talk at a local Esri GeoDev Meetup (which also served as a convenient way to tell a room full of developers that my company is hiring developers) on a GeoJSON server object extension for ArcGIS … Continue reading f=geojson, Part 2
It’s great news that the government shutdown is finally over. Many of our colleagues across the geospatial industry can now report back to work, ending a another stressful period for them. During the shutdown, many stepped up to try and fill the gap left by shuttered government web sites that would normally distribute geospatial data.