CDR Tickets

Issue Number 3870
Summary Update ZIP code Table 2015Q1
Created 2015-02-02 12:45:31
Issue Type Task
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2015-02-02 12:55:36
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.146201
Description
-----Original Message-----
From: sabine@zipinfo.com [mailto:sabine@zipinfo.com] 
Sent: Saturday, January 31, 2015 3:15 PM
To: Patten, Louise (NIH/NCI) [E]; NCI OCPL Admin Services; Englisch, Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NCI) [C]
Subject: ZIPList5 Max - February 2015

Hi Louise,

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

     http://data.zip-info.com/datafeb/z5max/z5max.htm
     User Name: QNFRCW
     Password:  NMLHVJ

This is the third 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 2015-02-02 12:54:30 by Englisch, Volker (NIH/NCI) [C]

These are the changes according to the Release Notes:
-----------------------------------------------------------------------
Release Notes, February 2015

IMPORTANT CHANGE - PLEASE READ THIS

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

CSV (text)
Access 2002-2003
Access 2007-2020-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 February 2015 the US Postal Service added 1 new 5-digit ZIP code, deleted
27 existing 5-digit ZIP codes, and renamed no 5-digit ZIP codes.

Added 09843 M APO, AE

Deleted 01477 P Winchendon Springs, MA
Deleted 01517 P East Princeton, MA
Deleted 02565 P Silver Beach, MA
Deleted 02573 P West Chop, MA
Deleted 03274 P Stinson Lake, NH
Deleted 06650 Bridgeport, CT
Deleted 17767 P Salona, PA
Deleted 17839 P Lightstreet, PA
Deleted 18010 P Ackermanville, PA
Deleted 18050 P Flicksville, PA
Deleted 18373 P Unity House, PA
Deleted 19542 P Monocacy Station, PA
Deleted 20023 P Washington, DC
Deleted 20088 P Washington, DC
Deleted 20097 U Washington, DC
Deleted 20098 U Washington, DC
Deleted 20558 U Washington, DC
Deleted 29430 P Bethera, SC
Deleted 44488 U Warren, OH
Deleted 66019 P Clearview City, KS
Deleted 77709 P Beaumont, TX
Deleted 80295 Denver, CO
Deleted 80943 U Colorado Springs, CO
Deleted 80945 U Colorado Springs, CO
Deleted 81247 Gunnison, CO
Deleted 98132 Seattle, WA
Deleted 98189 U Seattle, WA

The number of active ZIP codes is 41,732

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

For January 2015 the US Postal Service added 15 new 5-digit ZIP codes, deleted
one existing 5-digit ZIP code, and renamed three 5-digit ZIP codes.

Added 08644 Trenton, NJ
Added 09508 M FPO, AE
Added 09509 M FPO, AE
Added 09511 M FPO, AE
Added 09583 M FPO, AE
Added 09592 M FPO, AE
Added 09596 M FPO, AE
Added 27268 High Point, NC
Added 60569 U Aurora, IL
Added 96691 M FPO, AP
Added 96692 M FPO, AP
Added 96693 M FPO, AP
Added 96694 M FPO, AP
Added 96695 M FPO, AP
Added 96696 M FPO, AP

Deleted 07709 U Red Bank, NJ

Renamed 08640 from Fort Dix to Joint Base MDL NJ
Renamed 08641 from Trenton to Joint Base MDL NJ
Renamed 55311 from Osseo to Maple Grove MN

The number of active ZIP codes is 41,758

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

For December 2014 the US Postal Service added three new 5-digit ZIP codes, deleted
one existing 5-digit ZIP code, and renamed four 5-digit ZIP codes.

Added 09316 M APO, AE
Added 09319 M APO, AE
Added 09847 M APO, AE

Deleted 09310 M APO, AE

Renamed 27031 from White Plains to Mount Airy NC
Renamed 27930 from Durants Neck to Hertford NC
Renamed 60170 from Plato Center to Elgin IL
Renamed 61311 from Ancona to Streator IL

The number of active ZIP codes is 41,744

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

Comment entered 2015-02-02 12:56:09 by Englisch, Volker (NIH/NCI) [C]

The updated ZIP codes have been loaded to DEV.
Please verify on DEV.

Comment entered 2015-02-25 12:48:06 by Englisch, Volker (NIH/NCI) [C]

According to CBIIT the new ZIP codes have been loaded.

Please verify on PROD.

Comment entered 2015-03-17 13:56:04 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Elapsed: 0:00:00.000854