Free and Open Source Software for Geomatics Conference FOSS4G 2010 Barcelona

W-04: Introduction to PostGIS  

Home > Workshops > W-04

PostGIS is an open source spatial extension to the PostgreSQL open source enterprise relational database. Spatial databases such as PostGIS, Oracle Spatial and DB Spatial are used for high-performance multi-user access to large seamless data sets. If you are managing large volumes of read/write spatial data, using a spatial database can improve access speed, ease management overhead and guarantee data integrity. Built as an object extension to PostgreSQL, PostGIS has been certified as "Simple Features for SQL" compliant by the Open Geospatial Consortium. PostGIS was first released in 2001, and is now used around the world as a high-performance server for spatial objects. It features a spatially-enabled query planner, highly concurrent R-Tree spatial index, and hundreds of spatial analysis and processing functions that allow for GIS-style data analysis right inside the database. This workshop teaches the basics of using PostGIS for beginners. Attendees will learn how to:
install PostGIS and the software it depends on;
load data into PostGIS;
tune PostGIS for higher performance;
use spatial indexes for speedy searching;
use spatial functions for GIS-style queries;
use spatial operators for GIS-style geo-processing; and, connect to PostGIS with other software for data editing, mapping, and analysis.
The workshop starts with a history of PostgreSQL and PostGIS, and then moves quickly to hands-on exercises in setting up and using PostGIS. Attendees receive a full workbook, sample data, and software, so they can review the material later at their own pace.


P. Ramsey; OpenGeo
Mark Cave-Ayland; Sirius corporation

author's bio

Paul Ramsey has taught PostGIS and web mapping technology workshops several times a year for the last five years, at FOSS4G events, at Where 2.0, at GeoWeb, GeoTec and other venues as well. His workshops have consistently received top evaluation marks.

workshop level


attendee's previous knowledge

Some SQL understanding is helpful.


Webpage of the slides

<- back to workshop page