353
edits
Changes
Jump to navigation
Jump to search
Take postcode_addr1 as the beats postcode cleaned because addrline1 is detailed. For example:
Patent Assignment Data Restructure (view source)
Revision as of 15:02, 4 April 2017
, 15:02, 4 April 2017→Master Table
* Difference between postcode and postcode_addr1
addrline1 | postcode_addr1 | postcode_new
P.O. BOX 6 / 83707-0006 | 83707-0006 | 83716
14090-6100 ROAD | 14090-6100 | 81401
P.O. BOX 80028, LOS ANGELES, CALIFORNIA 90080-0028 | 90080-0028 | 90045
* Difference between postcode and postcode_addr2
postcode_addr2 beats postcode because addrline2 is detailed.
Example:
addrline2 | postcode_addr2 | postcode_new
P.O. BOX 6 / 83707-0006 | 83707-0006 | 83716-9632
P.O. BOX 5800 - MS0161, ALBUQUERQUE, NEW MEXICO 87185-0161 | 87185-0161 | 87123-0161
P.O. BOX 674412, HOUSTON, TEXAS 77267-4412 | 77267-4412 | 77002
WASHINGTON, DC 20250-1400 | 20250-1400 | 61604
BOX 10076, HATTIESBURGH, MISSISSIPPI 39406-0076 | 39406-0076 | 39402
P.O. BOX 674412, HOUSTON, TEXAS 77267-4412 | 77267-4412 | 77032
P.O. BOX 6 / 83707-0006 | 83707-0006 | 83716-9632
P.O. BOX 6 / 83707-0006 | 83707-0006 | 83716-9632
P.O. BOX 27115-4191 | 27115-4191 | 27105-4191
P.O. BOX 674412, HOUSTON, TX 77267-4412 | 77267-4412 | 77002
Besides, I randomly picked some records and googled address and postcode. These records support postcode_addr2.
Examples:
Micron Technology, Inc.
8000 South Federal Way
Post Office Box 6
Boise 83707-0006
USA
Tel: Ph: 208-368-4000
WebsterBank, NA
50 Kennedy Plaza
11th Floor Suite 110 (Mail Stop: PR-105)
Providence, RI 02903
====Issues====
