Cooking GeoData with PostGIS

Session Audio

Excerpt

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

Description

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.