Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT roads.* FROM roads, points
  2. WHERE points._search_frame_ = roads.geometry
  3. AND MbrWithin(points.geometry, roads.geometry)
  4. AND ST_Within(point.geometry, roads.geometry)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement