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
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
This post is a continuation of last month’s post about analyzing location change with BigQuery. At the end of that post, I was already thinking of ways to extend the analysis and visualization. I decided to take the opportunity to explore Esri’s recently-announced ArcGIS Platform APIs. These APIs are the same that have been available … Continue reading Routing with BigQuery and ArcGIS Platform APIs
I’ve recently spent a lot of time doing various forms of business analytics in BigQuery. As discussed in a previous post, I’ve been using BigQuery as the data integration environment for several business systems. I’ve found integration at the data level via an ETL/ELT/IPaaS pipeline to be a lot more stable than system-level integrations that … Continue reading Analyzing Location Change Over Time in BigQuery