In a post last week, Open Data and AI, I discussed how open data projects are facing a new kind of consumer: AI-automated systems that can pull public data continuously, at scale, and in patterns the original infrastructure was never designed to support. OpenStreetMap is one of the clearest examples. It is globally important, community … Continue reading Prototyping AI-Ready OSM
Category: postgis
Pour One Out for ArcMap
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
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




