353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:39, 4 April 2017
, 15:39, 4 April 2017→Master Table
Reminder: postcode_city is the postcode extracted from 'city'; postcode_addr1 is the postcode extracted from 'addrline1'; postcode_addr2 is the postcode extracted from 'addrline2'.
The postcode_city, postcode_addr1 and postcode_addr2 are consistent. The issue is the difference between postcode and (postcode_city, postcode_addr1 and postcode_addr2).
Examples:
postcode_addr1 | postcode_addr2
90401-1708 | 90401-1708
37831-8243 | 37831-8243
The issue is the difference between postcode and (postcode_city, postcode_addr1 and postcode_addr2). * Difference between postcode and postcode_addr1 Take postcode_addr1 as the postcode cleaned because addrline1 is detailed. For example: addrline1 | postcode_addr1 | postcode_new reelno P.O. BOX 6 / 83707-0006 | 83707-0006 | frameno 83716 BLDG. C01, M.S. A126 P.O. BOX 80028 LOS ANGELES, CA 90080-0028 | postcode 90080-0028 | 90045 P. O. BOX 1407, HOUSTON, TEXAS 77251-1407 | 77251-1407 | 77042 841 3RD, LONGVIEW, WASHINGTON 98632-0189 | 98632-0189 | 95404 2210 W. OAKLAWN, 72762-6999 | 72762-6999 | 72765-2020 BLDG. CO1, M.S. A126, P.O. BOX 80028 LOS ANGELES, CA 90080-0028 | 90080-0028 | 90045 P.O. BOX 6 / 83707-0006 | 83707-0006 | 83716 BLDG. CO1, M.S. A126, P.O. BOX 80028 LOS ANGELES, CA 90080-0028 | 90080-0028 | 90045 P.O. BOX 3707, M/S 13-08, SEATTLE, WA 98124-2207 | 98124-2207 | 98108 P.O. BOX 6 / 83707-0006 | postcode_addr1 83707-0006 | postcode_addr2 83716 8000 SOUTH FEDERAL WAY, P.O. BOX 6 / 83707-0006 | postcode_city 83707-0006 | postcode_new83716-9632 12361 P.O. BOX 674412, HOUSTON, TX 77267-4412 | 77267-4412 456 | 78759 77032 14090-6100 ROAD | 14090-6100 | 81401 P.O. BOX 80028, LOS ANGELES, CALIFORNIA 90080-0028 | 1178890080-8847 0028 | 7875990045
====Issues====
