August 26th, 2008
PostGIS Basics - Part 1 - InstallationAugust 26th 9:01 PM
Why PostGIS?
PostGIS (good writeup) is actually the main reason I chose to go with PostgreSQL over MySQL for this new project I'm working on (there are many other benefits, though, and I really can't see myself ever going back). I'll leave the discussion of capabilities for another post, but for now I thought I'd share my experience installing and configuring this (very) squirrely extension to PostgreSQL.
Installation
Using the official documentation (which, unfortunately and like every other linux application, assumes that you are compiling from source) and a very helpful PostGIS basics guide I was able to get 90% there.
Read More »
Posted by Jeremy Tunnell| Comments (1)
Other Tags
August 27th, 2008
PostGIS Basics - Part 2 - Hello WorldAugust 27th 9:06 PM
A quick hello world
There are a couple of things you must know about PostGIS and GIS in general before you can work with them.
First, PostGIS keeps a table of spatially enabled columns with metadata that you must update via built in functions (called geometry_columns). Consult the command reference for details, but I used the following to set up a POINT enabled column:
Read More »
Posted by Jeremy Tunnell| Comments (0)
Other Tags