This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - Nordic PGDay 2015

Enrich your data with geocoordinates from OpenStreetMap or ArcGIS

Date: 2015-03-11
Time: 10:30–11:20
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.


Andreas Scherbaum