March 28th 2017 1:00 PM - 4:00 PM
We look forward to meeting you in Jersey City!
We are still making last-minute "enhancements" to our presentation and labs. Please revisit the site before training to download the latest.
If you haven't already, Buy your tickets at http://pgconf.us/conferences/2017#registration
Things we'll cover
In the meantime, please make sure you have PostgreSQL and PostGIS installed on your laptop if you want to run through the lab exercises.
We ask that you install the latest versions of each.
We will be presenting using PGAdmin.
If your laptop affords you a GUI, we highly recommend that you install PGAdmin.
If you have questions email us at lr at pcorp dot us.
The install guide for PostGIS family of extensions we'll cover PostGIS 2.3, PostgreSQL 9.6 install guide
OpenJump for adhoc PostGIS queries
QGIS popular viewing tool for PostGIS
ogrfdw is a spatial foreign data wrapper builds on GDAL Spatial ETL www.gdal.org. You can use it for both spatial data (ESRI Shapefile, OSM, KML, GeoJSON etc) and non-spatial (such as spreadsheets, csv files, dbase files, Web services, relational databases (has both direct and can interface with ODBC) etc. It is packaged with Windows PostGIS application stackbuilder installer and also available via yum.postgresql.org.
How to load data with osm2pgsql
Presentation scripts and data: May change a bit before workshop.
Lab scripts lab_code.zip
If you want to start with database and not bother with loading exercises,
you can use the partial backups below:
Some of these are part of the lab or presentation download
Baruch College Mass Transit spatial layers
( 2017-JAN routes_nyc_subway_jan2017.zip)
NY Open Data - Borough Boundaries renamed nyc_boroughs
US Census Tiger data for geocoding - loaded just for New York and New Jersey (2016 dataset) utilizing postgis_tiger_geocoder generated scripts instructions detailed in PostGIS manual: Tiger Geocoder Enabling.
USGS Aerial - Jerset City: Jersey City Aerial
USGS NED 1 arc New Jersey NED Data: USGS_NED.zip n40w075.zip, n41w075.zip
Raster DEM data from USGS: USGS National Atlas
Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out in hard-copy 4th quarter 2017. Content is now feature complete and can purchase e-Book draft and get final when goes to print.
© Leo Hsu and Regina Obe 2014