PGConf US 2017 Jersey City, NJ

Getting Stuff done with PostGIS

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

Loading spatial data from shapefiles with shp2pgsql
Making CSV data with long lat spatial
Creating more complex geometries like polygons from scratch
Proximity searches with PostGIS
Geocoding using tiger geocoder (NY data)
We'll touch a little on network routing with pgRouting
Loading raster data with raster2pgsql and also directly from the database
Raster spatial analysis
Querying foreign spatial and non-spatial data with ogr_fdw

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.

Links to software that we will be using

http://postgis.net/install

The install guide for PostGIS family of extensions we'll cover PostGIS 2.3, PostgreSQL 9.6 install guide
pgAdmin
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

Lab data and scripts

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:

geometry and geography data with no tiger: lab_no_tiger_no_raster.backup
Tiger data for geocoding and base layers like counties: lab_tiger_ny_nj_2016.backup
Raster data - contains NJ elevation and dogs lab_raster.backup