353
edits
Changes
Jump to navigation
Jump to search
* Some records are 'A CORP. OF CA.' or 'A CORP. OF NY' or 'A CORPORATION OF CA', which may be another method to extract state information.
Patent Assignment Data Restructure (view source)
Revision as of 16:57, 29 March 2017
, 16:57, 29 March 2017→Extract Address Information
WHEN city ~* 'D[.]C[.]\s\d{5}-\d{4}'
THEN 'D.C.'
'''d. 'A CORP.* OF''''
Some records are 'A CORP. OF CA.' or 'A CORP. OF NY' or 'A CORPORATION OF CA', which is another method to extract state information.
Examples:
---------------------------------------------------------------------------------------------------------------------------------------------------------
A CORPORATION OF NY
A CORPORATION OF TEXAS
A CORPORATION OF NEW YORK
A CORP. OF INDIANA
A CORP. OF OR
A CORPORATION OF IL P.O. BOX 5018
CORPORATE SECRETARY'S OFFICE
A CORP. OF NEW YORK
A CORP. OF OHIO
A CORP. OF CA.
A CORP. OF DE.
The extracted state records are stored in the table ptoassigneend_missus_final.
* Both state name and its abbreviation exist.
* Information extracted from addrline1, addrline2 and city is not consistent. Which one is the priority?
