PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Leo Hsu and Regina Obe
Day Talks - first day - 2009-05-21
Room DMS 1110
Start time 16:00
Duration 01:00
ID 174
Event type Lecture
Track GIS
Language used for presentation English

Spatial Analysis with PostGIS

In this lecture we shall describe some use cases of PostGIS -- a brief overview of how it is used in various ways such as for location aware applications, property management, and environmental risk assessment.

PostGIS is a very popular spatial database extender for PostgreSQL and the preferred database backend for Open Source GIS-based applications. It is well supported by most Open Source Geospatial products as well as many commercial products.

In this lecture we shall provide a survey of how it is used in academia, research and commercial applications for analyzing collected data, geo-coding collected data and creating derivative geo-datasets.

We shall end with doing some common case spatial queries -- extruding, fixing malformed geometries, morphing of geometries by spatial characteristics as well as attribute characteristics and some simple geo-coding exercises.

We shall demonstrate the use of OpenJump as a complementary geospatial desktop analysis tool for viewing PostGIS results from ad-hoc queries. In our OpenJump exercise we will do some statistical analysis queries and demonstrate how to view them and generate thematic maps from them using this visualization tool. We will also demonstrate exporting geospatial data for consumption by other tools. We will also demonstrate how the new functionality in PostgreSQL 8.4 complements and extends the power of PostGIS.