| Issue Number | 4182 |
|---|---|
| Summary | Update ZIP code Table 2016Q4 |
| Created | 2016-11-01 15:15:27 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2016-11-01 15:21:36 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.197570 |
The updated data for the ZIP codes is available to be loaded.
{{From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Monday, October 31, 2016 5:35 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: ZIPList5 Max November 2016 ZIP Code data
Hello Louise,
Here is the download info for ZIPList5 Max November 2016, Enterprise License (user name and password are case sensitive):
http://data.zip-info.com/datanov/z5max/z5max.htm
User Name: FFGSKQ
Password: SLJJGQ
This is the second 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
}}
Release Notes, October 2016
IMPORTANT CHANGES - PLEASE READ THIS
Here is the list of ZIP codes that the US Postal Service has recently added,
deleted, or renamed:
=====================================================================
For November 2016 the US Postal Service added no new 5-digit ZIP codes, deleted
no existing 5-digit ZIP codes, and renamed no 5-digit ZIP codes.
The number of active ZIP codes is 41,711
=====================================================================
For October 2016 the US Postal Service added two new 5-digit ZIP codes, deleted
18 existing 5-digit ZIP code, and renamed no 5-digit ZIP code.
Added 97079 U Beaverton, OR
Added 97129 U Hillsboro, OR
Deleted 06920 U Stamford, CT
Deleted 06922 U Stamford, CT
Deleted 10161 New York, NY
Deleted 11819 U Hicksville, NY
Deleted 28250 U Charlotte, NC
Deleted 30163 Rome, GA
Deleted 48391 P Walled Lake, MI
Deleted 53927 P Dellwood, WI
Deleted 55383 P Norwood, MN
Deleted 55551 P Young America, MN
Deleted 55568 P Young America, MN
Deleted 55583 P Norwood, MN
Deleted 55747 P Hibbing, MN
Deleted 68120 P Omaha, NE
Deleted 68155 P Omaha, NE
Deleted 79990 P El Paso, TX
Deleted 85097 New River, AZ
Deleted 92515 Riverside, CA
The number of active ZIP codes is 41,711
=====================================================================
For September 2016 the US Postal Service added six new 5-digit ZIP codes, deleted
five existing 5-digit ZIP code, and renamed no 5-digit ZIP codes.
Added 09761 M FPO, AE
Added 09807 M DPO, AE
Added 09854 M DPO, AE
Added 34001 M DPO, AA
Added 66630 U Topeka, KS
Added 96210 M DPO, AP
Deleted 02783 U Taunton, MA
Deleted 09038 M APO, AE
Deleted 09840 M FPO, AE
Deleted 46295 U Indianapolis, IN
Deleted 83601 P Atlanta, ID
The number of active ZIP codes is 41,727
=====================================================================
The data has been loaded to DEV and QA and is ready for review.
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: 70463
Adding ~oseipokuw as a watcher/reviewer.
Verified on DEV and QA.
The updated ZIP codes have been loaded to STAGE.
Please check before we load the data to PROD.
Verified on STAGE.
The ZIP codes have been loaded to PROD.
Please double-check and close this ticket.
Can this ticket be closed?
Elapsed: 0:00:00.001363