Schedule - FOSDEM PGDay 2015

Enrich your data with geocoordinates from OpenStreetMap or ArcGIS

Date: 2015-01-30
Time: 12:30–13:20
Room: Place Sablon
Level: Intermediate

BOfH subtitle: Mark your customers profiles with ICBM coordinates

Companies collect huge amounts of data. In order to provide location based services, address data must be coupled with geocoordinates and location based events must be coupled with nearest address information.

That's not an easy task: geocoordinates not always match an exact address, and addresses can have a broad variety of formats which makes them unpleasant to parse and locate on a map.

This talk shows how addresses in your database can be resolved (geocoding) to coordinates, and geocoordinates can be transformed into addresses (reverse geocoding), all from inside a PostgreSQL database. Two different data sources are used, Open Street Map and Esri ArcGIS.

Speaker

Andreas Scherbaum

Sponsors