Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. SELECT row_number() over (order by a.id desc) as gid, a.nsg as nsg, b.ffh as ffh,
  2. ST_Union(a.geom,b.geom) as geom, st_area(St_union(a.geom,b.geom)) as area
  3. FROM p_gaiac.shape1 as a, p_gaiac.shape2 as b
  4.  
  5. SELECT geom FROM table1
  6. UNION
  7. SELECT geom FROM table2
  8. UNION
  9. SELECT geom FROM (
  10. (SELECT ST_Intersection(t3.geom, t4.geom) As geom
  11. FROM table1 as t3 JOIN table2 as t4 ON ST_Intersects(t3.geom, t4.geom))
  12. ) As subquery;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement