353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:32, 29 March 2017
, 17:32, 29 March 2017→Restructure Address Information
IO files are on the dbase server in:
Z:/PatentAddress
==Extract Address Information==
'''1. Introduction'''
* Some records are 'A CORP. OF CA.' or 'A CORP. OF NY' or 'A CORPORATION OF CA', which may be another method to extract state information.
* Information extracted from addrline1, addrline2 and city is not consistent.Which one is the priority? ===Condense Address Information== 1. Introduction 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. Examples: Output: Schema | Name | Type | Owner public | ptoassigneend_city | table | researcher public | ptoassigneend_postcode | table | researcher public | ptoassigneend_state | table | researcher
