Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT
  2. buildings.mid_st,
  3. buildings.geometry,
  4. ST_Distance(buildings.geometry::geography, sewery.geometry::geography) as distance
  5. FROM
  6. (
  7. SELECT DISTINCT geometry
  8. FROM public.ks2_st
  9. ) as buildings,
  10. (
  11. SELECT _mid_gji, geometry
  12. FROM gji.t2100_ill
  13. ) as sewery
  14. ORDER BY buildings.geometry <-> sewery.geometry
  15. LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement