GeoCoding Master Data

Deprecated

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also been either removed or changed. Therefore, I had to remove all examples of VizMap applications I had created. I didn’t remove the entire topic as I thought some of the code may still be useful with some modifications. 

GeoCoding Master Data 

This parameter block is handled by cDataSet classes and provides a mapping of fields that are required on a Google Map or its visualizations and where to find them in Excel WorkBook.

The complete workbook (googlemapping.xlsm) can be downloaded and the example Parameter WorkSheet is called GeoCodingParameters and is common for all VizMap applications.

Combining GeoCoding with VizMap

I have not included a javaScript geoCoding capability directly in VizMap- meaning that geoCoding needs to already have been applied to the input data. Here’s why. 

• We already have a GeoCoding module, which is capable of using Bing, Yahoo, Ovi and Google so you can use whichever to get the best results rather than restricting it to just Google
• Once coded, you dont need to be re-geocoding a table entry over and over. It’s not going anywhere.
• The usual mode of operation for a VizMap application is that a transactions worksheet is  matched with a static master worksheet  (which already includes the geocoded data)
• Some providers place restrictions are placed on the amount of geoCoding you can do, and with some commercial plans it can increase the cost – so geoCoding should be kept to where it is necessary.
• It is easy to combine vizMap generation with geoCoding if you need it anyway.

Including Geomapping

As you can see below, only one line of VBA code is needed to apply geocoding before generating the VizMap application.  paramName is a string that identifies the name of the parameter worksheet specific to this application. ‘ geocode the master    googleMappingExample paramName    ‘ create tabbed/viz/mapped app    googleMarkingViz paramNameIf you need to know how geoCoding Works, take a look at GeoCoding Questions, feedback and VizMap applications you have generated can be submitted for loading to this site via our forum.   Next you should decide whether you need to decide whether you need to do geoCoding every time you generate your application, or whether you are going to use a fixed master sheet of pre-geoCoded data.