CDR Tickets

Issue Number 3137
Summary Zip Code Download and Upgrade
Created 2010-05-05 12:52:42
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2010-05-17 14:15:52
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107465
Description

BZISSUE::4820
BZDATETIME::2010-05-05 12:52:42
BZCREATOR::Volker Englisch
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku

+++ This bug was initially created as a clone of OCECDR-3072 +++

The new ZIP code data is available. John has the data downloaded to the network.
We want to upgrade our information in the CDR with this data set.
The new data is in

imbncipf01\software$\ziplist5\z5max.zip

Please follow the documentation for processing the ZIP code data.

Comment entered 2010-05-05 15:04:36 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-05-05 15:04:36
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1

The ZIP code data has been loaded to MAHLER. Please verify.

Here is the information provided with the data on what codes have changed:

For May 2010 the US Postal Service added one new 5-digit ZIP code, deleted
12 existing 5-digit ZIP codes, and renamed four existing 5-digit ZIP codes:

Added 34066 M APO, AA

Deleted 24044 U Roanoke, VA
Deleted 24045 U Roanoke, VA
Deleted 24048 U Roanoke, VA
Deleted 24512 U Lynchburg, VA
Deleted 24544 U Danville, VA
Deleted 25429 U Martinsburg, WV
Deleted 33439 Bryant, FL
Deleted 80028 U Louisville, CO
Deleted 80940 U Colorado Springs, CO
Deleted 93784 U Fresno, CA
Deleted 96220 M APO, AP
Deleted 96259 M FPO, AP

Renamed 24739 from Oakvale to Princeton WV
Renamed 25071 from Elkview to Frame WV
Renamed 99505 from Fort Richardson to JBER AK
Renamed 99506 from Elmendorf AFB to JBER AK

The number of active ZIP codes is 42078.

Comment entered 2010-05-13 11:00:07 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-05-13 11:00:07
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(In reply to comment #1)
> The ZIP code data has been loaded to MAHLER. Please verify.
>
Verified on Mahler. Please promote to Bach.

Comment entered 2010-05-13 18:16:01 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-05-13 18:16:01
BZCOMMENTOR::Volker Englisch
BZCOMMENT::3

The new ZIP codes have been loaded to BACH.

Please verify and close this bug.

Comment entered 2010-05-17 14:15:52 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-05-17 14:15:52
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4

(In reply to comment #3)
> The new ZIP codes have been loaded to BACH.
>
> Please verify and close this bug.

Verified. Issue Closed. Thanks!

Elapsed: 0:00:00.001887