PostGIS in Action (2nd)
Where the adventure begins
Translate:



PGOpen 2018 San Francisco, CA

Getting Stuff done with PostGIS

September 5th
1:30 PM - 4:30 PM

We look forward to meeting you in San Francisco!

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 https://2018.postgresopen.org/tickets/

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 (CA data)
  • Road 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 (you should have preferably PostgreSQL 10 and PostGIS 2.4, but install process is much the same)

  • 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, bigSQL, and apt.postgresql.org and also available via yum.postgresql.org.

  • How to load data with osm2pgrouting

Lab data and scripts

We'll provide to those who want to follow along on a flash drive and will post to site later.

Some of the data



pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.

PostGIS in Action,2nd edition MEAP    PostgreSQL: Up and Running       D3.js in Action 2nd Edition   PostGIS Cookbook Beginning Databases with PostgreSQL   
Node JS In Action, 2nd Edition