| Issue Number | 4039 |
|---|---|
| Summary | Update ZIP code Table 2016Q1 |
| Created | 2016-03-03 16:56:02 |
| Issue Type | Task |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2016-03-22 15:35:55 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.180142 |
---Original Message
From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Sunday, January 31, 2016 3:56 PM
To: Patten, Louise (NIH/NCI) [E]; NCI OCPL Program Support Services;
Englisch, Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NCI) [C]
Subject: ZIPList5 Max - February 2016 ZIP code data
Hello Louise,
Here is the download info for ZIPList5 Max February 2016, Enterprise License (user name and password are case sensitive):
http://data.zip-info.com/datafeb/z5max/z5max.htm
User Name: SBNJMG
Password: QJRJDE
This is the third version (of four) of your 1-year subscription.
If you have any questions please let me know.
We appreciate your business!
Best regards,
Sabine Chamberlain
ZipInfo.com
866-256-2042
Cust #: ARL208
A new update of the ZIP codes had been provided. I will use this data for testing the new load process.
The data has been loaded to DEV.
Here are the release notes needed to test the changes:
Release Notes, February 2016
IMPORTANT CHANGES - PLEASE READ THIS
County Name Changes
Bedford City VA gave up its city charter in Virginia, and is now an
incorporated town in Bedford County VA. Bedford City was removed from
the list of Virginia counties.
Wade Hampton County AK changed its name to Kusilvak County AK. The
County FIPS code changed from 02270 to 02158.
Shannon County SD changed its name to Oglala Lakota County SD.
The County FIPS code changed from 46113 to 46102.
City/County Name Spelling Corrections
Starting with May 2015 we began changing the spelling of selected
city and county names to correct persistent USPS spelling discrepancies:
City names starting with "Mc " were changed to "Mc" (removing the blank). This
change affected city names in many states.
Example: Mc Murray PA was changed to McMurray PA
The city and county name "De Kalb" was changed to "DeKalb". This affected the
states of Alabama and Indiana.
The county and city name "De Witt" was changed to "DeWitt" in several states.
\
Starting with the February 2015 release we ended support for Access 2000. We
now offer our databases in these formats:
CSV (quote-delimited, comma-separated text)
Access 2002-2003
Access 2007-2020-2013
Excel 2007-2010-2013
Paradox 9
dBase/Visual FoxPro IV
Here is the list of ZIP codes that the US Postal Service has recently added,
deleted, or renamed:
=====================================================================
For February 2016 the US Postal Service added no new 5-digit ZIP codes, deleted
no existing 5-digit ZIP codes, and renamed one 5-digit ZIP code.
Renamed 09880 from APO to DPO AE
The number of active ZIP codes is 41,716
=====================================================================
For January 2016 the US Postal Service added three new 5-digit ZIP codes, deleted
four existing 5-digit ZIP codes, and renamed no 5-digit ZIP codes.
Added 09313 M FPO, AE
Added 09381 M APO, AE
Added 09550 M FPO, AE
Deleted 09369 M FPO, AE
Deleted 09496 M APO, AE
Deleted 09713 M APO, AE
Deleted 96503 M FPO, AP
The number of active ZIP codes is 41,716
=====================================================================
For December 2015 the US Postal Service added four new 5-digit ZIP codes, deleted
1 existing 5-digit ZIP code, and renamed no 5-digit ZIP code.
Added 09125 M APO, AE
Added 09600 M APO, AE
Added 09709 M DPO, AE
Added 09851 M APO, AE
Deleted 76505 P Temple, TX
The number of active ZIP codes is 41,717
=====================================================================
The ZIP code data has been loaded to QA.
Verified on QA. Thanks!
Q2 has already been loaded.
Closing ticket.
Elapsed: 0:00:00.001497