[AccessD] Google API for address sanitising

[Tina Norris Fields]

Thank you, Jim, for the link and the comments. All very useful.

TNF

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

On 12/21/16 8:46 AM, Jim Dettman wrote:
>   and if your just getting into stuff like this, this will be helpful:
>
> https://github.com/VBA-tools/VBA-Web
>
>   and on the point of sanitizing addresses, just about any of the map
> services will do that (MapQuest and Bing for example).   All have different
> usage requirements though and at some point, you have to start paying.
> MapQuest has made some recent changes that might make it more attractive
> than Google as they are trying to compete.
>
>   The only other thing I'd add is be careful adding this into your apps.  In
> regards to Google, I thought 2000 calls a day would never be hit, but what
> you find is that it's quite easy to get there, even on a moderate sized app.
> That's because it's not 2000 calls of checking an address, but 2000 calls a
> day to the site in total.   That includes addressing, lat/long lookups, push
> pin mapping, getting info on a place, etc.   Depending on the task, you may
> make multiple calls in order to get it done.  Those can add up quickly.
>   
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Gustav Brock
> Sent: Wednesday, December 21, 2016 02: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