[pgrouting-users] pgr_withPointsDD - arguments
Jakob Miksch
jakob.miksch at posteo.eu
Sat Sep 30 04:27:47 PDT 2017
Dear List,
I compare the arguments of "pgr_drivingDistance"[1] and
"pgr_withPointsDD"[2].
The example of "pgr_withPointsDD"[2] confuses me. In the examples the
argument "edges_sql" ends with "ORDER BY id". Whereas
"pgr_drivingDistance"[1] does not.
Is there any reason for the "ORDER BY id" in the "pgr_withPointsDD"[2]
function?
(see examples below)
Best regards,
Jakob
[1] http://docs.pgrouting.org/latest/en/pgr_drivingDistance.html
[2] http://docs.pgrouting.org/latest/en/pgr_withPointsDD.html
Examples:
SELECT * FROM pgr_drivingDistance(
'SELECT id, source, target, cost, reverse_cost FROM edge_table',
2, 3
);
SELECT * FROM pgr_withPointsDD(
'SELECT id, source, target, cost, reverse_cost FROM edge_table
ORDER BY id',
'SELECT pid, edge_id, fraction, side from pointsOfInterest',
-1, 3.8,
driving_side := 'l',
details := true);
More information about the Pgrouting-users
mailing list