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





Welcome to the CDXZipStream November 2011 Newsletter


We'll be reviewing some more of the new features of CDXZipStream version 11.  In October we introduced the new Canadian database, Census 2010 feed, and drive time mapping; this month we'll discuss the new settings capability from the main toolbar and the ability to toggle between North American and European versions of MapPoint.  We also provide a little tip on how to retrieve all zip codes in the U.S.


There are three new blog articles for November: 


  Calling CDXZipStream with Visual Basic

Toggle Between MapPoint Europe and North America


CDXZipStream was originally designed for use with Microsoft MapPoint North America, but our growing client base has successfully used it with the European version as well.  With the addition of an Application Settings option on the toolbar of CDXZipStream 11, you now can pick and choose which version of MapPoint CDXZipStream will use, depending upon the location of the data being analyzed.  


Just go to the CDXZipStream toolbar at the top of your screen, and click on the fourth icon from the left.  (In Excel 2007 and 2010, remember to click on "Add-ins" first).   Use the dropdown list to choose which version of MapPoint you would like to use, and click OK.  And you're done! (If you only have one version of MapPoint installed on your computer, CDXZipStream will automatically use that one; you don't have to worry about setting this feature at all.) 


Keep in mind that if you're performing an analysis for locations in Europe, and the MapPoint setting is North America,  CDXZipStream will not work.  If you find that "Data Item Not Found" is being returned consistently for the locations in your worksheet, please check that the correct MapPoint version is selected.


As an aside, MapPoint is only available in the two N.A. and European versions.  The level of mapping detail varies from country to country, and this does impact the routing, geocoding, and address verification calculations in CDXZipStream   In North America, both the U.S. and Canada have excellent street-level detail, but Mexico has only limited street coverage.  In MapPoint Europe 2011, detailed street-level maps are available for Austria, Belgium, Denmark, Finland, France, Germany, Greece, Italy, Luxembourg, the Netherlands, Norway, Portugal, Spain, Sweden, Switzerland and the United Kingdom.  Limited street level coverage is available for Albania, Andorra, Bosnia and Herzegovina, Bulgaria, Crotia, Czech Republic, Estonia, Gibraltar, Guernsey, Hungary, Ireland, Jersey, Latvia, Lithuania, Liechtenstein, Macedonia, Isle of Man, Monaco, Montenegro, Poland, Romania, Serbia, Slovakia, Slovenia, San Marino, and Vatican City.


New Application Settings Button on the Main Toolbar


CDXZipStream Application SettingsNow you can access CDXZipStream general settings, route settings related to driving calculations, and set the MapPoint version, all from main CDXZipStream toolbar. Just click on the (new) fourth icon from the left, and you'll see the dialog box shown here.  The CDXZipStream and Route settings are not new; this just offers another easy way to access them.  You can still access these the traditional way, either through the main CDXZipStream interface, or through the interface provided with the right-click function CDXRouteMP.  The settings related to MapPoint is a new feature.  Please refer to the discussion directly above for more information.


How to Get a Complete List of U.S. Zip Codes


Here's a quick and easy tip to retrieve all the zip codes in the U.S. Pick a zip code (it doesn't matter which one, any valid U.S. zip code will do) and use the right-click function CDXRadius to find all the zip codes within a 10,000 mile radius.  You will need to specify a maximum number of rows of 50,000.  The input looks like this:




All zip codes in within a 10,000 mile radius of 62895 will be returned, which will include all U.S. zip codes.  If you purchased the Canadian database, make sure not to include Canadian postal codes in this analysis, since the number of Canadian postal codes will exceed the allowable number of maximum rows (65,000).


November Data Updates


Canadian and U.S. data feeds were updated as of November 28 and 29, respectively. There were 74 changes to the U. S. zip code database.  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.  If you've forgotten your user name or password, please contact us at


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

The Team at CDX Technologies  

November 2011



Map of the World


In This Issue

 Toggle Between MapPoint Europe and North America


New Application Settings Button on the Main Toolbar


How to get a Complete List of Zip Codes  


How to get a Complete List of Zip Codes  


November Data Updates








CDX Technologies | 2 West Hanover Avenue | Suite 212 | Randolph | NJ | 07869