Changes

Jump to navigation Jump to search
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"

Navigation menu