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…
Category: postgresql
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….
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”…
Speaking of the 84%…
HT to Sophia Parafina for the 84%. UPDATE: The NSIS script at utility batch file discussed here is now on github at https://github.com/geobabbler/pgstandalone. I’ll post a readme in the next day or so. A few months ago, I asked the following question on Twitter and got this reply from Paul Ramsey: @billdollins Possible yes, but…
zigGIS: The End of the Road
Abe Gillespie made it official today on the zigGIS Google Group: development on zigGIS will cease.
Triggered Notifications Using PostGIS
My project work the last few months has kept me away from a lot of my favorite open-source tools and I was starting to get hives. Specifically, it had been a while since I had worked with PostgreSQL and PostGIS and I was missing the experience, so I dreamed up something to do. I do…
Me and zigGIS
If you’ve been to the Obtuse Software site recently, you may or may not have noticed a change to the “Who We Are” page. It now lists only Abe Gillespie and Paolo Corti. Prior to my trip to Colorado to talk about zigGIS at GIS in the Rockies, I informed Abe and Paolo that I…
Gearing up for GIS in the Rockies
I finally got around to finishing my travel plans for GIS in the Rockies (personal obligations prevent me from making it out for Ingite Spatial NoCo). I booked my flight a while ago but I had been procrastinating on the hotel and rental car. This will be my first time in that part of Colorado…
A Look at “PostGIS In Action”
Over the past few weeks, I have been reading a copy of the upcoming book by Regina Obe and Leo Hsu titled “PostGIS In Action.” Through my work with zigGIS and some of my consulting work with Zekiah, I have been using PostGIS with good results for some time now. I have found that it…