Guest User

Untitled

a guest
Jan 22nd, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. SELECT p.gid,
  2. CASE
  3. WHEN ST_Intersects(ST_Buffer((p.geom::geography),2),pr.geom::geography)='true' THEN TRUE
  4. ELSE FALSE
  5. END
  6. FROM points p
  7. JOIN protected_lines pr
  8. ON ST_Intersects(ST_Buffer((p.geom::geography),2),pr.geom::geography)
  9. WHERE p.gid=3905591;
Add Comment
Please, Sign In to add comment