Changes

Jump to navigation Jump to search
For records of which addrline1, addrline2 and city don't contain postcode info, just clean the feature postcode as the postcode_cleaned
All the cleaned postcodes for U.S. patents are stored in ptoassigneend_us_postcodecleaned. (# 35724603572604)
=====State=====
For records of which addrline1, addrline2 and city don't contain state info, just take feature state as the state_cleaned.
 
* Output
 
SQL code is in:
 
E:/McNair/Projects/PatentAddress/StateClean.sql
 
States extracted from addrline1, addrline2 and city are stored in ptoassigneend_state.
 
All the cleaned states for U.S. patents are stored in ptoassigneend_us_statecleaned. (# 3572605)
====Issues====

Navigation menu