CDR Tickets

Issue Number 4294
Summary Update ZIP code Table 2017Q3
Created 2017-08-01 12:59:06
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2017-08-10 16:30:35
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.212229
Description

The updated data for the ZIP codes is available to be loaded.

Comment entered 2017-08-01 13:00:12 by Englisch, Volker (NIH/NCI) [C]
-----Original Message-----
From: sabine@zipinfo.com [mailto:sabine@zipinfo.com] 
Sent: Monday, July 31, 2017 6:04 PM
To: Patten, Louise (NIH/NCI) [E] <pattenl@mail.nih.gov>; NCI OCPL Program Support Services <nciocplprogramsupport@mail.nih.gov>; Englisch, Volker (NIH/NCI) [C] <volker@mail.nih.gov>
Subject: ZIPList5 Max August 2017 - ZIP code data

 

Hello Louise,

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

     http://data.zip-info.com/dataaug/z5max/z5max.htm
     User Name: LZPJGZ
     Password:  BUMVAR

This is the first 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


Cust #: ARL208
Comment entered 2017-08-01 13:06:33 by Englisch, Volker (NIH/NCI) [C]
Release Notes, August 2017

IMPORTANT CHANGES - PLEASE READ THIS

Here is the list of ZIP codes that the US Postal Service has recently added, 
deleted, or renamed:

=====================================================================

For August 2017 the US Postal Service added no new 5-digit ZIP code, deleted 
three existing 5-digit ZIP codes, and renamed no 5-digit ZIP code. 

    Deleted 55553  P  Young America, MN
    Deleted 55594  P  Young America, MN
    Deleted 60001  P  Alden, IL

The number of active ZIP codes is 41,668

=====================================================================

For July 2017 the US Postal Service added one new 5-digit ZIP code, deleted 
seven existing 5-digit ZIP codes, and renamed no 5-digit ZIP code. 

    Added   09614  M  DPO, AE

    Deleted 53778  U  Madison, WI
    Deleted 53779  U  Madison, WI
    Deleted 54182  P  Zachow, WI
    Deleted 54432  P  Galloway, WI
    Deleted 54434  P  Jump River, WI
    Deleted 54439  P  Hannibal, WI
    Deleted 60209  U  Evanston, IL

The number of active ZIP codes is 41,671

=====================================================================

For June 2017 the US Postal Service added three new 5-digit ZIP codes, deleted 
27 existing 5-digit ZIP codes, and renamed two 5-digit ZIP codes. Note that
ZIP code 94209 was removed for April 2017 and was restored for June 2017.

    Added   09800  M  APO, AE
    Added   60418     Crestwood, IL
    Added   94209  U  Sacramento, CA
    
    Deleted 46197  U  Plainfield, IN
    Deleted 46210  U  Indianapolis, IN
    Deleted 46291  U  Indianapolis, IN
    Deleted 54010  P  East Ellsworth, WI
    Deleted 54640  P  Lynxville, WI
    Deleted 54818  P  Brill, WI
    Deleted 54834  P  Edgewater, WI
    Deleted 55002  P  Almelund, MN
    Deleted 55172  P  Saint Paul, MN
    Deleted 55187  U  Saint Paul, MN
    Deleted 55188  U  Saint Paul, MN
    Deleted 55348  P  Maple Plain, MN
    Deleted 55380     Silver Creek, MN
    Deleted 55473  P  Minneapolis, MN
    Deleted 55550  P  Young America, MN
    Deleted 55570  P  Maple Plain, MN
    Deleted 55571  P  Maple Plain, MN
    Deleted 55576  P  Maple Plain, MN
    Deleted 55578  P  Maple Plain, MN
    Deleted 55579  P  Maple Plain, MN
    Deleted 55595  P  Loretto, MN
    Deleted 55596  P  Loretto, MN
    Deleted 55597  P  Loretto, MN
    Deleted 55598  P  Loretto, MN
    Deleted 56430  P  Ah Gwah Ching, MN
    Deleted 56682     Swift, MN
    Deleted 78769  P  Austin, TX
    
    Renamed 63038 from Glencoe to Wildwood MO
    Renamed 63040 from Grover to Wildwood MO

The number of active ZIP codes is 41,677

=====================================================================
#
Comment entered 2017-08-01 14:12:26 by Englisch, Volker (NIH/NCI) [C]

The updated ZIP code data for Q3 has been loaded to DEV.

Please verify.

Comment entered 2017-08-01 14:23:30 by Englisch, Volker (NIH/NCI) [C]

The ZIP codes have been loaded to QA.

Comment entered 2017-08-10 13:14:29 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV

Comment entered 2017-08-10 13:20:12 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA

Comment entered 2017-08-10 16:30:27 by Englisch, Volker (NIH/NCI) [C]

The ZIP codes have been loaded to STAGE and PROD.

Please verify on PROD and close this ticket.

Comment entered 2017-09-07 12:04:22 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Elapsed: 0:00:00.001585