PostGIS in Action (2nd)
Where the adventure begins

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.
  • - 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

    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

Data sources

PostGIS in Action,2nd edition MEAP      PostGIS Cookbook    PostgreSQL: Up and Running,2nd Edition    PostGIS 2 Análisis Espacial Avanzado (Spanish Edition)   
Node JS In Action, 2nd Edition    D3.js in Action