CDR Tickets

Issue Number 3072
Summary Zip Code Download and Upgrade
Created 2010-02-02 10:43:51
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2010-05-05 12:56:31
Resolution Won't Fix
Path /home/bkline/backups/jira/ocecdr/issue.107400
Description

BZISSUE::4748
BZDATETIME::2010-02-02 10:43:51
BZCREATOR::Volker Englisch
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku

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

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-02-19 14:41:23 by palaniar

BZDATETIME::2010-02-19 14:41:23
BZCOMMENTOR::Ram Palaniappan
BZCOMMENT::1

I updated the new zip codes to the development server Mahler. Please QC the new changes and let me know to update it to test and live server. These are the changes for this update.

NEW THIS MONTH

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 2010-03-04 10:54:54 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-03-04 10:54:54
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(In reply to comment #1)
> I updated the new zip codes to the development server Mahler. Please QC the new
> changes and let me know to update it to test and live server.

Tested on Mahler. Please promote to Bach.

Comment entered 2010-04-29 18:27:34 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-04-29 18:27:34
BZCOMMENTOR::Volker Englisch
BZCOMMENT::3

Since Ram is not available I will copy the data.

I also changed the QC from Lakshmi to William.

Comment entered 2010-05-05 12:56:08 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-05-05 12:56:08
BZCOMMENTOR::Volker Englisch
BZCOMMENT::4

We received the new ZIP code data before Ram was able to replace the update for last quarter. I will perform the new ZIP code update (OCECDR-3137) and delete this issue since the new data supersedes the data listed in this issue.

Comment entered 2010-05-05 12:56:31 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-05-05 12:56:31
BZCOMMENTOR::Volker Englisch
BZCOMMENT::5

Closing issue.

Elapsed: 0:00:00.001338