[AccessD] Google API for address sanitising

[Gustav Brock]

Hi John

It was here:

http://stackoverflow.com/questions/41249742/address-standardization-within-a-database

- the answer from another John.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af John Bodin
Sendt: 21. december 2016 13:55
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Google API for address sanitising

Not sure where you found that Gustav, but works really well, and fast!  Put that one in the utility chest.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, December 21, 2016 2:34 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Google API for address sanitising

Hi all

Did you know that you can sanitise an address by a single call to Google API? It even accepts our European and localised spelling and returns these correctly. For example, a call containing our malformed company address:

    https://maps.googleapis.com/maps/api/geocode/json?address=kalkbranderiloebsk 4A, DK - 2100 København

returns a Json with the correct spelling and postal code (country code DK should not be prefixed):

    "Kalkbrænderiløbskaj 4A, 2100 København Ø, Danmark",

Replace the commas, and you have the correct address block:

    Kalkbrænderiløbskaj 4A
    2100 København Ø
    Danmark

Indeed, for our US friends it can very useful, as you have a bad habit of abbreviating street names.

As you may know, there is a limit for free calls of 2000 per day. If more, you need a paid license - it should be quite fair though.

/gustav