FOSS4G North America 2015: Burlingame, California. Hyatt San Francisco Airport Hotel

PostGIS: Up and Running

March 9th, 2015
09:00 AM - 12:00 PM

We'll cover core PostGIS types geometry, geography. Other examples planned include tiger geocoder packaged with PostGIS, a quick example of pgRouting, the extension that augments PostGIS for routing applications. We'll also explore a bit the 3D-geometry types.

We'll be using features available in PostGIS 2.1 and PostgreSQL 9.3.

If you have questions email us at lr at pcorp dot us.

• Installation Starter Guide
• pgAdmin III Not required, but if you don't know your way around psql, might be helpful.
• QGIS popular viewing tool for PostGIS
• OpenJump Great for adhoc PostGIS queries
• Loading data with PostGIS packaged tools how to use shp2pgsql, pgsql2shp, and shp2pgsql-gui packaged PostGIS tools for loading and exporting data. Windows and BoundlessGeo packages have shp2pgsql-gui, most platforms do not.
• If you want to use the compressed files, you need something that can extract bzipped files. This normally exists already on Unix/Linux. For windows users, easiest is to use 7-zip.
• www.gdal.org - ogr2ogr is useful for loading many kinds of vector data. We'll do a quick example loading KML in PostGIS.

• We will also be using NodeJS as a quicky web app for viewing 3D data. For the NodeJS, install NodeJS, make a directory where you'll host the app. Source code for quicky app is https://github.com/robe2/node_postgis_express

  We'll be using two libraries -- express and pg.js. Both are pure Javascript libraries so should work fine on any node.js install.

  At OS shell/command line prompt. Run the below two.

  npm install express
  npm install pg.js

Workshop scripts

• load.txt (data load examples)
• main.sql script file
• 2nd half of workshop

Data sources

• BART rail and stations: http://www.dot.ca.gov/hq/tsip/gis/datalibrary/Metadata/BART_13.html (routes and stations)
• World Cities: world_cities - http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip
• For Tiger Geocoder - Chicago prepped data tiger_data_chic.sql.bz2 (77MB). Extract the file, and in a database with postgis_tiger_geocoder extension installed, run the sql script from psql.
• San Francisco Buildings - https://data.sfgov.org/Geographic-Locations-and-Boundaries/Building-Footprints-Zipped-Shapefile-Format-/jezr-5bxm
  Some buildings converted to 3D with SFCGAL ST_Extrude, you can still follow along with this already prepped data: 3D buildings Building Textures (install the node_postgis_express web server, create images folder and extract textures into public/images)
• London Tube Lines converted to ESRI shapefile from KML Original data if you want to start from scratch is http://www.doogal.co.uk/london_stations.php

Save 40% off on Third Edition of PostGIS In Action and other Manning published books Offer ends August 19th, 2022

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