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





Welcome to the CDXZipStream January 2014 Newsletter


Demographic data feeds associated with the American Community Survey have all been updated with the latest release from the U.S. Census Bureau, covering states, counties, Core Based Statistical areas, cities, ZIP code areas, and census tracts.  CDXStreamer, our Microsoft Excel add-in for address verification and correction, now is available with both fixed-request (one-time) and subscription pricing.  And we also review some of the reasons you may want to look into our free downloadable templates for accessing CDXZipStream functions.  


New Fixed-Request Pricing for CDXStreamer


CDXStreamer is our Microsoft Excel add-in that can perform address verification and correction, with data feeds covering Zip+4, Tiger/Zip and Canadian postal data. It is now available through one-time, fixed-request plans as well as by subscription as shown below:


Plan 1: Up to 5,000 data requests ($29.95 per month by subscription, or $59.95 one-time)  

Plan 2: Up to 10,000 data requests ($39.95 per month by subscription, or $79.95 one-time)  

Plan 3: Up to 20,000 data requests ($59.95 per month by subscription, or $99.95 one-time)  

Plan 4: Up to 50,000 data requests ($99.95 per month by subscription, or $169.95 one-time)  

Plan 5: Up to 100,000 data requests ($149.95 per month by subscription, or $249.95 one-time)  


One-time data requests are available for a period of one year from the date of purchase.  For more information about CDXStreamer, please see the article Address Verification and Address Correction In Excel with CDXStreamer and our website.


Newest Data Release From the American Community Survey

US Map 

The U.S. Census Bureau released last month the latest 5-year American Community Survey data aggregated over the years 2008 - 2012. This data has now been incorporated into the ACS demographic data available in the CDXZipStream Premium ACS version, for the following feeds:


CDXACSZCTA - For Census-defined ZIP code tabulation areas, very similar to USPS ZIP codes.


CDXACSCBSA - For Core Based Statistical Areas in the U.S. and Puerto Rico, which are urban centers with a population of 10,000 or more.


CDXACSPlace - Covers all Census-defined "places" such as cities, towns, boroughs, and other small geographic areas. This feed includes all places in the U.S. and Puerto Rico with a population of 10,000 or more.


CDXACSCounty - Covers all counties in the U.S. and Puerto Rico.


The latest 5-year aggregated results were also updated in the feed covering census tracts, CDXTract.  CDXTract is available as a separate purchase and is compatible with all demographic versions of CDXZipStream (Population, Demographics, Premium, and Premium ACS).  Census tracts are about half the size of ZIP codes and provide a very accurate demographic picture for a specific area. Please see our article Get Census Tract Demographics in Microsoft Excel for more information on how to use the CDXTract feed.


State demographic data in the feed CDXACSState have been updated with the latest 1-year data from 2012.


The demographic areas covered in all ACS feeds are: age, population, household size, household income, individual earnings, race and ethnicity, educational attainment, school enrollment, housing value and rent, mortgage status, and marital status. With this latest update we have provided more detail for the population in various age categories, consistent with the categories provided by the Census Bureau. For a full listing of all data fields included in the feeds, please download the CDXZipStream Data Fields and Definitions .xls file here.


If you already own CDXZipStream ACS Premium, you can login to your on-line account on and under My Account and Product Management, select "Buy Data Update" to obtain the newly updated feeds.   If you would like to upgrade your license to CDXZipStream ACS Premium or any of the demographic versions (to use CDXTract), select "Upgrade License" from your account area and follow the purchasing process; the latest data will automatically be included as part of the upgrade.  


Making it Easy with CDXZipStream Templates


We offer a number of free templates that make it a snap to access CDXZipstream functionality even for the novice Excel user.  Just copy and paste your data into the appropriate template, click a button or two, and the template does the rest.  They were originally designed for analysis of large data sets, but we've found that their ease-of-use makes them ideal for almost all cases where there's a need to perform driving calculations, geocoding, radius analysis, and more.  Here are some of their other advantages:


Speed:  The templates contain programming code that access CDXZipStream functions directly, instead of through the Excel interface.  This can significantly speed up processing times for long lists of data.


Data returned as values:  Although CDXZipStream formulas come in handy most of the time, long lists of formulas can slow down an Excel worksheet.  The templates are designed to return values, not formulas, so the data is immediately ready to use.


Progress tracking:  With Excel 2007 and higher an indicator in the status bar will show the progress of the calculations. 


The templates are all compatible with CDZipstream and Microsoft MapPoint trial versions.  For more information on the kinds of calculations they can do, please see the article Pick Your Excel Template.  They can be downloaded directly from our links page.


Latest Data Updates


Canadian and U.S. data feeds were updated as of January 16 and January 24, respectively.  There were 140 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.  Please contact us with your feedback and suggestions by replying to this email.


The Team at CDX Technologies 

January 2014



Map of the World


In This Issue

New Fixed-Request Pricing for CDXStreamer


Newest Data Release From the American Community Survey


Making it Easy with CDXZipStream Templates


Data Updates