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: postgis
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…
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…
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…
CartoDB/Leaflet Sample Update
A while back, I posted about some experimentation I did with Leaflet and CartoDB in the wake of FOSS4G in Denver. I recently had the chance to go back and update that sample with some spatial queries. At the time of the original post, CartoDB was still in beta and spatial queries didn’t seem to…
Planet PostGIS Online
Planet PostGIS, an aggregation of PostGIS-related blog content is now online. As the name suggests, it is built using the same technology as James Fee’s Planet Geospatial but is focused on content related to PostGIS. If you are working with PostGIS, whether as part of an open-source stack or in conjunction with proprietary tools such…
Breaking Radio Silence
Things have been kind of quiet on the blog lately due to things being busy at work. I call that a good problem to have. Since the beginning of the year, I’ve written a a lot of proposals for a mixture of potential customers. Interestingly, I’m seeing a lot more call for “GIS Analyst” work….
MapWindow Open-Source Conference Coming Up
Thanks to Twitter, I see that the 3rd annual MapWindow Open-Source GIS Conference is coming up at the end of June. It is being held in Velp, The Netherlands. I call this conference out because it has a strong, but not exclusive, concentration on open-source GIS tools for the .Net environment, such as DotSpatial, SharpMap,…
FOSS4G North America
It’s rather fitting that the second plenary talk on Wednesday had to do with “firehose” applications since the FOSS4G North America (FOSS4GNA) conference was something of a firehose in itself. Despite the fact that the event was smaller than the worldwide event in Denver back in October, I came away with the same “full brain”…
A Busy Day for Releases
3 April 2012 was a busy day for releases/announcements in the geospatial field: PostGIS 2.0 – This long-anticipated major version of PostGIS was announced with advanced features such as raster, topology, and 3D/4D indexing. Many have been using 2.0 for a while but the official release gives top-cover to organizations, such as some government agencies,…