|
  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
2.1.0.12 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 support@CDXTech.com or 1-877-CDX-TEC1.
|
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
|
|
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:
- 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.
- 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.
|
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
|
|
|
|
|
In
This Issue
CDXZipStream 2.1.0.12 is Here
Using CDXLocateBing
Bing Maps Geographic Coverage
Data Updates
|
|
