353
edits
Changes
Jump to navigation
Jump to search
Select distinct city records in ptoassigneend_us_extracted and store them in ptoassigneend_us_citylist (775). Since the city list is not long, I briefly cleaned the list by hand, and still stored in ptoassigneend_us_citylist (730). The safest method One option to identify clean city is to find records with feature city in that match ptoassigneend_us_citylist.
Patent Assignment Data Restructure (view source)
Revision as of 16:02, 1 May 2017
, 16:02, 1 May 2017→Identify Clean Data
First, filter out records with city that is a city, zip that is a zip, state that is a state. Note: The consistency between city and state or city and postcode is not checked in this section.
* ptoassigneend_us_citylist
Select distinct city records in ptoassigneend_us_extracted and store them in ptoassigneend_us_citylist (775).
Since the city list is not long, I briefly cleaned the list by hand, and stored it in ptoassigneend_us_citylist (730).
====zip that is a zip====
====city that is a city====
SQL Code:
