Resolving addresses to geocoordinates, using OpenStreetMap or ArcGIS

77 Pages·2015·3.57 MB·English

by  Scherbaum, Andreas

Resolving addresses to
geocoordinates, using
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
ToC
Table of Content
• Why (resolve addresses)
• How (to)
• Measure (the results)
• What‘s next
Why (resolve addresses)
Address Format
• If you are lucky:
Street HouseNr City ZIP Country
… … … … …
… … … … …
… … … … …
Address Format
• But usually:
Address
House
1 Eagle Dr, Missouri, United States
number in
1198 Toorak Rd, Camberwell VIC 3124, Australia
front of
Widdersdorfer Straße 427, 50933 Köln street
Kexueyuan South Road,
Zhongguancun, Beijing 100190, China
北京市海淀区科学院南路2号融科资讯中心C座南楼5层
Address Format
• But usually:
Address
1 Eagle Dr, Missouri, United States
ZIP code
1198 Toorak Rd, Camberwell VIC 3124, Australia
after city
Widdersdorfer Straße 427, 50933 Köln name
Kexueyuan South Road,
Zhongguancun, Beijing 100190, China
北京市海淀区科学院南路2号融科资讯中心C座南楼5层
Address Format
• But usually:
Address
1 Eagle Dr, Missouri, United States
House
1198 Toorak Rd, Camberwell VIC 3124, Australia
number after
Widdersdorfer Straße 427, 50933 Köln
street, ZIP
Kexueyuan South Road, code in front
Zhongguancun, Beijing 100190, China of city
北京市海淀区科学院南路2号融科资讯中心C座南楼5层
Address Format
• But usually:
Address
1 Eagle Dr, Missouri, United States
1198 Toorak Rd, Camberwell VIC 3124, Australia
Widdersdorfer Straße 427, 50933 Köln
ZIP code
Kexueyuan South Road, after city
Zhongguancun, Beijing 100190, China name
北京市海淀区科学院南路2号融科资讯中心C座南楼5层