353
edits
Changes
Jump to navigation
Jump to search
States Cities extracted from addrline1, addrline2 and city are stored in ptoassigneend_stateptoassigneend_city.
Patent Assignment Data Restructure (view source)
Revision as of 16:42, 5 April 2017
, 16:42, 5 April 2017→Master Table
Since city_city is extracted from feature city and is cleaned, city_city beats city.
For records of which addrline1, addrline2 and city don't contain city info, clean the feature city in the following way:
[To do]:
* Output
SQL code is in:
E:/McNair/Projects/PatentAddress/StateCleanCityClean.sql
All the cleaned states cities for U.S. patents are stored in ptoassigneend_us_statecleanedptoassigneend_us_citycleaned. (# 3572605)
====Issues====
