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
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
I was having a conversation a few weeks ago, discussing, among other things, the value of time - its management, its conservation, how it is the one strategic asset that matters above all others. During that part of the conversation, it occurred to me that if time is the asset, then people and relationships are … Continue reading The One About Friends
I've been integrating pg_webhooks into some project work lately. Conversely, I have not been using n8n much, but a vendor rep used it in a demo of some workflow automation capabilities for a platform one of my customers is using. I had dabbled with it about two years ago but haven't done much with it … Continue reading Using pg_webhooks with n8n – A Simple Example
This question comes up more frequently than I would expect. I've been writing here since 2006 and this blog is a good map of my professional journey over that time. Most often, when people ask me the titular question, they are wondering how I can keep this up for so long. Less frequently, the question … Continue reading How Do I Write?
FOSS4G North America was an opportunity for me to reconnect with both community and technology. I enjoyed being able to both learn new things and refresh my skills with technologies such as PostGIS. I was reflecting on how, a couple weeks prior to the conference, I introduced the concept of PostgreSQL window functions to a … Continue reading Window Functions and PostGIS
FOSS4G North America (FOSS4GNA) wrapped up yesterday, closing out with another thought-provoking keynote by Paul Ramsey. Paul’s talks on the “economics of open source” have evolved over the years and, while this talk certainly discussed such economics, it was so much more. Paul is one of the best speakers you will see and his talks … Continue reading Initial Thoughts on FOSS4G North America
One of the first tasks I ever had in my then-new GIS career was doing AML development in ARC/INFO 6.x for a data production project. My code parsed DXF exported from AutoCAD R11 for DOS and then assigned attributes based on things like layer, color, line weight, feature type, and others. It also georeferenced the … Continue reading Data Over Software
Last week was a good week. Given that I was on vacation with my family in Florida, that statement is pretty much a given, but it was still of note. This vacation was our annual week in South Florida at a timeshare we've had for years. I have often worked some portion of the week … Continue reading Changes In Latitudes…