Cooking GeoData with PostGIS

Accepted Session
Short Form
Scheduled: Wednesday, June 22, 2011 from 4:45 – 5:30pm in B304


Importing, managing, correcting, reprojecting and mashing up geodata with PostGIS and OGR


If you’re doing interesting things with geospatial data you will need to take multiple sources in various formats and with bizarre non-standard projections. This session is focused on practical recipes for dealing with esri shapefiles as provided by local governments, raster data from sensor surveys, and other stranger formats that are out there.

Items that will be covered include:

1. How to read a projection that doesn’t match anything in spatial_ref_systems

2. How to register geotiff and dem datasets onto polygons (so you can do things like calculate the vegetation groundcover percentage on taxlots).

3. Exporting geodata to other file formats for use in other programs.

This is an intensely practical session that is designed to help fill in some of the knowledge gaps that those starting out working on geographic data have. Some basic knowledge of postgresql and the bash shell is assumed.

Example data sets will be drawn from the US Census, the City of Albany (Oregon), state of Oregon vegetation surveys and other sources.

Speaking experience