| Issue Number | 3711 |
|---|---|
| Summary | Update ZIP code Table 2014Q1 |
| Created | 2014-01-31 18:34:26 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2014-02-03 12:18:36 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.117959 |
Original Message -----
From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Friday, January 31, 2014 5:42 PM
To: Patten, Louise (NIH/NCI) [E]; NCI OCE Admin Services; Englisch,
Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NCI) [C]
Subject: ZIPList5 Max - February 2014
Hi Louise,
Here is the download info for ZIPList5 Max February 2014, Enterprise License (user name and password are case sensitive):
http://data.zip-info.com/datafeb/z5max/z5max.htm
User Name: KZHPYA
Password: FZUWHM
This is the third 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, February 2014
Here is the list of ZIP codes that the US Postal Service has recently
added,
deleted, or renamed.
=====================================================================
For February 2014 the US Postal Service added no new 5-digit ZIP
codes, deleted
3 existing 5-digit ZIP codes, and renamed 3 5-digit ZIP codes.
Deleted 09058 M APO, AE
Deleted 36625 U Mobile, AL
Deleted 92164 P San Diego, CA
Renamed 78150 from Randolph AFB to JBSA Randolph TX
Renamed 78234 from San Antonio to JBSA Ft Sam Houston TX
Renamed 78236 from Lackland AFB to JBSA Lackland TX
The number of active ZIP codes is 41,753
=====================================================================
For January 2014 the US Postal Service added no new 5-digit ZIP
codes, deleted
15 existing 5-digit ZIP codes, and renamed 4 5-digit ZIP codes.
Deleted 09008 M APO, AE
Deleted 09042 M APO, AE
Deleted 09063 M APO, AE
Deleted 09081 M APO, AE
Deleted 09267 M APO, AE
Deleted 09312 M FPO, AE
Deleted 09313 M APO, AE
Deleted 09339 M APO, AE
Deleted 09374 M DPO, AE
Deleted 09503 M FPO, AE
Deleted 09508 M FPO, AE
Deleted 09509 M FPO, AE
Deleted 09511 M FPO, AE
Deleted 09844 M FPO, AE
Deleted 14925 Elmira, NY
Renamed 09617 from APO to FPO AE
Renamed 84119 from Salt Lake City to West Valley City UT
Renamed 84120 from Salt Lake City to West Valley City UT
Renamed 84128 from Salt Lake City to West Valley City UT
The number of active ZIP codes is 41,756
=====================================================================
For December 2013 the US Postal Service added 2 new 5-digit ZIP
codes, deleted
20 existing 5-digit ZIP codes, and renamed 1 5-digit ZIP code.
Added 41021 U Erlanger, KY
Added 46210 U Indianapolis, IN
Deleted 03805 Newington, NH
Deleted 04846 P Glen Cove, ME
Deleted 05144 P Chester Depot, VT
Deleted 09229 M APO, AE
Deleted 09237 M APO, AE
Deleted 09380 M APO, AE
Deleted 09387 M APO, AE
Deleted 09545 M FPO, AE
Deleted 09549 M FPO, AE
Deleted 09557 M FPO, AE
Deleted 18926 P Gardenville, PA
Deleted 19420 P Arcola, PA
Deleted 34095 M FPO, AA
Deleted 43306 P Marion, OH
Deleted 90101 Los Angeles, CA
Deleted 91947 P Lincoln Acres, CA
Deleted 92412 P San Bernardino, CA
Deleted 96613 M FPO, AP
Deleted 96614 M FPO, AP
Deleted 96687 M FPO, AP
Renamed 89821 from Crescent Valley New to Crescent Valley NV
The number of active ZIP codes is 41,771
=====================================================================
The new ZIP code values (Q1 2014 update) have been loaded.
This is ready for review on DEV.
Verified on DEV.
The data have been loaded to the QA tier. Please double-check and mark the issue as verified.
The following 2 zip codes do not appear to have been added.
Added 41021 U Erlanger, KY
Added 46210 U Indianapolis, IN
I've looked in the database table and both of these new zip codes are
available.
What's the document that's using these?
I just tried the two again and they are working now. Not sure what happened yesterday but they did produce error messages. I will mark the issue as QA verified.
The last time we've handled the load of the ZIP codes outside of the release because it requires coordination between the DBA team and the Web team, so I'm going to do the same and submit the tickets for both teams now.
Note to myself:
Create the JIRA ticket for the Webteam and attach the data file to the ticket. Create a *.tar.gz file containing the file z5max.txt using the command
D:> \cygwin\bin\tar.exe -czf zipcode.tar.gz z5max.txtCBIIT has loaded the data to production. Please review and close this bug.
Where you able to check the loaded ZIP codes? CBIIT is asking if their task for this can be closed.
I just checked them and they are all okay.
Can we close the issue?
Yes. I just closed it.
Elapsed: 0:00:00.001190