353
edits
Changes
Jump to navigation
Jump to search
Since city_city is extracted from , city_addr1 and city_addr2 beat feature city and is cleaned, city_city beats citybecause they are detailed.
Patent Assignment Data Restructure (view source)
Revision as of 17:41, 10 April 2017
, 17:41, 10 April 2017→City
CARROLLTON | CARROLLTON
For records of which addrline1, addrline2 and city don't contain city info, just keep feature city as the city_cleaned.
SQL code is in:
E:/McNair/Projects/PatentAddress/CityCleanFunctions.sql
All the cleaned cities for U.S. patents are stored in ptoassigneend_us_citycleaned. (# 3572605)
