Posts Tagged ‘ PostGIS 2.0 ’

Temporary PostGIS-2.0.1 PKGBUILD

A few months ago I put out a PKGBUILD for PostGIS 2.0 to use while we waited for the official Arch repositories to catch up.  I just updated it to 2.0.1.  This time I changed it so it will build a package called Postgis-2.0.1-0, so when the official repositories add 2.0.1 it will be replaced automatically.  If you currently have 2.0.0 installed you can use this to upgrade but you’ll still have to upgrade your Postgresql extensions by using:

ALTER EXTENSION postgis_topology UPDATE TO "2.0.1";

As always, I only kind of know what I’m doing, use at your own risk.


PostGIS 2.0 in Arch’s official repository!

A  little over a week ago PostGIS 2.0 hit the official Arch repository.  Hooray!


Reprojecting data with Postgis 2.0

There are so many awesome new features in PostGIS 2.0 but one of my favorites is the UpdateGeometrySRID function.  If you needed to reproject data in old versions you had to use a combination of Transform and SetSRID functions.  Now all you need to do is:

SELECT UpdateGeometrySRID('schema', 'table','geometry_column', SRID);

Easy peasy!

If this was available before 2.0 please travel back and time and tell me.  It will save me a few headaches.

PostGIS 2.0 PKGBUILD for Arch Linux

PostGIS 2.0 is now in the official repository.  Ignore all this nonsense.

PKGBUILD linked below now builds PostGIS 2.0.1.  See this post for details.

I’ve put together a PKGBUILD file you can use if you want to install PostGIS 2.0 on your Arch system.  I’m not going to put it on AUR because it would conflict with the existing package, and also because I’ve never done this before so use this at your own risk.  You can download the PKGBUILD from here:

I didn’t tarball the PKGBUILD so you can just download it to an empty directory and run

makepkg -s

to build the package and then

pacman -U postgis-2.0.0-1-x86_64.pkg.tar.xz

to install it.

Once the package is installed look at the PostGIS manual to see how to set up or upgrade a spatial database.

This build includes the GUI shapefile loader. If you don’t want it or don’t need it edit –with-gui out of the ./configure statement and remove gtk2 from the dependencies.

PostGIS 2.0 released!

PostGIS 2.0 is finally out!  Full details here.

Typmod in PostGIS 2.0

One of my favorite new features in the upcoming 2.0 release of PostGIS is typmod.  This blog post breaks down how it will simplify the creation and modification of spatially enabled tables.