We are working on second edition of PostGIS in Action 2ed for availability sometime in early to mid 2014. Early purchase review (MEAP) is now available for Second Edition. With MEAP you can get chapter updates as we write them and get the final polished copy at release time.
Our most recent book
PostgreSQL: Up and Running is out in both E-book and hard-copy. You can order hard-copy now from Amazon or Kindle
or hard-copy or e-Book from O'Reilly. We are hard at work on the second edition of PostgreSQL: Up and Running as well. Should be out late 2013 to early 2014 and with focus on PostgreSQL 9.2-9.3.
This page lists the presentations we have given or are scheduled to give on the topic of PostGIS as well as the associated media.
In the talk we did live demos. Code samples download
Video Tape of presentation in 4 parts
Basics of OGC WMS/WFS services. Various open source mapping servers out there that support PostGIS. Proximity queries with PostGIS geography. Using OpenLayers and GeoExt. Using Mapserver. Using GeoServer. Using OpenStreetMap as a base layer in OpenLayers.
An intro course to PostGIS covered loading data with pgsql2shp, loading CSV data using PostgreSQL Copy command, PgRouting, viewing PostGIS data with OpenJump and QuantumGIS.
Leo was very brave and did a live demonstration of everything sans slides. So unfortunately no slides for this you just had to be there. We'll have the code examples here in a bit.
© Leo Hsu and Regina Obe 2012