Schedule - Nordic PGDay 2015
Enrich your data with geocoordinates from OpenStreetMap or ArcGIS
Room: Falconer 202-203
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.