Issue Number | 3535 |
---|---|
Summary | Zip Code Download and Upgrade |
Created | 2012-08-02 17:29:39 |
Issue Type | Improvement |
Submitted By | Englisch, Volker (NIH/NCI) [C] |
Assigned To | Englisch, Volker (NIH/NCI) [C] |
Status | Closed |
Resolved | 2012-09-13 11:29:21 |
Resolution | Fixed |
Path | /home/bkline/backups/jira/ocecdr/issue.107863 |
BZISSUE::5230
BZDATETIME::2012-08-02 17:29:39
BZCREATOR::Volker Englisch
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku
+++ This bug was initially created as a clone of OCECDR-3504 +++
We received the notification that our updated ZIP data is ready for download:
------------------------------------------------------------------------
From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Monday, July 30, 2012 10:47 AM
To: NCI OCE Admin Services; Strange, Geeta (NIH/NIMH) [C]; Englisch,
Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NCI) [C]
Subject: ZIPList5 Max August 2012
Hi Iris,
ZIPList5 Max August 2012, Enterprise License, is ready for download
from
our web site at:
http://data.zip-info.com/dataaug/z5max/z5max.htm
Please use the following User Name and Password (all in CAPS) to
access
the download page:
User Name: SBZXMZ
Password: BHBGCG
This is the first version (of four) of your 1-year subscription.
If you have any questions please let me know. Your customer # is ARL208.
We appreciate your business!
Best regards,
Sabine Chamberlain
ZipInfo.com
866-256-2042
BZDATETIME::2012-08-31 18:33:29
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1
The new zip code table has been updated on MAHLER and is ready for review.
Here are the changes for the past few months:
NEW THIS MONTH
For August 2012 the US Postal Service added 1 new 5-digit ZIP code,
deleted
3 existing 5-digit ZIP codes, and renamed 0 existing 5-digit
ZIPcodes.
Added 34071 M DPO, AA
Deleted 09721 M DPO, AE
Deleted 96220 M APO, AP
Deleted 96259 M APO, AP
The number of active ZIP codes is 41,854
OTHER RECENT CHANGES
For July 2012 the US Postal Service added 2 new 5-digit ZIP codes,
deleted
2 existing 5-digit ZIP codes, and renamed 3 existing 5-digit
ZIPcodes.
Added 40166 U Shepherdsville, KY
Added 46197 U Plainfield, IN
Deleted 09319 M APO, AE
Deleted 17942 P Landingville, PA
Renamed 23173 from University of Richmond to Richmond, VA
Renamed 50062 from Melcher-Dallas to Melcher Dallas, IA
Renamed 50163 from Melcher-Dallas to Melcher Dallas, IA
The number of active ZIP codes is 41,856
This month the USPS deleted 863 non-approved alias city names. These
deletions
were spread across all states. Customers of databases containing
alias
city names, such as ZIPList5, ZIPList5 Max, and ZIPList5 Plus should
expect to
see a concomitant reduction in the record count for this and subsequent
months.
For June 2012 the US Postal Service added 2 new 5-digit ZIP codes,
deleted
1 existing 5-digit ZIP code, and renamed 4 existing 5-digit
ZIPcodes.
Added 34441 P Hernando, FL
Added 73960 Texhoma, TX
Deleted 85055 Phoenix, AZ
Renamed 85309 from Glendale Luke AFB to Luke AFB, AZ
Renamed 96853 from J B P H H to JB PHH, HI
Renamed 96860 from J B P H H to JB PHH, HI
Renamed 96863 from M C B H Kaneohe Bay to McBh Kaneohe Bay, HI
The number of active ZIP codes is 41,856
BZDATETIME::2012-09-12 10:23:54
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2
(In reply to comment #1)
> The new zip code table has been updated on MAHLER and is ready for
review.
Verified on Mahler. Please promote to Bach.
BZDATETIME::2012-09-12 11:13:28
BZCOMMENTOR::Volker Englisch
BZCOMMENT::3
The new ZIP code data has been loaded to FRANCK and BACH.
Please verify on BACH and close this bug.
BZDATETIME::2012-09-13 11:29:21
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4
(In reply to comment #3)
> The new ZIP code data has been loaded to FRANCK and BACH.
>
> Please verify on BACH and close this bug.
Verified on Bach. Issue closed. Thanks!
Elapsed: 0:00:00.001790