Category Archives: GIS

PostGIS now supports PostgreSQL 8.3 in Ubuntu Hardy

Posted on April 24, 2008 by segfault

Thanks to the work of some inviduals, we have managed to get postgresql-8.3-postgis included in Hardy just days before release. Thanks to all those involved. Without this package, we would have had to use PostgreSQL 8.2 instead of PostgreSQL 8.3 … Continue reading →

Posted in GIS, PostgreSQL | Tagged , , | Leave a comment

Announcing: Airfield Finder

Posted on April 19, 2008 by segfault

A little while ago I managed to obtain coordinate data for all the airfields and helipads in New Zealand. I imported it into a PostGIS-enabled database and since then I’ve created a script to export the GIS data as KML … Continue reading →

Posted in GIS, Mapping | Tagged , , | 2 Comments

Why query optimisation is important

Posted on April 14, 2008 by segfault

I was modifying one of my queries for Electorate Finder this morning and came across a good example of why query optimisation and query design is important, especially on large datasets. I had a query like the following: SELECT name, … Continue reading →

Posted in GIS, PostgreSQL, Tips | Tagged , | 2 Comments

Spatially enabling a PostgreSQL database

Posted on April 11, 2008 by segfault

In order to store GIS data in a PostgreSQL database, you first have to install PostGIS and then make the database spatially aware. For this example I am using Ubuntu Hardy. First, install PostGIS: apt-get install postgis postgresql-8.3-postgis Now create … Continue reading →

Posted in GIS, PostgreSQL | Tagged , | 1 Comment