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. 

Put addresses on a map as markers

We’ve already looked at how to geoCode addresses using various APIs and how to create maps with Google Maps from Excel data.  Now let’s look at using Bing Maps  to put markers on a Map using an Excel worksheet as input. As usual you can find the completed example in the googleMapping.xlsm download. Before running this please check the parameter worksheet and change the filename value  for the place that the application will generate a web page to something relevant for your machine. Look for the  filename in the Ovi Marker html section of the Parameter Worksheet.

Ovi Maps versus Google Maps

Ovi Maps has some fairly different concepts to Google Maps and seems to have a very rich (and sometimes incomprehensible) api. However I was able to handle any difference in the javaScript in the Parameter Worksheet, so the only difference in Excel code between Ovi Maps and Google Maps is to use a different parameter block. The JavaScript is pretty different though.

Here is the Google Code

versus the Ovi Code

Although Ovi Maps says it needs a key, it seems to work without one, so I left that out.

How does it look

The Ovi Maps are gorgeous, but the popups are a bit basic and it took me ages to figure out how to attach a title to each marker. Its a built in capability in the others but you have to listen for mouseover events and build a box with Ovi. Easy enough when you know you have to.

I’ve implemented this exact same thing on other APIs as below.  Take a look to compare. My recommendation is to stick with Google Maps.

The generated file is shown below


OVI turned out to be real nice, if a little esoteric. However the documentation for the API is confusing, overly complex and written in a strange, uninteresting syntax.  That said this a nice, feature rich API. Since Yahoo Maps is going away, and Bing sucks, it is worth considering this as a contender for Google Maps. Please join us on our forum for discussion, questions and feedback.