| Issue Number | 3343 |
|---|---|
| Summary | Zip Code Download and Upgrade |
| Created | 2011-04-26 16:31:05 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2011-10-31 12:26:12 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107671 |
BZISSUE::5036
BZDATETIME::2011-04-26 16:31:05
BZCREATOR::Volker Englisch
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku
+++ This bug was initially created as a clone of OCECDR-3137 +++
The last time we updated the ZIP5 data John had downloaded to the
network at
imbncipf01\software$\ziplist5\z5max.zip
Mauricio found the information to continue with the updates and our license is active until April. I'll try to retrieve the latest data and update the CDR.
BZDATETIME::2011-04-26 17:47:06
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1
The updated ZIP data has been loaded to MAHLER and is ready for testing.
William, this is the information from the ZIP5 documentation:
For February 2011 the US Postal Service added 3 new 5-digit ZIP
codes, deleted
17 existing 5-digit ZIP codes, and renamed no existing 5-digit ZIP
code.
Added 09846 M DPO, AE
Added 20417 U Washington, DC
Added 33106 Miami, FL
Deleted 09080 M APO, AE
Deleted 12593 P West Copake, NY
Deleted 27564 P Creedmoor, NC
Deleted 33900 Fort Myers, FL
Deleted 42283 P South Union, KY
Deleted 52319 P Oakdale, IA
Deleted 77246 P Houston, TX
Deleted 77247 P Houston, TX
Deleted 77250 P Houston, TX
Deleted 77260 P Houston, TX
Deleted 77276 P Houston, TX
Deleted 77278 P Houston, TX
Deleted 77285 P Houston, TX
Deleted 77286 P Houston, TX
Deleted 77294 P Houston, TX
Deleted 77296 P Houston, TX
Deleted 94101 P San Francisco, CA
BZDATETIME::2011-05-09 11:40:48
BZCOMMENTOR::Volker Englisch
BZCOMMENT::2
Mauricio received the latest (2011-May) data from ZipInfo.
I've downloaded, extracted and loaded the updated ZIP information on MAHLER.
For May 2011 the US Postal Service added 1 new 5-digit ZIP code,
deleted
24 existing 5-digit ZIP codes, and renamed 3 existing 5-digit ZIP
codes.
Added 09367 M APO, AE
Deleted 07309 P Jersey City, NJ
Deleted 09456 M APO, AE
Deleted 09819 M APO, AE
Deleted 11240 P Brooklyn, NY
Deleted 30913 P Augusta, GA
Deleted 36210 P Anniston, AL
Deleted 40931 P Eriline, KY
Deleted 44393 U Akron, OH
Deleted 44399 U Akron, OH
Deleted 52350 P Viola, IA
Deleted 70140 New Orleans, LA
Deleted 70500 Lafayette, LA
Deleted 70595 P Lafayette, LA
Deleted 75245 P Dallas, TX
Deleted 75310 U Dallas, TX
Deleted 84144 Salt Lake City, UT
Deleted 92194 P San Diego, CA
Deleted 92292 P Palm Springs, CA
Deleted 98054 P Redondo, WA
Deleted 98171 P Seattle, WA
Deleted 98184 U Seattle, WA
Deleted 98442 P Tacoma, WA
Deleted 98492 P Lakewood, WA
Deleted 98929 Goose Prairie, WA
Renamed 09607 from APO to FPO AE
Renamed 90201 from Bell to Bell Gardens CA
Renamed 90202 from Bell Gardens to Bell CA
BZDATETIME::2011-05-09 12:52:31
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3
(In reply to comment #2)
> Mauricio received the latest (2011-May) data from ZipInfo.
>
> I've downloaded, extracted and loaded the updated ZIP information
on MAHLER.
>
> For May 2011 the US Postal Service added 1 new 5-digit ZIP code,
deleted
> 24 existing 5-digit ZIP codes, and renamed 3 existing 5-digit ZIP
codes.
>
Verified on Mahler. Please promote to Bach.
BZDATETIME::2011-05-10 11:07:05
BZCOMMENTOR::Volker Englisch
BZCOMMENT::4
The new ZIP code data has been loaded to FRANCK and BACH.
Please verify on BACH and close this bug.
BZDATETIME::2011-05-12 09:01:26
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5
(In reply to comment #4)
> The new ZIP code data has been loaded to FRANCK and BACH.
>
> Please verify on BACH and close this bug.
Verified on Bach. Issue Closed.
Elapsed: 0:00:00.000622