[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