Sessions at Open Source Bridge 2011 about postgis

Wednesday 22nd June 2011

• Cooking GeoData with PostGIS

  by Larry Price

  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.

  • geodata
  • GIS
  • Open Data
  • postgis
  • PostgreSQL

  At 4:45pm to 5:30pm, Wednesday 22nd June

  Coverage note