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.
So GitHub announced that you can now automatically view any GeoJSON files that may be in a repository inside an interactive map driven by MapBox technology. This simple enhancement to GitHub is probably one of the most significant developments in the geospatial industry in years. I’ll explain a little later in this post. It’s also … Continue reading GeoJSON on GitHub: Now What?
A while back, I posted about my desire to see GeoJSON supported as an output format from ArcGIS Server. I found myself needing that capability so I recently completed, and posted to GitHub, a first cut at a server object extension (SOE) for ArcGIS Server 10.1 that enables output of GeoJSON via an HTTP GET. … Continue reading GeoJSON From ArcGIS Server
In support of some of our ongoing PIM work, we’ve been integrating the Esri File Geodatabase (FGDB) API into some tools. Without going into a level of detail that would hijack this post, one of the many functions performed by some of the tools is to validate physical spatial databases against established data models to … Continue reading ToGeoJson and ToWKT for the Esri FGDB API
On November 11, 2011, I gave a lightning talk at the ESRI Dev Meetup in Silver Spring, MD. My talk was titled “If I Were Jack For a Day.” Despite the infinite comedic potential of that title, it was a tongue-in-cheek look at some items on my wish list for the ArcGIS platform. An increasing … Continue reading f=geojson
Following up on my post a few months back about GeoJSON and SharpMap; here is the code to the converter as it stands so far. I have mentioned recently that things have been pretty busy at work so I have progressed on this more slowly than I had wished. I have yet to insert code … Continue reading Writing GeoJSON from SharpMap, Part 1.5