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“