Guest User

Untitled

a guest
Mar 6th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. select ST_Buffer(geom,80)::geometry
  2. (polygon,26986) As geom from road
  3. where street = 'hope';
  4.  
  5. select *
  6. from land;
  7.  
  8. select parcel, land_type , full_str
  9. from land
  10. left join road on ST_Dwithin(land.geom,road.geom, 19.812)
  11. where road_name = 'hope';
Add Comment
Please, Sign In to add comment