Guest User

Untitled

a guest
Oct 18th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. SELECT ST_AsGeoJSON(ST_Transform(way, 4326)) AS geometry
  2. FROM pgr_dijkstra(
  3. 'SELECT osm_id AS id, source, target, st_length(way) as cost FROM planet_osm_roads',
  4. 34, 3000, false
  5. ) as di
  6. JOIN planet_osm_roads pt
  7. ON di.edge = pt.osm_id ;
  8.  
  9. SELECT ST_AsGeoJSON(ST_Transform(way, 4326)) AS geometry
  10. FROM pgr_dijkstra(
  11. 'SELECT osm_id AS id, source, target, st_length(way) as cost FROM planet_osm_roads',
  12. 'SELECT pl.source::integer FROM planet_osm_roads pl WHERE pl.name LIKE ''street_name'' LIMIT 1',
  13. 3000, false
  14. ) as di
  15. JOIN planet_osm_roads pt
  16. ON di.edge = pt.osm_id ;
Add Comment
Please, Sign In to add comment