CDR Tickets

Issue Number 4771
Summary Update ZIP code Table 2020Q1
Created 2020-02-03 13:40:37
Issue Type Task
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2020-02-03 13:51:18
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.256090
Description

Hello Louise,

Here is the download info for ZIPList5 Max February 2020, Enterprise

License (user name and password are case sensitive):

     http://data.zipinfo.com/datafeb/z5max/z5max.htm

     User Name: BALAZC

     Password:  LSVUDY

This is the third version (of four) of your 1-year subscription.

If you have any questions please let me know.

Thank you for your business and have a great weekend!

   

Best regards,

Sabine Chamberlain

ZipInfo.com

866-256-2042

Cust #: ARL208

Comment entered 2020-02-03 13:42:43 by Englisch, Volker (NIH/NCI) [C]

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: 70403
Elapsed time: 0:02:42.807528

Comment entered 2020-02-03 13:49:18 by Englisch, Volker (NIH/NCI) [C]

Release Notes, February 2020

IMPORTANT CHANGES - PLEASE READ THIS

Here is the list of ZIP codes that the US Postal Service has recently added,
deleted, or renamed:

=====================================================================
For February 2020 the US Postal Service added three new 5-digit ZIP
codes, deleted three existing 5-digit ZIP codes, and renamed one
5-digit ZIP code.

Added 09015 M APO, AE
Added 09103 M APO, AE
Added 96502 M APO, AP

Deleted 24468 Mustoe, VA
Deleted 90834 Long Beach, CA
Deleted 90835 Long Beach, CA

Renamed 37934 from Knoxville to Farragut TN

The number of active ZIP codes is 41,701

=====================================================================
For January 2020 the US Postal Service added two new ZIP codes, deleted
one existing 5-digit ZIP code, and renamed no 5-digit ZIP code.

Added 09279 M DPO, AE
Added 09283 M DPO, AE

Deleted 19080 U Wayne, PA

The number of active ZIP codes is 41,701

=====================================================================
For December 2019 the US Postal Service added one new ZIP code, deleted
three existing 5-digit ZIP codes, and renamed no 5-digit ZIP code.

Added 09514 M FPO, AE

Deleted 09101 M APO, AE
Deleted 09314 M APO, AE
Deleted 34278 P Sarasota, FL

The number of active ZIP codes is 41,700

=====================================================================
#

Comment entered 2020-02-03 13:51:11 by Englisch, Volker (NIH/NCI) [C]

The Q1 2020 ZIP codes have been uploaded to DEV and QA.

This is ready for you, , to verify.

Comment entered 2020-02-12 12:59:53 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Since we no longer publish GPs, it is probably time to stop doing this since we don't publish person records to Cancer.gov. We still use the board member records but I am not sure that we need to continue to do this for such a small subset of the records. It will probably be less expensive to remove the validation on the zip codes and handle the board member records manually. Let's discuss this tomorrow in the CDR meeting ?

Comment entered 2020-02-20 13:46:10 by Juthe, Robin (NIH/NCI) [E]

Closed in the status meeting.

Elapsed: 0:00:00.001329