| Issue Number | 4467 |
|---|---|
| Summary | Update ZIP code Table 2018Q2 |
| Created | 2018-05-01 11:20:26 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2018-05-01 11:31:27 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.225223 |
{{From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Monday, April 30, 2018 8:58 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: Potential SPAM:ZIPList5 Max May 2018 - ZIP Code Data
Hello Louise,
Here is the download info for ZIPList5 Max May 2018, Enterprise License (user name and password are case sensitive):
http://data.zip-info.com/datamay/z5max/z5max.htm
User Name: NDPKZV
Password: BZPKVM
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}}
Release Notes, May 2018
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 2018 the US Postal Service added three new 5-digit ZIP codes, deleted
one existing 5-digit ZIP code, and renamed one 5-digit ZIP code.
Added 56966 U Parcel Return Service, DC
Added 56968 U Parcel Return Service, DC
Added 56969 U Parcel Return Service, DC
Deleted 72105 P Jones Mill, AR
Renamed 13671 from Oxbow to Antwerp NY
The number of active ZIP codes is 41,682
=====================================================================
For April 2018 the US Postal Service added sixteen new 5-digit ZIP codes, deleted
one existing 5-digit ZIP code, and renamed five 5-digit ZIP codes.
Added 09533 M APO, AE
Added 09541 M APO, AE
Added 09542 M APO, AE
Added 09544 M APO, AE
Added 09545 M APO, AE
Added 34050 M APO, AA
Added 34051 M APO, AA
Added 34052 M APO, AA
Added 34053 M APO, AA
Added 34054 M APO, AA
Added 96262 M APO, AP
Added 96633 M APO, AP
Added 96641 M APO, AP
Added 96642 M APO, AP
Added 96644 M APO, AP
Added 96645 M APO, AP
Deleted 92190 San Diego, CA
Renamed 92585 from Sun City to Menifee CA
Renamed 92586 from Sun City to Menifee CA
Renamed 92587 from Quail Valley to Menifee CA
Renamed 96939 from Palau to Ngerulmud PW
Renamed 96940 from Palau to Koror PW
The number of active ZIP codes is 41,680
=====================================================================
For March 2018 the US Postal Service added three new 5-digit ZIP codes, deleted
one existing 5-digit ZIP code, and renamed no 5-digit ZIP code.
Added 09864 M DPO, AE
Added 09867 M DPO, AE
Added 09869 M DPO, AE
Deleted 09001 M DPO, AE
The number of active ZIP codes is 41,665
=====================================================================
#
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: 70295
The updated ZIP codes have been loaded to DEV and QA.
~oseipokuw, these are ready for review.
Is this ready to go to PROD, ~oseipokuw?
Yes, please.
The updated ZIP codes have been loaded to STAGE and PROD.
Please verify on PROD and close this ticket.
Verified on PROD. Thanks!
Elapsed: 0:00:00.001687