| Issue Number | 4008 |
|---|---|
| Summary | Update ZIP code Table 2015Q4 |
| Created | 2015-12-04 21:09:44 |
| Issue Type | Task |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2015-12-04 21:13:44 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.175168 |
From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Sunday, November 01, 2015 1:02 PM
To: Patten, Louise (NIH/NCI) [E]; NCI OCPL Program Support Services;
Englisch, Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NCI) [C]
Subject: ZIPList5 Max - November 2015
Hi Louise,
Here is the download info for ZIPList5 Max November 2015, Enterprise License (user name and password are case sensitive):
http://data.zip-info.com/datanov/z5max/z5max.htm
User Name: UXARAD
Password: MNKQFX
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
For November 2015 the US Postal Service added one new 5-digit ZIP
code, deleted
33 existing 5-digit ZIP codes, and renamed two existing -digit ZIP
codes.
Added 96632 M FPO, AP
Deleted 20532 U Washington, DC
Deleted 55166 P Saint Paul, MN
Deleted 55168 U Saint Paul, MN
Deleted 55171 U Saint Paul, MN
Deleted 55365 P Monticello, MN
Deleted 55393 P Maple Plain, MN
Deleted 55394 P Young America, MN
Deleted 55399 P Young America, MN
Deleted 55552 P Young America, MN
Deleted 55556 P Young America, MN
Deleted 55557 P Young America, MN
Deleted 55559 P Young America, MN
Deleted 55560 P Young America, MN
Deleted 55562 P Young America, MN
Deleted 55564 P Young America, MN
Deleted 55565 P Monticello, MN
Deleted 55566 P Young America, MN
Deleted 55567 P Young America, MN
Deleted 55580 P Monticello, MN
Deleted 55581 P Monticello, MN
Deleted 55582 P Monticello, MN
Deleted 55584 P Monticello, MN
Deleted 55585 P Monticello, MN
Deleted 55586 P Monticello, MN
Deleted 55587 P Monticello, MN
Deleted 55588 P Monticello, MN
Deleted 55589 P Monticello, MN
Deleted 55590 P Monticello, MN
Deleted 55591 P Monticello, MN
Deleted 55701 Adolph, MN
Deleted 56006 P Mankato, MN
Deleted 56177 P Trosky, MN
Deleted 56478 Nimrod, MN
Renamed 01718 from Village of Nagog Woods to Acton MA
Renamed 09348 from DPO to APO AE
The number of active ZIP codes is 41,714.
=====================================================================
For October 2015 the US Postal Service added seven new 5-digit ZIP
codes, deleted
no existing 5-digit ZIP codes, and renamed no 5-digit ZIP codes.
Added 09308 M APO, AE
Added 09333 M APO, AE
Added 09378 M APO, AE
Added 09815 M APO, AE
Added 56908 U Parcel Return Service, DC
Added 96208 M APO, AP
Added 96251 M APO, AP
The number of active ZIP codes is 41,746
=====================================================================
For September 2015 the US Postal Service added no new 5-digit ZIP
codes, deleted
2 existing 5-digit ZIP codes, and renamed no 5-digit ZIP codes.
Deleted 60290 U Chicago, IL
Deleted 62721 U Springfield, IL
The number of active ZIP codes is 41,739
=====================================================================
The ZIP code table has been updated on DEV and QA and is ready to verify.
Verified on QA. It looks like the Refresh wiped the changes on DEV. They failed on DEV.
It looks like the Refresh wiped the changes on DEV.
If you checked today then you are correct, the refresh restored the old content from PROD. I can reload the ZIP codes on DEV if you want to check there again.
The ZIP codes have been reloaded on DEV.
The request for the DB team to create the backup copies of the ZIP code table has been submitted. (DBATEAM-2215)
The ZIP codes have been reloaded on DEV.
Did you refresh DEV again? The changes do not appear to be on DEV.
Loading the ZIP codes on PROD and STAGE has been requested with the ticket WEBTEAM-7861.
The ZIP codes have been loaded on PROD and STAGE.
Please verify and close this ticket.
Elapsed: 0:00:00.001469