CDXZipStream Bulk Radius Analysis Template

27 November 2023 Bill-Hughes

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

04 October 2023 Bill-Hughes

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. 

New Web-Based Geographic Access Analysis App

22 September 2023 Bill-Hughes

We are continuing to add to our product line of CDXStreamer browser-based tools. A new application for Geographic Access Analysis has just been released.

 

Geographic Access Analysis (also known as closest store analysis) is a method used to assess the proximity of various resources, services, or facilities in relation to specific geographic locations. It is an essential report needed by business, the medical industry, government, and other fields.

 

This tool allows you to upload a set of location postal codes along with a list of target postal codes in a spreadsheet in an excel or .csv file. The user can set a radius distance along with the maximum number of targets to be returned before starting. A report will then be produced which orders the locations by distance in ascending order for each target. Only targets within the radius specified up to the maximum number will be shown. Both US Zip Codes and Canadian Postal Codes are supported.

 

For a tutorial on using the new app please see the following video.

 

If you would like to see how this all works you can try CDXStreamer for free for 7 days for up to 1000 total requests by signing up for our free trial.

 

New Census 2020 Database Now Available

03 August 2023 Bill-Hughes

 CDXZipStream Premium and Premium ACS versions now include a new Census 2020 Decennial database. This is in addition to the changes outlined in last months newsletter to the main zip code CDXZipStream database.

This new database table named CDXCensus2020 can be accessed in the CDXZipStream main Excel menu. Simply press the first "CDXZipStream" button and in the "Select Data Feed" option choose "CDXCensus2020". It is also available in the CDXZipStream right click option in the "Additional Data Feeds" area at the end of the list. The data is organized by ZCTA (Zip Code Tabulation Area) and includes the 33,774 zip codes the US Census covers.

The data items in this table include.

1.  Population by Age Bracket

2.  Male and Female Population by Age Bracket

3.  Housing statistics such as Household Size Brackets.

4.  Owner Occupied ,Renter Occupied and Vacant housing counts.

5.  Race and Hispanic Data

6.  ACS (US Census American Community Survey) 2021 Population Data

 We've also updated our CDXCity, CDXCounty, CDXState and CDXCBSA databases with data from the 2020 Decennial Census, 2021 ACS Survey and latest business data.

For a full listing of all data fields included in the feeds, please download the CDXZipStream Data Feeds and Definitions file here.  

 CDXZipStream now includes databases for the Census 2000, 2010 and 2020 Decennial surveys making it a comprehensive resource for demographic reports where you can easily review decade long trends.

 If you already own one of the CDXZipStream versions mentioned above 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.  You must have the database version 3.01 or later for this update. If you do not see the new databases after installing the update please install the latest version of CDXZipStream.

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 a premium version. The latest data will automatically be included with your purchase.

 

Decennial 2020 U.S Census Data Now Available

09 June 2023 Bill-Hughes

The CDXZipStream Premium zip code database has been updated with demographic data from the Decennial 2020 U.S Census.  This data was just released by the US Census.  These updated data fields are available in the CDXZipStream Demographics, Premium, and Premium ACS versions. 

The data items which previously included 2010 census data and have been updated to 2020 include.

  1. Population by Race
  2. Hispanic and Non-Hispanic Population
  3. Male/Female Population.
  4. Median Age data in total and by sex
  5. Income
  6. Housing and Household data

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 one of the CDXZipStream versions mentioned above 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.   You must have the database version 2.28 or later for the 2020 Census update.

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 a premium version. The latest data will automatically be included with your purchase.