CDR Tickets

Issue Number 3383
Summary Zip Code Download and Upgrade
Created 2011-07-01 16:12:54
Issue Type Improvement
Submitted By priced
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2011-08-23 14:42:52
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107711
Description

BZISSUE::5076
BZDATETIME::2011-07-01 16:12:54
BZCREATOR::Admin (VEnglisch)
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku

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

We received a new notification that the ZIP5 data is ready for download:

Download Instructions
Web Page: http://data.zip-info.com/datajul/z5max/z5max.htm
User Name: TKDNCA
Password: TSNFSG

Note: the user name and password must be entered IN ALL CAPS!

Comment entered 2011-07-01 18:10:21 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-07-01 18:10:21
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1

The new ZIP code data has been loaded.

This is ready for review on MAHLER.

Here are a few of the ZIP codes that have changed:

For July 2011 the US Postal Service added 5 new 5-digit ZIP codes, deleted
4 existing 5-digit ZIP codes, and renamed 0 existing 5-digit ZIP codes.

Added 09771 M APO, AE
Added 09862 M APO, AE
Added 75033 Frisco, TX
Added 84129 Salt Lake City, UT
Added 99623 Wasilla, AK

Deleted 02031 P East Mansfield, MA
Deleted 02636 P Centerville, MA
Deleted 02854 P North Kingstown, RI
Deleted 75037 U Irving, TX

The number of active ZIP codes is 41,926

OTHER RECENT CHANGES

For June 2011 the US Postal Service added 1 new 5-digit ZIP code, deleted
9 existing 5-digit ZIP codes, and renamed 0 existing 5-digit ZIP codes.

Added 09611 M APO, AE

Deleted 09402 M FPO, AE
Deleted 21260 Baltimore, MD
Deleted 21261 Baltimore, MD
Deleted 30347 P Atlanta, GA
Deleted 49069 U Marshall, MI
Deleted 63190 U Saint Louis, MO
Deleted 78474 Corpus Christi, TX
Deleted 85096 U Phoenix, AZ
Deleted 91797 U Pomona, CA

The number of active ZIP codes is 41,925

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

The number of active ZIP codes is 41,933

Comment entered 2011-08-02 14:00:09 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-08-02 14:00:09
BZCOMMENTOR::Volker Englisch
BZCOMMENT::2

We received a new update from ZIP5. I've loaded it to MAHLER.

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

Added 22350 U Alexandria, VA

Deleted 17738 Hyner, PA
Deleted 21265 U Baltimore, MD
Deleted 30376 P Atlanta, GA
Deleted 30379 P Atlanta, GA
Deleted 30390 U Atlanta, GA
Deleted 48863 P Oak Grove, MI
Deleted 62805 P Akin, IL

Renamed 28308 from Pope AFB to Pope Army Airfield NC
Renamed 30544 from Demorest to Habersham GA

The number of active ZIP codes is 41,920

This is ready for review on MAHLER.

Comment entered 2011-08-11 11:20:44 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-11 11:20:44
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

(In reply to comment #2)
> We received a new update from ZIP5. I've loaded it to MAHLER.
>
> For August 2011 the US Postal Service added 1 new 5-digit ZIP code, deleted
> 7 existing 5-digit ZIP codes, and renamed 2 existing 5-digit ZIP codes.
>
> Added 22350 U Alexandria, VA
>
> Deleted 17738 Hyner, PA
> Deleted 21265 U Baltimore, MD
> Deleted 30376 P Atlanta, GA
> Deleted 30379 P Atlanta, GA
> Deleted 30390 U Atlanta, GA
> Deleted 48863 P Oak Grove, MI
> Deleted 62805 P Akin, IL
>
> Renamed 28308 from Pope AFB to Pope Army Airfield NC
> Renamed 30544 from Demorest to Habersham GA
>
> The number of active ZIP codes is 41,920
>
> This is ready for review on MAHLER.

Verified on Mahler. Please promote to Bach.

Comment entered 2011-08-11 17:16:49 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-08-11 17:16:49
BZCOMMENTOR::Volker Englisch
BZCOMMENT::4

The new ZIP codes have been imported on FRANCK and BACH.

Please verify on BACH and close this bug.

Comment entered 2011-08-23 14:42:52 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-23 14:42:52
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5

(In reply to comment #4)
> The new ZIP codes have been imported on FRANCK and BACH.
>
> Please verify on BACH and close this bug.

Verified on Bach. Issue closed.

Elapsed: 0:00:00.001865