353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:12, 27 March 2017
, 16:12, 27 March 2017→Restructure Address Information
:::SQL code is in:
E:/McNair/Projects/PatentAddress/CityPatternsRxCity.sql
:'''5. Output (Tables)'''
::*ptoassigneend_allus
:::This table contains all the U.S. patents extracted from ptoassigneend table. The rule to extract generate this table is 'country = 'UNITED STATES' ' or any of the features contains U.S. postcode. :::Noise exists.
:::The SQL code is:
::*ptoassigneend_missus_final
:::State and postcode information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_missus_final this table. See section 2 and 3.
:::This table is a subset of ptoassigneend_allus table.
state_addr2 | text |
:::postcode_city is the postcode extracted from 'city'. ; postcode_addr1 is the postcode extracted from 'addrline1'. ; postcode_addr2 is the postcode extracted from 'addrline2'.
:::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
:::This table is a subset of ptoassigneend_allus table.
Table "public.ptoassigneend_missus_city_final"
Column | Type | Modifiers
------------+------------------------+-----------
reelno | integer |
frameno | integer |
name | character varying(500) |
addrline1 | character varying(500) |
addrline2 | character varying(500) |
city | character varying(500) |
state | character varying(500) |
country | character varying(500) |
postcode | character varying(80) |
city_addr1 | text |
city_addr2 | text |
city_city | text |
:::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'.
:'''6. Issues'''
