An Introduction to PostGIS

A presentation prepared for the January 2013 Philadelphia PostgreSQL User Group meetup.

Handout

The handout for the presentation is available on GitHub

The PostGISLab Virtual Machine

You can download a copy of the virtual machine (2.54GB zipped)

The virtual machine was created using VirtualBox and has the following open source software installed:

• Ubuntu Desktop 12.04.1 32-bit
• PostgreSQL 9.1.7
• PROJ 4.8.0
• GEOS 3.3.6
• GDAL 1.9.2
• PostGIS 2.0.2
• pgAdmin III 1.14
• qGIS 1.8

The VM will automatically log in as the user postgis with the password postgis.

Data

All data files linked below are available in the Data directory in the postgis user's home folder along with scripts for loading and querying the data.

• Philadelphia Neighborhoods Shapefile
• Philadelphia Libraries Shapefile
• Philadelphia Police Part One Crime Incidents CSV
• Azavea office coordinates
  • 2272 (PA State Plane): 2694727, 238558
  • 4326 (Lat/Lon): -75.1590100537934, 39.958950112686

Links

• The event page for this meetup
• The PostGIS home page
• The PostGIS 2.0 manual
• OpenGeo Introduction to PostGIS Workshop
• OpenDataPhilly
• PostGIS Dependancies
  • PROJ.4 Cartographic Projections Library
  • GEOS - Geometry Engine, Open Source
  • GDAL - Geospatial Data Abstraction Library
• Prebuilt packages and installers
  • OpenGeo Suite Community Edition (OS X, Windows, Linux)
  • PostGIS for OS X
  • PostGIS for Windows
• Azavea-built Applications Powered By PostGIS
  • Cicero
  • PhillyTreeMap
  • Visualizing Emancipation - University of Richmond
  • My Clinical Trial Locator
• CartoDB - PostGIS as a service

Questions?

@jwalgran for shorties, justin@walgran.com for longies.