Category Archives: PostgreSQL

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

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

Announcing: Electorate Finder

Posted on April 11, 2008 by segfault

I’ve been playing around with PostgreSQL and PostGIS lately and decided that I wanted to create something with them. I found out that the Department of Statistics provide GIS versions of the electoral boundaries and so downloaded the boundaries and … Continue reading →

Posted in PostgreSQL | Tagged , | Leave a comment