A geospatial career journey
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
Directions Magazine has announced that it is shutting down, with May 31, 2024 as the deadline to access/republish any content from the site. My first reaction when reading this was that I didn't know it was still around. Unfortunately, I was not being facetious, but it's also not funny and I should have been more … Continue reading So Long, Directions
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
NOTE: This post was an April Fool's joke. It’s happened to us all - tucked away in the dusty corners of our attics or closets is that box with a serial port Zip drive and a dozen disks. Curiosity usually gets the better of us and, after a few downloads and a couple of kernel … Continue reading Announcing Legacy Data Abstraction Library (LDAL)