353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:24, 3 May 2017
, 15:24, 3 May 2017→Restructure Address Information (First Stage)
SQL code is in:
E:/McNair/Projects/PatentAddress/RestructureAddressInfo(First Stage).sql
====State====
SQL code is in:
E:/McNair/Projects/PatentAddress/FunctionsRestructureAddressInfo(First Stage).sql
====City====
SQL code is in:
E:/McNair/Projects/PatentAddress/FunctionsRestructureAddressInfo(First Stage).sql
====Output (Tables)====
SQL code is in:
E:/McNair/Projects/PatentAddress/FunctionsRestructureAddressInfo(First Stage).sql
===Clean Address Info (Master Table)===
SQL code is in:
E:/McNair/Projects/PatentAddress/FunctionsRestructureAddressInfo(First Stage).sql
For records of which 'addrline1', 'addrline2' and 'city' don't contain postcode info, just clean the 'postcode' as the 'postcode_cleaned'
SQL code is in:
E:/McNair/Projects/PatentAddress/FunctionsRestructureAddressInfo(First Stage).sql
All the cleaned states for U.S. patents are stored in ptoassigneend_us_cleaned (see feature state_cleaned).
SQL code is in:
E:/McNair/Projects/PatentAddress/FunctionsRestructureAddressInfo(First Stage).sql
All the cleaned cities for U.S. patents are stored in ptoassigneend_us_cleaned. (see feature city_cleaned)
All the SQL is in:
E:/McNair/Projects/PatentAddress/FunctionsRestructureAddressInfo(First Stage).sql
==== Cleaning ====
