353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:50, 22 March 2017
, 16:50, 22 March 2017→Restructure Address Information
::*ptoassigneend_missus_final
:::State and postcode information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_missus_final table. See section 3 and 4.
:::This table is a subset of ptoassigneend_allus table.
:::Noise:The postcode extracted from addrline1 and addrline2 may be different. Need further cleaning.
::*ptoassigneend_city
:::City information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_city table. See section 5.
:::This table is a subset of ptoassigneend_allus table.
:'''23. Postcode(U.S.)'''
::U.S. post code follows the pattern [five digits - four digits]. In this way, U.S. patents can be extracted by searching for post code with regular expression.
E:/McNair/Projects/PatentAddress/RxPostcode.sql
:'''34. State (U.S.)'''
::The state and post code are always together, separated by a space. So we can also extract state information with regular expression too.
E:/McNair/Projects/PatentAddress/RxPostcode.sql
:'''45. City (U.S.)'''
:: There are some patterns that can be used to extract city information.
:'''56. Issues'''
::* The post code and zip regex for other countries besides U.S. can be found here:
http://stackoverflow.com/questions/578406/what-is-the-ultimate-postal-code-and-zip-regex
