CDR Tickets

-----Original Message-----
From: sabine@zipinfo.com [mailto:sabine@zipinfo.com] 
Sent: Saturday, April 30, 2016 6:37 PM
To: Patten, Louise (NIH/NCI) [E]; NCI OCPL Program Support Services; Englisch, Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NIDDK) [E]
Subject: ZIPList5 Max - May 2016 ZIP code data

Hello Louise,

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

     http://data.zip-info.com/datamay/z5max/z5max.htm
     User Name: GGAWWP
     Password:  KTLCUE

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 new data has been updated on DEV and QA using our new web-tool.

Release Notes, May 2016

IMPORTANT CHANGES - PLEASE READ THIS


County Name Changes

Bedford City VA gave up its city charter in Virginia, and is now an 
incorporated town in Bedford County VA. Bedford City was removed from 
the list of Virginia counties.

Wade Hampton County AK changed its name to Kusilvak County AK. The 
County FIPS code changed from 02270 to 02158.

Shannon County SD changed its name to Oglala Lakota County SD. 
The County FIPS code changed from 46113 to 46102.


City/County Name Spelling Corrections

Starting with May 2015 we began changing the spelling of selected 
city and county names to correct persistent USPS spelling discrepancies:

City names starting with "Mc " were changed to "Mc" (removing the blank). This 
change affected city names in many states.

Example: Mc Murray PA was changed to McMurray PA

The city and county name "De Kalb" was changed to "DeKalb". This affected the 
states of Alabama and Indiana.

The county and city name "De Witt" was changed to "DeWitt" in several states.

Starting with the February 2015 release we ended support for Access 2000. We 
now offer our databases in these formats:

CSV (quote-delimited, comma-separated ASCII text)
Access 2002-2003
Access 2007-2010-2013
Excel 2007-2010-2013
Paradox 9
dBase/Visual FoxPro IV


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

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

For May 2016 the US Postal Service added six new 5-digit ZIP codes, deleted 
seven existing 5-digit ZIP codes, and renamed no 5-digit ZIP code.

    Added   09789  M  APO, AE
    Added   87547     White Rock, NM
    Added   97250     Portland, OR
    Added   97252     Portland, OR
    Added   97253     Portland, OR
    Added   97254     Portland, OR

    Deleted 02228  P  East Boston, MA
    Deleted 10257  U  New York, NY
    Deleted 10292  U  New York, NY
    Deleted 11854  U  Hicksville, NY
    Deleted 35485  P  Tuscaloosa, AL
    Deleted 36515     Carlton, AL
    Deleted 78049     Laredo, TX

    Renamed 12727 from Cochecton Center to Cochecton NY
    Renamed 85097 from Phoenix to New River AZ

The number of active ZIP codes decreased to 41,721

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

For April 2016 the US Postal Service added two new 5-digit ZIP codes, deleted 
two existing 5-digit ZIP codes, and renamed no 5-digit ZIP code.

    Added   09161  M  APO, AE
    Added   96649  M  FPO, AP

    Deleted 38147  U  Memphis, TN
    Deleted 40446  U  Lancaster, KY

The number of active ZIP codes remains 41,722

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

For March 2016 the US Postal Service added six new 5-digit ZIP codes, deleted 
no existing 5-digit ZIP codes, and renamed one 5-digit ZIP code.

    Added   09160  M  DPO, AE
    Added   09758  M  APO, AE
    Added   09844  M  DPO, AE
    Added   95214  U  Stockton, CA
    Added   96504  M  DPO, AP
    Added   96505  M  DPO, AP

    Renamed 96599 from FPO to APO AP

The number of active ZIP codes is 41,722

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

The ZIP code data has been loaded to STAGE.

Sorry, ~oseipokuw, I wasn't aware that you were not a watcher on this ticket.

Verified on STAGE. Looks good.

The data has been loaded to PROD using our new web interface.

Please verify on PROD and close this ticket.

Verified on PROD. Thanks!