[AccessD] Google API for address sanitising

[Gustav Brock]

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