Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Find features that exist only in 2019
- -- and do not intersect with, but can touch features in 2011
- CREATE TABLE results_final.polygonal_2019_change_nhd_additions AS
- SELECT t2.*
- FROM results_final.polygonal_2019_change_nhd_id AS t2
- LEFT JOIN results_final.polygonal_2011_change_nhd_id AS t1
- ON ( St_intersects(t2.wkb_geometry, t1.wkb_geometry)
- AND NOT St_touches(t2.wkb_geometry, t1.wkb_geometry) )
- WHERE t1.ogc_fid IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement