Enrich your data with geocoordinates from OpenStreetMap or ArcGIS

68 Pages·2015·3.03 MB·English

by  Scherbaum, Andreas

Enrich your data with
geocoordinates from
OpenStreetMap or ArcGIS
Andreas ‚ads‘ Scherbaum
Andreas Scherbaum
• Works with databases since 1997, with
PostgreSQL since 1998
• Founding member of PGEU
• Board of Directors: PGEU
• PostgreSQL Regional Contact for Germany
• Ran my own company around PostgreSQL
for 7+ years
• Joined EMC in 2011, working on PostgreSQL
and Greenplum projects
Get Social
• Google+: http://goo.gl/e3EtB1
• Twitter: @ascherbaum
ToC
Table of Content
• Why (enrich your data)
• How (to enrich your data)
• Measure (the results)
• What‘s next
Why (enrich your data)
Address Format
• If you are lucky:
Street HouseNr City ZIP Country
… … … … …
… … … … …
… … … … …
Address Format
• If not so lucky:
Address
1 Eagle Dr, Missouri, United States
1198 Toorak Rd, Camberwell VIC 3124, Australia
Widdersdorfer Straße 427, 50933 Köln
Need to parse and resolve that …
Geolocation Services
• Verify and normalize addresses
• Identify customer or address location
o Country, Region, City, Street
• Fraud Prevention
• Geo Marketing
• Geo Tagging
• Geo Targeting
• Value Added Tax in the European Union
o Tax is paid based on customer location
• Weather Forecast
• Concurrency Calculation
• …
Car Insurance Fraud
• Insurance companies offer savings based on
information like state/parking/living address
o Good to know how far away from the registered address (usual overnight
parking place) an accident happened or a car was stolen
o Address manipulation is a serious issue and a growing area for insurance
companies: compare all known addresses for a customer
o Find „hot spots“