Openstreetmap -> (PostGIS|MySQL|SpatiaLite) -> OpenLayers: From Map to Web

OpenStreetMap raw data for any non-trivial area comes as a massive amount of XML (or alternatively in the near future: Protobuf based binary) data.

Making a map from that data directly is possible but given the sheer amount of data to process it is usually not feasible, especially if you are only interested in a very limited set of map features (like e.g. a map highlighting all local playgrounds within walking distance)

The typical way to actually process the map data is to import into a PostGIS database first that contains it in a slightly preprocessed form already and then operating on that database for map feature retrieval.

The talk will show how to:

• get the raw data
• import it into (PostGIS|MySQL|SpatiaLite)
• keep it up to date with regular (minutely, hourly, daily) deltas
• perform queries for simple and complex map features
• present query results in dynamic web maps using the OpenLayers JavaScript framework