This page lists the presentations we have given or are scheduled to give on the topic of PostGIS as well as the associated media.
March, 19th, 2019 New York, New York, USA
September 5th, 2018 San Francisco, California, USA
Material for the training: PGOpen2018 material
September 6th, 2018 San Francisco, California, USA
Held June 5th 2018
Presentation Media: PDF HTML
Held Tuesday PM August 15th, 2017 Cambridge, MA (Harvard University) USA
Material will be available here before workshop.
Held Wednesday August 16th 2017
Presentation Media: HTML, PDF, Video.
Held Tuesday March 28th, 2017 1 PM - 4 PM in Jersey City, NJ USA
Material for the training: PGConfUS2017 material
Presentation Slides HTML PDF Video
Held Thursday March 30th, 2017 11 AM - 11:50 AM in Jersey City, NJ USA
Held Tuesday May 3rd, 2016 11:15AM - 11:50 AM in Raleigh Convention Center in Raleigh, North Carolina
Held Tuesday May 3rd, 2016 4:15 PM - 4:50 AM in Raleigh Convention Center in Raleigh, North Carolina
Was held April 18th, 2016 in New York Marriott Brooklyn Bridge from 2:00 PM to 5:30 PM. All those that registered and attended our training will received a free hard-copy of PostGIS In Action 2nd edition.
Material for the workshop is available at pgconfus2016 lab material
You'll get the most out of the session if you have PostgreSQL 9.5 and PostGIS 2.2 already installed. Refer to our PostGIS install.
Was held April 19th, 2016 11:30AM - 12:30 PM as part of the Main PG Conf US 2016 conference. New York Marriott Brooklyn Bridge.
Slides in PDF HTML Video
Cambridge Innovation Center, 4th Floot Cafe - 1 Broadway, Cambride, MA. Event Page
Refer to Maptime PostGIS Introduction
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.
pgRouting: A Practical Guide is available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.