Geospatial technology, markets, and practice
As I mentioned earlier this year, I spend a lot of time working in Python these days. More and more, my work seems to be about performing geospatial tasks with the minimal amount of geospatial dependencies possible. My most recent work has been generating contours from a set of sampled elevation points. I’ve done this … Continue reading Just Enough Geospatial
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
Early in my career, I dealt with a requirement to post-process a corpus of existing documents to "geocode" them. This meant identifying the locations referenced in each document, calculating a minimum bounding rectangle (MBR), and writing the MBR, the file path, and some associated ID into a database, so that documents could be surfaced via … Continue reading Simple Geocoding with ChatGPT
A couple of weeks ago, I took part in a live discussion of the Geospatial Innovations group on LinkedIn, along with Linda, Bonny, Tim, and Will. The topic was “Reimagining Maps” and was spurred by a couple of recent posts by Linda and Will - "Modern Mapping" and "Modern Geospatial", respectively. The discussion ostensibly examined … Continue reading Decoupling Maps
As I was building a Python notebook in Databricks, I started thinking about how much Python work I've been doing since I went out on my own. That got me thinking about all of the SQL I had been doing the last couple of years at my previous role, then the Javascript before that and … Continue reading Rings In a Tree