PGCon2009 - Final Release
PGCon 2009
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Leo Hsu and Regina Obe |
| Schedule | |
|---|---|
| Day | Talks - first day - 2009-05-21 |
| Room | DMS 1110 |
| Start time | 16:00 |
| Duration | 01:00 |
| Info | |
| 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.