353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:27, 29 March 2017
, 15:27, 29 March 2017→Restructure Address Information
'''5. Output (Tables)'''
*'''*ptoassigneend_allus'''
This table contains all the U.S. patents extracted from ptoassigneend table. The rule to generate this table is 'country = 'UNITED STATES' ' or any of the features contains U.S. postcode.
postcode | character varying(80) |
*'''*ptoassigneend_missus_final'''
State and postcode information extracted from addrline1, addrline2 and city columns are stored in this table. See section 2 and 3.
state_city is the state name extracted from 'city'; state_addr1 is the state name extracted from 'addrline1'; state_addr2 is the state name extracted from 'addrline2'.
*'''*ptoassigneend_missus_city_final'''
City information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_city table. See section 4.
