Practical PostGIS

Presenter: Paul Ramsey, Systems Architect, Refractions Research Abstract: This workshop will take attendees from the installation and loading of a PostGIS database to the presentation of PostGIS data in a web application. The workshop will cover: * Installation * Data Loading * Coordinate Systems Support * PostgreSQL Tuning * Basic Spatial SQL o Finding Data o Analyzing Data * Indexes and Spatial SQL * Advanced Spatial SQL o Integrating Data o Processing Data * Basic Mapserver Layers * Advanced Mapserver Layers o Arbitrary SQL in Mapserver To get the most out of the workshop, participants should be familiar with basic SQL concepts.

PostGIS workshop handout (PDF) by Pericles Nacionales — last modified 2005-11-19 16:26

workshop handout

PostGIS Data Dictionary (PDF) by Pericles Nacionales — last modified 2005-11-19 16:26

Data dictionary handout.

Practical PostGIS workshop data (ZIP) by Pericles Nacionales — last modified 2005-11-19 16:26

PostGIS workshop data and documentation. (~75Mb)