[AccessD] Google API for address sanitising

[Tina Norris Fields]

Thank you for that, Gustav. I will make use of it.

TNF

Tina Norris Fields
tinanfields-at-torchlake-dot-com
231-322-2787

On 12/21/16 2:34 AM, Gustav Brock wrote:
> 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