Lead Presenter: Paul Ramsey (OpenGeo)

Sir Clive Granger Building: B29 A - Sept. 18, 2013, 9:30 a.m. to Sept. 18, 2013, 1:30 p.m.

In this workshop, participants will learn the basics of the most popular open source spatial database around.

In this workshop, participants will learn the basics of the most popular open source spatial database around. What is a spatial database? How do you load data in it? What is spatial SQL? How to you do analysis inside the database? This workshop covers all that and more. Basic concepts, data loading, spatial SQL, analysis queries, validity, geography type, vector data are all covered. Time-permitting we will walk participants through analyses using the new raster and topology functions in PostGIS 2.0. This workshop is suitable for any semi-technical person with some knowledge of the SQL query language.