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

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