CDR Tickets

Issue Number 3010
Summary Zip Code Download and Upgrade
Created 2009-11-02 18:00:05
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To palaniar
Status Closed
Resolved 2010-02-02 10:43:51
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107338
Description

BZISSUE::4686
BZDATETIME::2009-11-02 18:00:05
BZCREATOR::Volker Englisch
BZASSIGNEE::Ram Palaniappan
BZQACONTACT::William Osei-Poku

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

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 2009-11-03 21:06:27 by palaniar

BZDATETIME::2009-11-03 21:06:27
BZCOMMENTOR::Ram Palaniappan
BZCOMMENT::1

I updated the new zip codes to the test server MAHLER. I attached the changes. Please QC the new data and let me know to update on live servers.

For November 2009 the US Postal Service added four new 5-digit ZIP codes,
deleted five existing 5-digit ZIP codes, and renamed one existing 5-digit
ZIP code:

Added 09820 M DPO, AE
Added 21261 U Baltimore, MD
Added 85096 U Phoenix, AZ
Added 86555 Douglas, AZ

Deleted 11708 P Amityville, NY
Deleted 11750 U Huntington Station, NY
Deleted 34076 M APO, AA
Deleted 64172 P Kansas City, MO
Deleted 86330 P Iron Springs, AZ

Renamed 07732 from Fort Hancock to Highlands NJ

OTHER RECENT CHANGES

For October 2009 the US Postal Service added five new 5-digit ZIP codes,
deleted 14 existing 5-digit ZIP codes, and renamed one existing 5-digit
ZIP code:

Added 09380 M APO, AE
Added 09382 M APO, AE
Added 09383 M APO, AE
Added 09762 M DPO, AE
Added 17335 U Hanover, PA

Deleted 09036 M APO, AE
Deleted 09110 M APO, AE
Deleted 09175 M APO, AE
Deleted 09185 M APO, AE
Deleted 09212 M APO, AE
Deleted 09262 M APO, AE
Deleted 09370 M FPO, AE
Deleted 15740 P Frostburg, PA
Deleted 25926 P Sprague, WV
Deleted 44322 Akron, OH
Deleted 57194 U Sioux Falls, SD
Deleted 57196 U Sioux Falls, SD
Deleted 79320 Bula, TX
Deleted 96313 M FPO, AP

Renamed 07732 from Highlands to Fort Hancock NJ

For September 2009 the US Postal Service added two new 5-digit ZIP codes,
deleted one existing 5-digit ZIP code, and renamed two existing 5-digit
ZIP codes:

Added 09798 M APO, AE
Added 56950 U Parcel Return Service, DC

Deleted 26461 P Wilsonburg, WV

Renamed 85140 from Queen Creek to San Tan Valley, AZ
Renamed 85143 from Queen Creek to San Tan Valley, AZ

Comment entered 2009-11-16 12:43:24 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2009-11-16 12:43:24
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(In reply to comment #1)
> I updated the new zip codes to the test server MAHLER. I attached the changes.
> Please QC the new data and let me know to update on live servers.
>
Verified on Mahler. Please promote to Bach and Franck.

Comment entered 2009-12-10 10:57:43 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2009-12-10 10:57:43
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

(In reply to comment #2)
> (In reply to comment #1)
> > I updated the new zip codes to the test server MAHLER. I attached the changes.
> > Please QC the new data and let me know to update on live servers.
> >
> Verified on Mahler. Please promote to Bach and Franck.

I can see this change on Bach. Is it OK to go ahead and close this issue?

Comment entered 2009-12-10 11:23:00 by palaniar

BZDATETIME::2009-12-10 11:23:00
BZCOMMENTOR::Ram Palaniappan
BZCOMMENT::4

The new zipcode data has been updated on Live (BACH) and test(Franck) servers.

Comment entered 2009-12-10 11:56:39 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2009-12-10 11:56:39
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5

(In reply to comment #4)
> The new zipcode data has been updated on Live (BACH) and test(Franck) servers.

Verified on Bach. Issue Closed. Thanks!

Elapsed: 0:00:00.001439