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

Hartmut Holzgraefe (...???...)
GIS, PHP and MySQL, PostgreSQL
Location: Ballroom D
Average rating: ****.
(4.00, 1 rating)

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

Hartmut Holzgraefe


PHP contributer since 1999 MySQL user since 2000 MySQL Support Engineer 2004-2010

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts