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





Welcome to the CDXZipStream April 2013 Newsletter


Does bad address data ever cost you time and money?  This month we cover CDXStreamer's address correction feature that applies U.S. Postal Service formatting and the "one component failure rule" for correcting misspellings, and fixing incorrect or missing street, city, state and ZIP data.


Also covered are some CDXZipStream tips and tricks:  using latitude and longitude instead of addresses, and returning a list of all ZIP codes in the U.S.   


Here's also a look at our latest blog articles:



Address Correction with CDXStreamer


Mailbox ImageOne of the most useful features of our new web-based Excel add-in, CDXStreamer, is its ability to automatically correct address information.  Not only will it apply USPS standard abbreviations and formatting, but it will correct misspellings as well as missing or incorrect city, state, and ZIP code data.  It also automatically looks up ZIP+4 codes.  The address correction feature of CDXStreamer can virtually eliminate undeliverable addresses and greatly reduce the costs associated with bad address data.  


Here are some examples of address correction by CDXStreamer:


91 Gurnet Road, Brunswick, Maine (Missing ZIP code)
Correction - 91 GURNET RD, BRUNSWICK, ME 04011-9328


41 Sherman Road, St. Johnsbury, VT 05819 (Incorrect street suffix)
Correction - 41 SHERMAN DR, SAINT JOHNSBURY, VT 05819-9280


46 Cheltingham Ave., Schenectady, New York 12308 (Incorrect ZIP code)
Correction - 46 CHELTINGHAM AVE, SCHENECTADY, NY 12306-5106


200 MacIntyre Road, Pittsburgh, NJ 15237 (Street name misspelled)
Correction - 200 MCINTYRE RD, PITTSBURGH, PA 15237-4035


202 Kings Highway West, Haddonfield, NJ 08033 (Incorrect directional)
Correction - 202 KINGS HWY E, HADDONFIELD, NJ 08033-1905


320 W Ottawa St., Lansing, MN 48922 (Incorrect state abbreviation)
Correction - 320 W OTTAWA ST, LANSING, MI 48933-1590


3810 Forbes Ave., Philadelphia, Pennsylvania 15260 (Incorrect city)
Correction - 3810 FORBES AVE, PITTSBURGH, PA 15260-6995


Street address correction in CDXStreamer follows the U.S. Postal Service "one component failure rule" to find a correct address match.  If not more than one address component mismatch exists, then a correct address can be returned.   For instance, if there is not an exact match within the city, the one component failure rule is applied within the input ZIP code. If there is still no match, the rule is applied to all addresses within the postal finance number, and is only considered invalid if there is no match within that.


CDXStreamer is available as a free 7-day trialPricing is on a per month basis.  For a short tutorial, please view the YouTube video:  Address Correction and ZIP+4 Analysis in Excel.

CDXZipStream Tips and Tricks


TIP:  The CDXZipStream functions CDXLocateMP and CDXRouteMP use Microsoft MapPoint for address and route analysis, but you are not limited to using traditional addresses as the input for these functions.  A great alternative approach is to use latitude and longitude coordinates, which may be readily available if you work with a GPS, and also have the added advantage of being a very exacting way to define a location.  (Traditional addresses, e.g. 123 Main Street, Springfield, CO, are much more prone to mistakes and misspellings.)  So instead of a one-line address, just use the format (with a vertical bar delimiter) "latitude|longitude", such as "39.943963|-75.441742".  For CDXLocateMP, you can also input the latitude in place of street data, and longitude in place of city data, for a multi-line address.


Here's an easy way to look up a point of latitude and longitude.  Input the address into Google maps, and when the map opens right-click on the location pushpin.  Select "What's here?" and latitude and longitude will be displayed in the Google search box at the top of your screen.  You can also right-click anywhere on the map and repeat the process for any point without a pushpin.


TRICK:  This question comes up a lot with our clients - how can I get a list of all zip codes in the U.S.? Using CDXZipStream Lite, Basic, or Premium versions, select any valid zip code and use the right-click function CDXRadius to find all the zip codes within a 25,000 mile radius.  You will need to specify a maximum number of rows of 50,000.  Here's an example:


Find all U.S. ZIP codes 


All the ZIP codes within 25,000 miles of the target ZIP are returned to the worksheet, which is effectively all of them.  If you purchased the Canadian database, do not include Canadian postal codes in this analysis as there are too many to return to the worksheet.  You should expect to get back about 42,000 U.S. ZIP codes.  Note that the ZIP codes are returned here as part of an Excel array. To work with individual values or portions of the data, copy and then paste the contents of the array as values. 


Latest Data Updates


Canadian and U.S. data feeds were updated as of March 12.  There were 6,493 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 

April 2013



Map of the World


In This Issue

Address Correction with CDXStreamer


CDXZipStream Tips and Tricks


 Latest Data Updates







Join Our Mailing List



Safe Unsubscribe

Constant Contact Logo

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