353
edits
Changes
Jump to navigation
Jump to search
Merge ptoassigneend_missus_final and ptoassigneend_missus_city_final with:
CREATE TABLE ptoassigneend_us_extracted AS
SELECT a.*, b.city_addr1, b.city_addr2, b.city_city
FROM ptoassigneend_missus_final a
LEFT JOIN ptoassigneend_missus_city_final b
ON a.reelno = b.reelno AND a.frameno = b.frameno
AND a.name = b.name AND a.addrline1 = b.addrline1 AND
a.addrline2 = b.addrline2 AND
a.city = b.city;
Patent Assignment Data Restructure (view source)
Revision as of 17:26, 5 April 2017
, 17:26, 5 April 2017→5. Output (Tables)
Contain all the original features as well as city, state and postcode info extracted from features addrline1, addrline2 and city.
Merge ptoassigneend_missus_final and ptoassigneend_missus_city_final with:
CREATE TABLE ptoassigneend_us_extracted AS
SELECT a.*, b.city_addr1, b.city_addr2, b.city_city
FROM ptoassigneend_missus_final a
LEFT JOIN ptoassigneend_missus_city_final b
ON a.reelno = b.reelno AND a.frameno = b.frameno
AND a.name = b.name AND a.addrline1 = b.addrline1 AND
a.addrline2 = b.addrline2 AND
a.city = b.city;
Table "public.ptoassigneend_us_extracted"
city_addr2 | text |
city_city | text |
====Master Table====
