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…
Category: open source
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…
Initial Thoughts on FOSS4G North America
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…
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…
Open – Beyond Technology
I am currently reading the book “Fierce Conversations” by Susan Scott. I am on hiatus from teaching my leadership course this year, so I am taking the opportunity to refresh my content and my perspectives. The basis of the book is fairly simple: Our work, our relationships, and our lives succeed or fail one conversation…
SpatiaLite for Android Available
On what seems to be turning into SpatiaLite Monday, Sandro Furieri also announced on the SpatiaLite Google Group the availability of a stable version of SpatiaLite for Android. I am happy to see that this version was developed and contributed back by the US Army Geospatial Center. The fact that they contributed back to the…
SpatiaLite 4.0 Released
It looks like it was a busy weekend for Sandro Furieri and the rest of the SpatiaLite team as version 4.0 was announced on Sunday. There are a number of changes, so it’s best to catch up on them before switching over. I have a couple of Federal customers that are integrating SpatiaLite into their…
Personal Geospatial Workflows
I’ve had a couple of people ask me recently about the geospatial tools I use. Year-over-year, that answer changes but here’s how I answer that right now: As a Federal contractor, I spend a lot of time working with the Esri stack during my work day. A few years ago, I added a few open-source…
Wilson Center to Discuss FCC National Broadband Map
One of the most compelling recent success stories for open-source geospatial tools in the Federal Government has been the Federal Communications Commission (FCC) National Broadband Map initiative. It has been a very visible example of the stability, scalability, flexibility, and power of open-source geospatial tools. The Woodrow Wilson Center will be hosting a case study…
ToGeoJson and ToWKT for the Esri FGDB API
In support of some of our ongoing PIM work, we’ve been integrating the Esri File Geodatabase (FGDB) API into some tools. Without going into a level of detail that would hijack this post, one of the many functions performed by some of the tools is to validate physical spatial databases against established data models to…