PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Steve Singer
Day Talks - first day - 2009-05-21
Room DMS 1110
Start time 14:30
Duration 01:00
ID 141
Event type Lecture
Track GIS
Language used for presentation English

OpenStreetMap with PostgreSQL

The free wiki world map & PostgreSQL

The OpenStreetMap project is trying to build a free (as in beer) editable electronic map of the world. Data is collected by ordinary people running around with GPS units, tracing imagery and by integrating existing datasets. This talk will an introduction to OpenStreetMap and an overview of how the OpenStreetMap data can be used with PostgreSQL/PostGIS.

The OpensStreetMap project has over 100 thousand registered users who have mapped over 2 million road segments, 24 thousand pubs and at least 2 Elephants. The talk will start out explaining the OpenStreetMap project, the types of data in OpenStreetMap and an overview of how it is stored.

OpenStreetMap is believes that users should be able to apply any tag to any piece of data. The system and schema enforce very little structure on user data instead depending on community consensus for consistent tagging. OSM gives provides 3 basic data types, nodes, ways and relations and can be associated with each other. Any set of key/value tags can be added to instances of any of these types.