Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH closest_candidates AS (
- select a.*, b.*, st_distance(a.geometry, b.geometry) as dist from a,b where st_intersects(a.geometry, st_buffer(b.geometry,100))
- )
- select * from closest_candidates where dist < 50
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement