CDR Tickets

-----Original Message-----
From: sabine@zipinfo.com [mailto:sabine@zipinfo.com] 
Sent: Thursday, August 31, 2017 8:54 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 September 2017 - ZIP code data

 

Hello Louise,

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

     http://data.zip-info.com/datasep/z5max/z5max.htm
     User Name: DKUHFY
     Password:  LMNBMM

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

Adding ~oseipokuw as a watcher.

The data has been updated on QA. I'm having difficulties loading on DEV at the moment.

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: 70237

Release Notes

Release Notes, September 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 September 2017 the US Postal Service added no new 5-digit ZIP code, deleted 
six existing 5-digit ZIP codes, and renamed one 5-digit ZIP code. 

    Deleted 41065  P  Muses Mills, KY
    Deleted 54934  P  Eureka, WI
    Deleted 62435  P  Janesville, IL
    Deleted 62971  P  Oraville, IL
    Deleted 63464     Plevna, MO
    Deleted 66759  P  New Albany, KS

    Renamed 62667 from Modesto to Scottville IL

The number of active ZIP codes is 41,662

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

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

=====================================================================
#

Please verify the updated data on QA.

Verified on QA. Thanks!

The data has been loaded to STAGE and PROD.

Please verify on PROD and close this ticket.

Verified on PROD. Thanks!