PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Luis Bueno
Day Talks - first day - 2009-05-21
Room DMS 1110
Start time 11:30
Duration 01:00
ID 149
Event type Lecture
Track GIS
Language used for presentation English

Saving the Amazon with PostGIS

Spatial Manipulation in the Rain Forest

Spatial databases are different from other databases through its requirement to store spatial data features, capable of describing its location on space and representation. Its highlighted in the projects the utilization of PostgreSQL with PostGIS. During this lecture it will be discussed the use of the aforementioned tools in the management of spatial database, and the application of spatial analysis techniques on data stored in environmental database.

Spatial Database differs from regular databases for its necessity to store spatial data features, capable of describing its location and representation. Generally spatial databases are created seeking to support application of Geographic Information Systems - GIS. For some time the closed source solution to database management systems – DBMS, dominated the implementation projects of spatial databases, but currently the utilization of the powerful combo: PostgreSQL and its spatial extension PostGIS appears as a excellent option. However the creation of a spatial database and later manipulation of stored data through GISI, goes beyond the choosing of a DBMS. Some of this factors will be discussed during the lecture. Spatial data analysis it’s the process to search for patterns and associations in maps that help to characterize, understand and predict spatial phenomena. With PostGis it’s possible to apply new spatial analysis techniques directly on the stored data. This possibility can make the systems more flexible and create new ways to use spatial data. This lecture will be shown the use of PostgreSQL, with PostGIS, to management and manipulation of spatial data in the context of applications used to monitor and protect the environment. It will be presented practical examples of the utilization of this tools concerning the case environmental surveillance of Brazilian Amazon.