353
edits
Changes
Jump to navigation
Jump to search
Output:
Schema | Name | Type | Owner
public | ptoassigneend_city | table | researcher
public | ptoassigneend_postcode | table | researcher
public | ptoassigneend_state | table | researcher
SQL code is in:
E:\McNair\Projects\PatentAddress\AddrClean.sql
Patent Assignment Data Restructure (view source)
Revision as of 16:16, 3 April 2017
, 16:16, 3 April 2017→Issues
(postcode_city is the postcode extracted from 'city'; postcode_addr1 is the postcode extracted from 'addrline1'; postcode_addr2 is the postcode extracted from 'addrline2'.)
*'''Inconsistency between 'addrline' and 'country'(To do) '''
