2022 American Community Survey Data Release

The CDXZipStream ACS data feeds for state, county, ZIP code (ZCTA), place, CBSA (Core-Based Statistical Area) and Tract have been updated with the latest data releases from the U.S. Census Bureau. These data are from the American Community Survey, which surveys hundred of thousands or individual addresses monthly. It is the largest and most detailed survey that the US Census conducts. These feeds are available in the CDXZipStream Premium ACS version. Data are aggregated over the years 2018 through 2022.

 

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. For a full listing of all data fields included in the feeds, please download the CDXZipStream Data Feeds and Definitions file here.

 

If you already own CDXZipStream ACS Premium and have an active data maintenance contract, select the "Account" option on the CDXZipStream Excel menu and click on "Check for Available Database Updates". Then select the option to update your premium database. 

 

For users without an active account you can update your data feeds by logging into your on-line account on CDXTech.com. Under "My Account", then "Product Management", select "Buy Data Update" and then purchase the Premium Maintenance contract. If you don't have the correct CDXZipStream version select "Upgrade License" in the account area and select the option to upgrade to the ACS version. The latest data will automatically be included with your purchase.

New User Account Interface at CDXTech.com

We've updated our user interface when you log into our website. So things will look a bit different than the last time you visited. All of the menu navigation options will now be available on the left hand side of the screen as shown in the image below.

The previous menu appeared at the top did not persist when clicked as the new interface does. To expand or contract the various areas, simply press the + or - icons shown. The menu items have exactly the same functionality as in the previous interface. If you have products other than CDXZipStream they will be show as separate sections.

 

Quick Radius Report with CDXDistance

We've covered in past articles how to use the CDXRadius function to analyze the closest locations in mailing lists and other data applications. The basic technique is to create a CDXRadius formula report and then evaluate the distance of every item in the list using an Excel VLookup command. For more detail on this please see the support article we've previously published Advanced Zip Code Radius Calculator and Finder with Microsoft.

 

The technique with CDXRadius works best with large lists and if you will be using the same radius report repeatedly. For shorter lists and quick reports you can use the CDXDistance functions by adding a simple formula.

 

The spreadsheet below shows an example customer list where we want to evaluate all customers within 100 miles of the zip code 07869.

To do this simply enter the following formula beginning in the first row of your data which in this case is cell H3 referencing the first customer zip in G3.

 

=IF(@CDXDistance(G3,"07869")<=100,"YES","NO")

 

and then copy this down your list.

 

The formula returns "YES" or "NO" depending if the customer is within the specified radius. Should you wish you can also include fixed cell references (i.e. $A$1) for the central zip code and radius distance to make updating easier. This technique is also more forgiving than using VLookup when your customer data includes zip codes without leading zeroes or with Zip+4. It also works well with our Canadian database as well as with US data.

 

CDXZipStream Bulk Radius Analysis Template

One common request we often hear is how to run radius calculations in bulk. For instance, if you'd like to know all ZIP Codes within a 10 mile radius of a list of Zip Codes. This information can be used in performing a nearest store report, optimizing business locations or other applications. We've previously covered techniques for this as described in the blog post Get Radius Information for a List of ZIP Codes.

 

To help automate this we've developed a template to streamline the creation of these lists. Just one click can analyze thousands of zip codes. The free template along with may others is available to CDXZipStream users on our website who have the Lite Version of CDXZipStream or better.

 

Shown below is an example of a bulk radius report.

Just enter your ZIP Code list in column B. You can use the CDXZipList right-click function to generate a list of zip codes by city, state or county for this input. Use the option to only return the zip code column.

 

Then specify a radius distance and press "Calculate". Beginning in Column C, all ZIP Codes within that radius will be shown in individual cells. A radius distance up to 200 miles can be specified. The template has also just been updated to be able to use the latitude and longitude formats (i.e. 40.84|-74.56) rather than zip codes. This format was added with the CDXZipStream 5.4 release covered in last months newsletter.

 

You can also choose to return both the zip code and distance by clicking the check box on the right of the screen. Options to use the U.S. or Canadian databases are also available.

 

CDXZipStream Version 5.4 Released

We have just released CDXZipStream version 5.4. For existing users with access to the CDXRadius function we’ve added the ability to center the radius on a specific latitude and longitude as well as zip codes. This version also now includes U.S. Census 2020 data as part of the CDXZipStream demo along with access to the new 2020 Census data feed. Additionally, we’ve also updated our Maptitude functions to support the 2023 Caliper Maptitude release. Other improvements were made as well including updated routing maps with the CDXRouteBing function.

 

To use the new CDXRadius capability, simply enter the numeric latitude and longitude separated by a pipe character (instead of a zip code) as shown in the image below.

 

 

This will allow you to more accurately center radius results on your exact business or other central site.

 

To get this new feature you need to install CDXZipStream version 5.4.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