A geospatial career journey
In between proposals, white papers and the like, I’ve been able to do a little coding to keep myself sane. Recently, I have been playing with SharpMap, GeoJSON and OpenLayers. But not necessarily in that order. Originally, I was looking over the GeoJSON spec to get more of a feel for it and decided that … Continue reading Writing GeoJSON from SharpMap, Part 1
I recently had a project requirement to export the contents of a delta table in Databricks to several formats, including shapefile and file geodatabase, with the output being placed in object storage mounted to DBFS. I set up the logic in a notebook, with the intent to use geopandas, which provides an easy wrapper around … Continue reading Exporting Data with GeoPandas in Databricks
As a consultant, I have always placed a premium on the maturity of the technologies I recommend and deploy for my customers. While staying current with innovations, especially in the geospatial space, is a critical part of my work, I believe in letting new technologies develop and stabilize before introducing them into customer workflows. This … Continue reading Cloud, Ready
This week, I had the opportunity to attend OGC@30, the celebration of the 30th anniversary of the founding of the Open Geospatial Consortium (OGC). The early 1990s were the very beginning of my professional career and they were also a time of geospatial innovation. Many of the pioneers from that time, including OGC founder David … Continue reading Thirty Years of OGC
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
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
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
I’ve spent the last year or so doing very little with geospatial technology, but I find myself missing it tremendously. Of course “in my blood” and “how I’m wired” and similar aphorisms apply to how I’m feeling, but that’s not what really has me missing geospatial. In a shocking (for me) turn of events, I … Continue reading Give Me a Standard, Any Standard
With my MBA program behind me, one of my goals has been to shake the rust off my coding and GIS skills. For this post, I thought I would start simply, just to make sure I remembered how to find my way around QGIS. We recently purchased a plug-in hybrid. It has a 17-mile range … Continue reading Simple Isochrone Analysis in QGIS
As I continued my experimentation with BigQuery, I found myself wanting to more easily use it with my regular GIS tool set. BigQuery has a lot of powerful analytic capability, but the SQL console is intimidating for the casual user and the GeoViewer tool is fairly limited. As I began digging deeper in my previous … Continue reading BigQuery and Koop