PostGIS Odyssey Part 1

28 Nov 2012 in PostGIS, PostgreSQL

For a current (unreleased) project, I was starting to wander into the crazy world of maps. I started out with a very simple model of zip codes represented as points, but I had reached the limits of that approach being effective. I needed polygon data that gave a "truer" representation of what it means to be a zip code.

Continue Reading →

Installing Ltree and PostGIS with PostgreSQL 9.2

27 Nov 2012 in Ltree, Mac OS X, PostGIS, PostgreSQL

It has been a while since I upgraded the key components of my application stack. This decision was driven by a desire to use PostGIS is a current project, and it appears that MacPorts has designed the latest version of PostGIS to work with PostgreSQL 9.2.

Continue Reading →