PostGIS Odyssey Part 1

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.

Installing Ltree and PostGIS with PostgreSQL 9.2

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.