We are continuing to add to the breadth and scope of our CDXStreamer browser based tools available at cdxtech.com. A new Bulk Location Data Batch Report has been added that can perform forward and reverse geocoding.
This application works in a similar fashion to our Address Correction and Zip+4 tool. The major difference in the tools is the Location tool can handle worldwide addresses whereas the Address tool only covers the US. Partial or “Fuzzy Information” such as just a street address can also be entered to return possible matches. You can also simply enter two columns with latitude and longitude for reverse geocoding.
To use the application upload an Excel (xlsx) file or csv file to the application and it will produce an output report covering the best match, latitude, longitude and other relevant address data.
The tool can handle up to 10,000 locations at one time and uses the HERE API as a data source. When the report is created you will receive a download link and an email receipt. Locations can be entered as complete or partial addresses, zip codes or geocodes. It will work for US or International locations, any country that HERE supports.
There is a $9.95 minimum report charge and it can be used with your CDXStreamer account for lower costs. Just a web browser is necessary to run the tool, no additional software is required.
You’ll find the tool is useful if you have just a one-time report requirement or if you need to deploy and this type of application to your entire workforce. A single CDXStreamer license covers an unlimited number of users. CDXStreamer is just billed on the number of requests and does not require a separate license as CDXZipStream does.
For a tutorial on using the Location Data tool please see the following video.
The CDXZipStream ACS data feeds for state, county, ZIP code (ZCTA), place, and CBSA (Core-Based Statistical Area) have been updated with the latest data releases from the U.S. Census Bureau. These data are from the American Community Survey, which surveys about 1 out of every 38 households every year. These feeds are available in the CDXZipStream Premium ACS version. Data are aggregated over the years 2015 through 2019, with the exception of state demographics, which are provided for the year 2019.
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.
We’ve updated the CDXZipStream templates that involve geocoding and driving distance to include HERE Technologies API support. In additional to Bing an additional option is now available for HERE. Just select HERE from the "Map Data Source" dropdown to use it as shown below.
Adding HERE allows you to have access to a high accuracy geocoding source with up to 250,000 free requests per month.
The templates updated include.
Geocoding Template
Reverse Geocoding Template
Driving Calculations Template
Driving Calculations Matrix Template
Geocode and Sort By Distance Template
Geographic Access Analysis Template
Location Data Template
They are available to both registered versions of CDXZipStream and demo users. All are digitally signed so they can be run in secure environments. Visual Basic for Applications (VBA) macro language provides the automation that powers the templates as described in prior blog articles. These applications are available for download at the following link.
The templates are a more efficient way to deal with calculating long lists. This is especially important when dealing with routing as this can involve significant calculation times. Copying large groups of formulas in Excel can be quite cumbersome. Excel doesn't calculate formulas linearly and can appear to be "hung" even though calculations are proceeding in the background. The templates calculate in the order your data is entered and have an indicator showing progress to completion.
For more information on the HERE API update please see our blog article and the following video.
CDXZipStream can now be configured to use postal code databases for other countries as a substitute for the default US zip code database. All of the CDXZipStream built-in functions which use the local zip code database (such as CDXZipCode, CDXDistance and CDXRadius) will be able to access this data.
We are initially supporting 19 additional countries such as Australia, Mexico, India and Western European countries such as France. These databases are free can be obtained at the following download link. They are installed using the “Update Manually” function on the CDXZipStream “Account” function in Excel. You must have CDXZipStream version 5.1 or later installed. Registered users can get access to this feature by installing the current CDXZipStream demo installation file.
The Bing and Here geocoding and routing functions are not impacted by this change and can continued to be used for worldwide location data.
For more information on this new feature please check out the following video.