CDR Tickets

Issue Number 3581
Summary Zip Code Download and Upgrade
Created 2013-02-04 15:11:47
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2013-05-02 11:43:48
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107909
Description

BZISSUE::5279
BZDATETIME::2013-02-04 15:11:47
BZCREATOR::Volker Englisch
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku

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

We received the notification that our updated ZIP data is ready for download:

---Original Message---
From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Friday, February 01, 2013 9:27 AM
To: NCI OCE Admin Services; Englisch, Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NCI) [C]
Subject: ZIPList5 Max February 2013 - Download info

Hi Iris,

Here is the download info for ZIPList5 Max February 2013, Enterprise
License (user name and password are case sensitive):

http://data.zip-info.com/datafeb/z5max/z5max.htm
User Name: BQUKNM
Password: NTZBPC

This is the third version (of four) of your 1-year subscription.

If you have any questions please let me know.

We appreciate your business.

Best regards,

Sabine Chamberlain
ZipInfo.com
866-256-2042

ARL208

Comment entered 2013-02-12 10:53:38 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2013-02-12 10:53:38
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1

The set of new ZIP codes has been replaced on MAHLER.
Please go ahead and review the changes on MAHLER.

Below are the changes for the past three months.

------------------------------------------------------------------------

For February 2013 the US Postal Service added 2 new 5-digit ZIP codes, deleted
5 existing 5-digit ZIP codes, and renamed no 5-digit ZIP code.

Added 68544 U Lincoln, NE
Added 72255 U Little Rock, AR

Deleted 29318 Boiling Springs, SC
Deleted 30300 Atlanta, GA
Deleted 63963 Shook, MO
Deleted 65701 Mc Clurg, MO
Deleted 65776 South Fork, MO

The number of active ZIP codes is 41,813

OTHER RECENT CHANGES

For January 2013 the US Postal Service added 1 new 5-digit ZIP code, deleted
2 existing 5-digit ZIP codes, and renamed 1 5-digit ZIP code.

Added 30300 Atlanta, GA

Deleted 34006 M APO, AA
Deleted 96262 M APO, AP

Renamed 96384 from APO to FPO, AP

The number of active ZIP codes is 41,816

For December 2012 the US Postal Service added 3 new 5-digit ZIP codes, deleted
5 existing 5-digit ZIP codes, and renamed 1 5-digit ZIP code.

Added 09304 M APO, AE
Added 09725 M APO, AE
Added 64162 U Kansas City, MO

Deleted 09384 M APO, AE
Deleted 30330 U Atlanta, GA
Deleted 91795 U Walnut, CA
Deleted 92725 U Santa Ana, CA
Deleted 96612 M FPO, AP

Renamed 65645 from Eudora to Morrisville, MO

The number of active ZIP codes is 41,817

Comment entered 2013-02-12 10:54:35 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2013-02-12 10:54:35
BZCOMMENTOR::Volker Englisch
BZCOMMENT::2

Changed the QA to William.

Comment entered 2013-03-11 09:44:06 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-03-11 09:44:06
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

(In reply to comment #1)
> The set of new ZIP codes has been replaced on MAHLER.
> Please go ahead and review the changes on MAHLER.
>
Verified on Mahler. Please promote to Bach.

Comment entered 2013-03-13 13:05:17 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2013-03-13 13:05:17
BZCOMMENTOR::Volker Englisch
BZCOMMENT::4

The ZIP code table has been updated on FRANCK and BACH.

Please verify on BACH and close this bug.

Comment entered 2013-03-28 10:35:08 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-03-28 10:35:08
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5

(In reply to comment #4)
> The ZIP code table has been updated on FRANCK and BACH.
>
> Please verify on BACH and close this bug.

> Added 30300 Atlanta, GA

This one is coming up with a validation error when it shouldn't be.

Comment entered 2013-03-28 10:37:19 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2013-03-28 10:37:19
BZCOMMENTOR::Volker Englisch
BZCOMMENT::6

Is it coming up with a validation error only on BACH or on FRANCK and MAHLER as well?

Comment entered 2013-03-28 11:00:44 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-03-28 11:00:44
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7

(In reply to comment #6)
> Is it coming up with a validation error only on BACH or on FRANCK and MAHLER as
> well?

The validation error is also on Mahler.

Comment entered 2013-03-28 11:05:59 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2013-03-28 11:05:59
BZCOMMENTOR::Volker Englisch
BZCOMMENT::8

If the validation error is also on MAHLER then it's possible that the documentation provided to us or the data is incorrect but it seems the data was copied correctly to BACH.

We will need to research this with the USPS and/or the ZipInfo people.
Please adjust the priority if this needs to be handled prior to the migration efforts.

Comment entered 2013-04-04 17:46:05 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2013-04-04 17:46:05
BZCOMMENTOR::Volker Englisch
BZCOMMENT::9

> Added 30300 Atlanta, GA

This record is not in the database and cannot be validated. It was either a typo in the instructions or missed to be added to the data.

There's nothing else for me to do. Closing issue.

Elapsed: 0:00:00.001773