Database Reference
In-Depth Information
You will recognize the following syntax from Dijkstra. The code is executed as fol-
lows:
WITH astar AS (
SELECT pgr_astar('SELECT gid AS id, source,
target,
length AS cost FROM ways',
89475,
14584,
false,
false)
)
SELECT gid, the_geom
FROM ways w, astar a
WHERE w.gid = (a.pgr_astar).id2;WITH astar AS
(
SELECT pgr_astar('SELECT gid AS id, source,
target,
length AS cost, x1, x2, y1, y2 FROM
cleveland_ways',
89475,
14584,
false,
false)
)
SELECT gid, the_geom
FROM cleveland_ways w, astar a
WHERE w.gid = (a.pgr_astar).id2;
Thefollowingscreenshotshowstheresultsshownonamap(Maptilesby
Stamen
Design, under CC BY 3.0
, Data by
OpenStreetMap, under CC BY SA
.):
