CDR Tickets

From: sabine@zipinfo.com [mailto:sabine@zipinfo.com] 
Sent: Sunday, April 30, 2017 5:07 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 May 2017 - ZIP code data

 

Hello Louise,

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

     http://data.zip-info.com/datamay/z5max/z5max.htm
     User Name: ZENFWG
     Password:  GAZBDB

This is the last version (of four) of your 1-year subscription. For your convenience we will email you a renewal invoice soon.

If you have any questions please let me know.

We appreciate your business!

Best regards,

Sabine Chamberlain
ZipInfo.com
866-256-2042


Cust #: ARL208

The ZIP codes have been loaded to DEV:

Success: zipcode table updated!

Log messages below:

added 2500 rows
added 5000 rows
added 7500 rows
added 10000 rows
added 12500 rows
added 15000 rows
added 17500 rows
added 20000 rows
added 22500 rows
added 25000 rows
added 27500 rows
added 30000 rows
added 32500 rows
added 35000 rows
added 37500 rows
added 40000 rows
added 42500 rows
added 45000 rows
added 47500 rows
added 50000 rows
added 52500 rows
added 55000 rows
added 57500 rows
added 60000 rows
added 62500 rows
added 65000 rows
added 67500 rows
added 70000 rows

Total number of rows loaded: 70256

Release Notes, May 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 May 2017 the US Postal Service added five new 5-digit ZIP codes, 
deleted two existing 5-digit ZIP codes, and renamed no 5-digit ZIP code.
    
    Added   09314  M  APO, AE
    Added   09317  M  APO, AE
    Added   09497  M  APO, AE
    Added   96273  M  APO, AP
    Added   96297  M  APO, AP

    Deleted 08644     Trenton, NJ
    Deleted 55574  P  Maple Plain, MN

The number of active ZIP codes is 41,701

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

For April 2017 the US Postal Service added no new 5-digit ZIP code, deleted 
8 existing 5-digit ZIP codes, and renamed 3 5-digit ZIP codes.
    
    Deleted 21280  U  Baltimore, MD
    Deleted 21288  U  Baltimore, MD
    Deleted 46296  U  Indianapolis, IN
    Deleted 62247  P  Hagarstown, IL
    Deleted 62855  P  Lancaster, IL
    Deleted 84136  U  Salt Lake City, UT
    Deleted 94209  U  Sacramento, CA
    Deleted 94286  U  Sacramento, CA

    Renamed 02127 from Boston to South Boston MA
    Renamed 02128 from Boston to East Boston MA
    Renamed 37769 from Lake City to Rocky Top TN

The number of active ZIP codes is 41,698

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

For March 2017 the US Postal Service added no new 5-digit ZIP codes, deleted 
13 existing 5-digit ZIP codes, and renamed no 5-digit ZIP code.
    
    Deleted 17012  U  Camp Hill, PA
    Deleted 46211  U  Indianapolis, IN
    Deleted 46274  U  Indianapolis, IN
    Deleted 46275  U  Indianapolis, IN
    Deleted 47261  P  Millhousen, IN
    Deleted 47439  P  Koleen, IN
    Deleted 47830  P  Bellmore, IN
    Deleted 47984  P  Talbot, IN
    Deleted 63938  P  Fagus, MO
    Deleted 80944  U  Colorado Springs, CO
    Deleted 85025     Phoenix, AZ
    Deleted 85098  U  Phoenix, AZ
    Deleted 85662  P  Nogales, AZ

The number of active ZIP codes is 41,706

~volkerI assume this is not ready for testing yet ?

The ZIP codes had been loaded to DEV and can be tested.

Verified on DEV.

The new ZIP codes have been uploaded to QA and STAGE.

Please verify on STAGE before I'll load the data to PROD.

Verified on STAGE.

The ZIP codes have been loaded to PROD.

Please verify and close this ticket.

Verified on PROD.