353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:57, 21 March 2017
, 14:57, 21 March 2017→Restructure Address Information
::U.S. post code follows the pattern [five digits - four digits]. In this way, U.S. patents can be extracted by searching for post code with regular expression.
For example,
city | postcode_city
---------------------------------------+---------------
NEW YORK, NY 10022-3201 | 10022-3201
BEAVERTON, OREGON 97005-6453 | 97005-6453
SANTA BARBARA, CA 93130-3003 | 93130-3003
NEW YORK NY 10022-3201 | 10022-3201
SUNNYVALE, CA 94088-3453 | 94088-3453
94088-3470 | 94088-3470
CS 46510-35065 RENNES CEDEX | 46510-3506
NEW YORK, NY 10013-2412 | 10013-2412
OALKLAND, CA 94612-3550 | 94612-3550
OXFORD CT 06483-1011 | 06483-1011
::The extracted post code records are stored in table ptoassigneend_missus_final.
::SQL code are is in:
E:/McNair/Projects/PatentAddress/RxPostcode.sql
::The state and post code are always together, separated by a space. So we can also extract state information with regular expression too.
For example,
::The extracted state records are stored in table ptoassigneend_missus_final.
::SQL code are is in:
E:/McNair/Projects/PatentAddress/RxPostcode.sql
