Advertisement
Guest User

Untitled

a guest
Oct 16th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. -- Find features that exist only in 2019
  2. -- and do not intersect with, but can touch features in 2011
  3. CREATE TABLE results_final.polygonal_2019_change_nhd_additions AS
  4. SELECT t2.*
  5. FROM results_final.polygonal_2019_change_nhd_id AS t2
  6. LEFT JOIN results_final.polygonal_2011_change_nhd_id AS t1
  7. ON ( St_intersects(t2.wkb_geometry, t1.wkb_geometry)
  8. AND NOT St_touches(t2.wkb_geometry, t1.wkb_geometry) )
  9. WHERE t1.ogc_fid IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement