Mapping visualization layers from Excel
The Google Maps API is a wonderful thing, allowing you to convert an unstructured and incomplete address and get back a whole bunch of structured and mapping data.
Google is clear that it is only to be used for addresses to be placed on a map (not to be used to ‘clean’ a list of addresses for example), and in fact there is quota on your use to make sure that you do not use it for this purpose.
However this new project is about mapping summary and transaction data on google maps, so I need to use the Maps API to summarize at country, state and other levels.
The first phase in this can be seen here, with a downloadable example showing how to interact and decode the response from the Google Maps API.