This page lists the presentations we have given or are scheduled to give on the topic of PostGIS as well as the associated media.
Sorry no videos for this one since it was a 3-hour workshop.
Covers spatially enabling a PostgreSQL database, creating geometries and geographies, loading data with shp2pgsql, osm2pgsql, raster2pgsql, doing spatial queries with geometry, geography and raster, and exporting data with pgsql2shp.
Most of the presentation was code which is in this file
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.
Just completed second edition of PostGIS in Action 2ed April 16th, 2015. Hard-copy and e-Book available from Manning now. Will be available via other outlets come May 2015. Code and data download on PostGIS In Action Edition 2 Chapters. Each purchase includes all E-Book versions including E-book version of 1st edition.
Stay tuned for our next book pgRouting: A Practical Guide with LocatePress due out late 2015.
PostgreSQL: Up and Running, 2nd addition came out in December 2014 in Print (both Hardcopy and E-Book). It is also available on Amazon
. The focus of 2nd edition is PostgreSQL 9.3-9.4 and the content has increased by about 60 pages from first edition.
© Leo Hsu and Regina Obe 2014