PGCon2009 - Final Release
PGCon 2009
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Steve Singer |
| Schedule | |
|---|---|
| Day | Talks - first day - 2009-05-21 |
| Room | DMS 1110 |
| Start time | 14:30 |
| Duration | 01:00 |
| Info | |
| 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.