353
edits
Changes
Jump to navigation
Jump to search
====*'''Inconsistency between 'addrline' and 'country'(To do) ===='''
====Issues====
Patent Assignment Data Restructure (view source)
Revision as of 15:49, 3 April 2017
, 15:49, 3 April 2017→Restructure Address Information
city_city is the city name extracted from 'city'; city_addr1 is the city name extracted from 'addrline1'; city_addr2 is the city name extracted from 'addrline2'.
====Condense Address Information(To do)Issues====
*'''1. IntroductionCondense Address Information(To do)'''
The address information extracted from addrline1, addrline2 and city is not consistent. For example, the postcode extracted from addrline1 may be different from that extracted from city.
E:\McNair\Projects\PatentAddress\AddrClean.sql
Example:
3001 ORCHARD PARKWAY SAN JOSE, CA 95134-2088 | MINATO-KU, TOKYO 107 | JAPAN
* The post code and zip regex for other countries besides U.S. can be found here:
