| Issue Number | 4610 |
|---|---|
| Summary | Update ZIP code Table 2019Q2 |
| Created | 2019-05-02 13:21:46 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2019-05-02 14:26:06 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.243587 |
On 4/30/19, 18:17, "sabine@zipinfo.com" <sabine@zipinfo.com> wrote:
Hello Louise,
Here is the download info for ZIPList5 Max May 2019, Enterprise License
(user name and password are case sensitive):
http://data.zip-info.com/datamay/z5max/z5max.htm
User Name: QXUDXP
Password: YRALDH
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 ZIP code data has been loaded on DEV and QA.
Please verify.
Release Notes, May 2019
IMPORTANT CHANGES - PLEASE READ THIS
We updated the list of CBSA Metro/Micro/Division codes to the most recent
list released by the US Government. These codes appear only in ZIPList5 CBSA,
ZIPList5 Max, and ZIPList Can-USA Max.
The USPS removed the three-digit ZIP code 889 from its active ZIP
code list. ZIP codes 88901 and 88905 still exist in the CtyState file
but these ZIP codes have no assigned ZIP+4 address records.
Here is the list of ZIP codes that the US Postal Service has recently added,
deleted, or renamed:
=====================================================================
For May 2019 the US Postal Service added no new ZIP codes, deleted one
existing 5-digit ZIP code, and renamed no 5-digit ZIP code.
Deleted 63182 Saint Louis MO
The number of active ZIP codes is 41,696.
=====================================================================
For April 2019 the US Postal Service added four new 5-digit ZIP codes,
deleted no existing 5-digit ZIP code, and renamed no 5-digit ZIP code.
Added 09171 M DPO, AE
Added 09512 M FPO, AE
Added 34066 M DPO, AA
Added 34069 M DPO, AA
The number of active ZIP codes is 41,697.
=====================================================================
For March 2019 the US Postal Service added 19 new 5-digit ZIP codes,
deleted 3 existing 5-digit ZIP codes, and renamed no 5-digit ZIP code.
Added 09170 M DPO, AE
Added 09174 M DPO, AE
Added 09175 M DPO, AE
Added 09176 M DPO, AE
Added 09276 M DPO, AE
Added 09278 M DPO, AE
Added 09289 M DPO, AE
Added 09290 M DPO, AE
Added 09467 M DPO, AE
Added 09487 M DPO, AE
Added 09488 M DPO, AE
Added 09489 M DPO, AE
Added 09974 M DPO, AE
Added 09975 M DPO, AE
Added 09976 M DPO, AE
Added 09977 M DPO, AE
Added 34067 M DPO, AA
Added 34068 M DPO, AA
Added 96539 M APO, AP
Deleted 09906 M APO, AE
Deleted 09907 M APO, AE
Deleted 17354 Porters Sideling, PA
The number of active ZIP codes is 41,693
=====================================================================
# 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: 70351 I do this all the time - forgetting to make ~oseipokuw a watcher to check the ZIP codes.
Verified on QA. Thanks!
The new ZIP codes have been updated on STAGE and PROD.
Please verify on PROD and close this ticket.
Verified on PROD. Thanks!
Elapsed: 0:00:00.001549