On March 1, 2024, ArcMap will transition into "mature support." This means it will stop getting patches and updates. While ArcMap is not scheduled to be retired until 2026, the lack of patches and updates is the death knell for any modern software. At a minimum, many IT shops will begin to uninstall it simply … Continue reading Pour One Out for ArcMap
Tag: PostGIS
Using pg_webhooks with n8n – A Simple Example
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
Window Functions and PostGIS
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
A Few Updates to pg_webhooks
At the time of my last post, there were a few outstanding issues that I wanted to address in the code of pg_webhooks. I've addressed three of them this week. There wasn't actually a route to unsubscribe from a channel, so I added that shortly after the initial release. Another key shortcoming was that the … Continue reading A Few Updates to pg_webhooks
A Simple Webhook Interface for PostgreSQL NOTIFY
PostgreSQL's NOTIFY/LISTEN method for subscribing to events from a database is a subject I return to periodically. I've touched on it in one form or another over several years. My latest run at it involves building a Node Express application that will allow external systems to subscribe to webhooks that are fired by NOTIFY statements … Continue reading A Simple Webhook Interface for PostgreSQL NOTIFY
Reconsidering the Spreadsheet
I'm a CIO. That means a typical day can involve a range of activities: responding to data calls for security audits, reviewing SOC2 reports of prospective platform vendors, managing subscriptions of existing vendors, handling GDPR requests, ensuring data from corporate systems is meaningful and relevant for our internal stakeholders, attending meetings of various sorts. Somewhere … Continue reading Reconsidering the Spreadsheet
Return on Non-Investment
Yesterday evening, I had the pleasure of participating in a panel discussion on Clubhouse, hosted by Todd Barr and Jordan Cullen, and including Will Cadell of SparkGeo. Clubhouse seems to be a really convenient venue for setting up such a forum with low barriers to entry, so that was enjoyable. The topic of the discussion … Continue reading Return on Non-Investment
Analyzing Location Change Over Time in PostGIS
Following up on my previous post, I decided to attempt the same analysis in PostgreSQL. The analysis doesn't make use of any spatial logic itself (yet), but I consider this a PostGIS post because it is using PostGIS geometries. In the past, I have noticed that BigQuery SQL is very reminiscent of that of PostgreSQL, … Continue reading Analyzing Location Change Over Time in PostGIS
Attribute Transfer in PostGIS Using Spatial SQL
Data conflation is a meat-and-potatoes task in most GIS workflows. There are numerous reasons one might need to get data from one data set into another. Perhaps you want to attach a new geometry type to existing attributes or a table. Or maybe you need to pull attributes from one or more data sets into … Continue reading Attribute Transfer in PostGIS Using Spatial SQL
Watching COVID-19 Data for Your County with PostgreSQL and Node
I have addressed the topic of triggered notifications a couple of times on this blog previously. I've taken the opportunity to apply the technique to a current use case - the ability to get notifications whenever the confirmed count of COVID-19 cases changes in my county or surrounding ones. I am basing this workflow on … Continue reading Watching COVID-19 Data for Your County with PostgreSQL and Node