Guest User

Untitled

a guest
Dec 11th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. SELECT distinct ST_AsText((ST_Intersection(ST_Buffer(a.geom, 0.2, 'endcap=round join=round'), ST_ExteriorRing(b.geom)))),a.elemid,b.elemid FROM "Line" as a,"Polygon" as b WHERE st_Intersects(a.geom, b.geom)
  2.  
  3. SELECT distinct ST_AsText((ST_Intersection(ST_Buffer(ST_ExteriorRing(a.geom), 0.2, 'endcap=round join=round'), ST_ExteriorRing(b.geom)))), a.elemid, b.elemid FROM "Polygon" as a,"Polygon" as b WHERE st_Intersects(a.geom, b.geom) and a.id != b.id;
Add Comment
Please, Sign In to add comment