PostGIS Spatial Database Engine UMN Mapserver Boston Geographic Information Systems    Checkout our PostGIS in Action book.  First chapter is a free download   PostGreSQL Object Relational Database Management System
GIS Books  Home   Consulting Services  About Boston GIS   Boston GIS Blog  Postgres OnLine Journal
PostGIS in Action is out in hard-copy,
download the first chapter
and SQL Primer for free. Tips and Tricks for PostGIS
  GIS Article comments Comments Rss
PGCon2009: PostGIS 1.4, PostgreSQL 8.4 Spatial Analysis Queries, Building Geometries, Open Jump

We gave a lecture at PGCon 2009. Below are the links and the generated data set. Some of the examples use features in PostgreSQL 8.4 and PostGIS 1.4, but most should be applicable to earlier versions. The data generation part does use PostgreSQL 8.4 WITH RECURSIVE construct, but not in a terribly useful way.

Lots of great presentations at PGCon2009 -- the slides should be up shortly for all the presentations.

PG Con 2009 PostGIS Spatial Analysis Lecture

For display we use OpenJump. Flash Movie of OpenJump rendering the autogenerated town

Windows users: There are PostGIS 1.4 Windows binaries currently stack builder installer will be available shortly h Please note nothing has changed in the binaries between 1.4RC2 and 1.4 official except for the version number stamped on them when you look at SELECT postgis_full_version()

If you want to play with the generated data set - do the following

  1. Create a PostGIS enabled database called pgcon2009 -- preferably 1.4 version and PostgreSQL 8.4
  2. Download this file --
  3. Unzip and load the file using psql or pgAdmin III
  4. Run the following line in your pgcon2009 database from psql or pgAdmin III ALTER DATABASE pgcon2009 SET search_path=assets, public;

Post Comments About PGCon2009: PostGIS 1.4, PostgreSQL 8.4 Spatial Analysis Queries, Building Geometries, Open Jump

12/3/2010 1:16:32 AMHarish KVPlease add more operational queries
7/25/2009 3:30:48 PMReginaIrene -- are you trying to compile yourself or are you using pre-built binaries? We have the RC2 binaries built for PostgreSQL 8.4 Windows and will be releasing the official 1.4 binaries this coming Monday. I have included the link to the windows binaries in this article
7/21/2009 2:17:22 PMIrenePlease I am having some problems installing my downloaded PostGIS 1.4 on my computer. I am working on windows xp environment and have successfully installed PostGreSql 8.4 on it running perfectly well.

When I tried to install the PostGIS, it keeps giving me an error that the PostGIS must be installed in the same folder as the PostGreSQL.
I dont know what to do next as i have tried all means to solve the problem by ensuring that the downloaded postGIS is stored in the same folder with the PostgreSQL, still the error message persists.
Please I need your help on this as I am using the PostGreSQL and postGIS to implement my school final degree project.

This Document is available under the GNU Free Documentation License 1.2 & for download at the BostonGIS site

Boston GIS      Copyright 2017      Paragon Corporation