353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:28, 20 April 2017
, 16:28, 20 April 2017→city that is a city
Select distinct city records in ptoassigneend_us_extracted and store them in ptoasigneend_us_citylist (775).
The following methods can be used safest method to identify clean city. * Feature is to find records with feature city is in ptoassigneend_us_citylist.
SQL Code:
FROM ptoassigneend_us_citylist);
-- SELECT 2574811 (992450 LEFT)
*Feature city is null or spaces (Not Clean)
-- SELECT 51050
