Like us on FacebookFollow us on Twitter  Find us on Facebook and Twitter





Welcome to the CDXZipStream November 2015 Newsletter


The newest version of CDXZipStream has just been released.   This version works with both 32- and 64-bit Excel, and can use either Bing Maps or Microsoft MapPoint as a source of mapping data.  Included here is a short geocoding tutorial with the function CDXLocateBing, which shows how to use the new "Autocopy" and "Set to text" options when applied to lists of data.  We also review the current geographic coverage, for both road data and geocoding precision, provided by Bing Maps.


Here is our latest blog article:


- Features of the New CDXZipStream


CDXZipStream is Here


The new CDXZipStream, with Bing Maps and 32/64-bit compatibility, is now ready to demo and purchase.  A summary of all the new features available with this version can be viewed on our blog.


To try the new version, we recommend that you first uninstall your current version of CDXZipStream using the Windows Control Panel "Uninstall a program" option.  Then download the new version demo from the Product Demo area and run the installation file.  It is possible to use both old and new versions at the same time, but you may see two separate CDXZipStream commandbars and right-click menus.


If you decide not to upgrade, uninstall the demo and reinstall the old version of CDXZipStream.   Instructions and a download link are provided in this support article.


Pricing now includes a one-year data subscription.  If you have purchased CDXZipStream in the past and have an active data subscription, the new version is free. 


To use the Bing-compatible functions CDXRouteBing and CDXLocateBing, you will first need to enter a Bing Maps license key by selecting "Settings" on the CDXZipStream commandbar.  You can obtain a basic key from Microsoft, or from authorized Bing reseller OnTerra Systems you can get a free trial key or purchase an annual enterprise key.  OnTerra provides up to 100K daily data requests per enterprise license for up to five users. 


For more information on how to use CDXRouteBing and CDXLocateBing, click on "Help" on the CDXZipStream commandbar.  The new version still also provides the option of using CDXRouteMP and CDXLocateMP with Microsoft MapPoint.  Please note that Bing Maps does not provide route optimization at this time; we will be offering an alternative route optimization method in the near future.


If you have any questions you can reply to this email or contact us at or 1-877-CDX-TEC1.


Using CDXLocateBing


Both new Bing Maps functions, CDXLocateBing and CDXRouteBing, work very similarly to their counterpart functions that employ Microsoft MapPoint.  However, there now is a new "Autocopy" option, when working with a list of locations, that automatically obtains data for the entire list, until the first occurrence of an empty cell.  For long lists we also recommend using the "Set to text" option so data is returned as text rather than custom functions; this prevents formula recalculation and inadvertent requests to Bing Maps if the returned data is subsequently sorted or moved.


Here is a short tutorial showing use of the "Autocopy" and "Set to text" options when geocoding with CDXLocateBing:


Using Bing Maps in Excel to Get Latitude and Longitude

Using Bing Maps in Excel to Get Latitude and Longitude


Bing Maps Geographic Coverage


Bing Maps has some level of geographic coverage for every country in the world, with at least basic geocoding precision and major road coverage for over 250 countries.   In addition, route calculations have the option to include traffic flow in 35 countries, with two-thirds of those including traffic accidents.  Bing Maps also covers transit routes in 33 countries and 48 U.S. states.


The ability to precisely geocode (or reverse-geocode) is both a function of the road data coverage and the geocoding precision of the geocoding service.   Microsoft ranks both the level of road data coverage and geocoding precision for each country using the following categories:


Road data:

  • Good - The country/region has detailed road data available in most populated centers and most of these have been verified for accuracy.  Coverage is updated frequently. Remote areas may lack some road information.
  • Fair - At a minimum, the country/region has major road data available as well as some detailed road data. Most often, these roads have not been verified for accuracy. Coverage is updated over time. 
  • Major Roads Only - At a minimum, the country/region coverage includes major roads. These roads have not been verified for accuracy. Coverage is updated over time. 

There are 138 countries with either good or fair road coverage in Bing Maps.


Geocoding precision:

  • Rooftop - Addresses are resolved to the latitude/longitude coordinate at the center of the address parcel.
  • Address - Addresses are interpolated to a latitude/longitude coordinate on the street in front the actual building or location.
  • Street Name - Addresses are resolved to the latitude/longitude coordinate of the street that contains the address. The address number is not processed.
  • Basic - There is no specific support for geocoding in this country/region, or this country/region has a low quality data provider. If the address is valid, Bing Maps attempts to resolve it, but a result is not guaranteed.

There are 69 countries with either rooftop- or address-level precision in Bing Maps.


You can refer to the Microsoft website for specific country listings.


Latest Data Updates


Canadian and U.S. data feeds were updated as of November 25.  There were 131 changes made to the U.S. database this month.  If you would like to update your database to reflect these changes, click on the "License Information and Software Updates" icon on the CDXZipStream toolbar, and select "Data Updates" to login to your account.


We hope you find the information here helpful for you and your organization.  You can contact us with your feedback and suggestions by replying to this email.


The Team at CDX Technologies 

November 2015



Map of the World


In This Issue 


CDXZipStream is Here


Using CDXLocateBing


Bing Maps Geographic Coverage


Data Updates