| Issue Number | 3913 |
|---|---|
| Summary | Update ZIP code Table 2015Q2/Q3 |
| Created | 2015-05-26 16:43:11 |
| Issue Type | Task |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2015-06-18 11:53:32 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.161929 |
-----Original Message-----
From: sabine@zipinfo.com [mailto:sabine@zipinfo.com]
Sent: Thursday, April 30, 2015 5:29 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 - May 2015
Hi Louise,
Here is the download info for ZIPList5 Max May 2015, Enterprise License (user name and password are case sensitive):
http://data.zip-info.com/datamay/z5max/z5max.htm
User Name: KXGRWH
Password: JNJHZW
This is the last version (of four) of your 1-year subscription. For your convenience we will email you a renewal invoice soon.
If you have any questions please let me know.
We appreciate your business!
Best regards,
Sabine Chamberlain
ZipInfo.com
866-256-2042
Cust #: ARL208For May 2015 the US Postal Service added four new 5-digit ZIP codes, deleted
seven existing 5-digit ZIP codes, and renamed no 5-digit ZIP codes.
Added 09044 M APO, AE
Added 29486 Summerville, SC
Added 84009 South Jordan, UT
Added 97703 Bend, OR
Deleted 10095 New York, NY
Deleted 30219 P Glenn, GA
Deleted 33159 P Miami, FL
Deleted 36721 Annemanie, AL
Deleted 36762 Thomasville, AL
Deleted 42731 Dubre, KY
Deleted 88516 P El Paso, TX
The number of active ZIP codes is 41,735
=====================================================================
For April 2015 the US Postal Service added two new 5-digit ZIP codes, deleted
one existing 5-digit ZIP codes, and renamed three 5-digit ZIP codes.
Added 09753 M APO, AE
Added 09895 M DPO, AE
Deleted 60170 P Elgin, IL
Renamed 31037 from Helena to McRae Helena GA
Renamed 31055 from McRae to McRae Helena GA
Renamed 96515 from FPO to DPO AP
The number of active ZIP codes is 41,738
=====================================================================
For March 2015 the US Postal Service added five new 5-digit ZIP codes, deleted
no existing 5-digit ZIP codes, and renamed two 5-digit ZIP codes.
Added 09503 M FPO, AE
Added 34095 M FPO, AA
Added 34096 M FPO, AA
Added 96612 M FPO, AP
Added 96613 M FPO, AP
Renamed 79077 from Sam Norwood to Samnorwood TX
Renamed 61311 from Streator to Ancona IL
The number of active ZIP codes is 41,737
=====================================================================The new ZIP code table has been loaded on DEV and is ready for review.
Verified on DEV. Thanks!
Zip codes have been loaded to QA.
Verified on QA
Since we're not quite sure if the data for Q2 was already loaded to PROD (I don't think is has) I just went ahead and loaded the next quarterly data to both, DEV and QA.
Release Notes, August 2015
IMPORTANT CHANGES - PLEASE READ THIS
Starting with May 2015 we changed the spelling of selected city names and county names
to correct persistent USPS spelling errors:
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 county name "De Kalb" was changed to "DeKalb". This affected the states of
Alabama and Indiana.
Here is the list of ZIP codes that the US Postal Service has recently added,
deleted, or renamed:
=====================================================================
For August 2015 the US Postal Service added five new 5-digit ZIP codes, deleted
no existing 5-digit ZIP codes, and renamed one 5-digit ZIP code.
Added 34080 M FPO, AA
Added 34081 M FPO, AA
Added 34082 M FPO, AA
Added 34083 M FPO, AA
Added 34084 M FPO, AA
Renamed 01237 from Lanesboro to Lanesborough MA
The number of active ZIP codes is 41,741
=====================================================================
For July 2015 the US Postal Service added three new 5-digit ZIP codes, deleted
no existing 5-digit ZIP codes, and renamed no 5-digit ZIP codes.
Added 33191 Miami, FL
Added 33192 Miami, FL
Added 33198 Miami, FL
The number of active ZIP codes is 41,736
=====================================================================
For June 2015 the US Postal Service added no new 5-digit ZIP codes, deleted
two existing 5-digit ZIP codes, and renamed one 5-digit ZIP code.
Deleted 09002 M APO, AE
Deleted 96348 M FPO, AP
Renamed 42128 from Drake to Bowling Green, KY
The number of active ZIP codes is 41,733
=====================================================================
Please verify on QA and I'll have the data loaded to STAGE and PROD.
Verified on QA.
The data has been loaded to STAGE and PROD.
Please verify and close this ticket.
Verified on PROD. Thanks!
Elapsed: 0:00:00.001541