New Video - Calculating Driving Distance in Excel with CDXZipStream and Bing Maps

We've posted a updated video which covers using CDXZipStream with Bing Maps to solve common logistics problems.  This video covers using CDXZipStream software to analyze driving routes in Microsoft Excel.  The custom function CDXRouteBing is described which works with Bing  to calculate driving distance or time between 2 or more addresses. Typical business problems such as analyzing a list of locations or optimizing a delivery route with a map are demonstrated.

You can view the video below or on Youtube.

This and all futures CDX videos will be posted on our website and new CDXTech Youtube channel.  Please consider subscribing to our YouTube channel and turning on notifications so you can get the latest news on our products.

 

 

 

Geographic Access Analysis Template Update

This template can quickly and easily identify locations or resources that are closest to a long list of customers. We've talked about our Geographic Access Analysis template as a solution for this problem in prior blog articles and videos such as the following: 

The template initially produces a straight-line "as-the-crow-flies" distance report so it can rapidly sort and compare locations, tens of thousands at a time.  This latest release now includes the ability to geocode using the CDXZipStream local database.  The "Map Data Source" selection dialog now includes a new function "CDXZipCode" that offers this new capability. If you just need zip code accuracy, this is the fastest geocoding feed available and does not consume any requests from Bing or the other sources.  The zip code column in the template is used for the data input and must be fully populated.

The Geographic Access Analysis template is now on sale at $99.95 and can be purchased in your online cdxtech.com account in the "Buy Data Update" menu. This includes support and access to the latest template for 12 months. A demo of the template is also now available by contacting sales@cdxtech.com

CDXGeodata Now Support US Census Geocoding

CDXGeoData is our cloud based software that makes location analytics available on multiple platforms such as Windows, Linux, MAC OS and others.  It can verify address data, look up ZIP+4 codes, retrieve ZIP Code demographics, and can now use the US Census website for geocoding by address.    

CDXGeodata can be accessed through a set of spreadsheet apps and web-services. It can be used by programmers to develop custom desktop or web-based applications.  The CDXGeoData Web Services API uses REST (REpresentational State Transfer), which builds web services that are lightweight, easy to maintain, and scalable.

Here's a short tutorial showing how it works with a Microsoft Excel template:

 The software above has been updated to support the new US Census feed GeoLocateCensus as well as the existing Bing and standard Zip Code web services.   This new feed can also supply tract information based on an address that can be used in conjunction with our CDXZipStream census tract database. 

You can get a free API key to try CDXGeodata at the following link. Additional tokens can be purchased as needed, and any number of users can access the data service under a single key.  This is especially useful for a one-time analysis or for specific functions that require access by a large number of users.  Unlike CDXZipStream and CDXStreamer, no additional software purchase or deployment is necessary.  Please refer to our website for data pricing information.

CDXZipStream Geocoding Template Update

This template allows you to geocode a list of addresses using data sources such as Bing to display the determined latitude and longitude.  

 
In addition to the existing geocoding sources (Bing, Maptitude and Mappoint) we've added the ability to use our local zip code database to geocode just by zip code. The "Map Data Source" selection dialog now includes a new function "CDXZipCode" that offers this new capability. If you just need zip code accuracy, this is the fastest geocoding feed available and does not consume any requests from Bing or the other sources.  The zip code column in the template is used for the data input and must be fully populated.

The template will now work with any CDXZipStream version.  The Lite and Findzip versions of CDXZipStream will now be able to use the new CDXZipCode data feed.  The CDXZipStream Bing or better version is still required to geocode by full address. The template can be download for free here.  

CDXZipStream Version 4.1 Update

We've upgraded CDXZipStream to increase the speed and performance of the CDXZipCode and CDXDistance functions. Caching is now employed so that repeated calls to the same Zip Code will come from memory and not the external database.  This provides an order of magnitude performance increase.  This is important when doing repeated operations such as a distance matrix or retrieving multiple data items from a single zip.

To get this new feature you need to install CDXZipStream version 4.1.0.1 or better which is the current trial version on our site. There is no cost to get access to the update. The installation file for this can be downloaded here.