[pgrouting-users] driving distance for multiple nodes
geoffdougherty at gmail.com
Fri Aug 29 07:41:19 PDT 2014
I’m new to postGis/pgRouting, and am trying to find driving distances to all nodes within a certain distance of a set of starting points/nodes.
I have some code (thanks to http://anitagraser.com/2011/05/13/catchment-areas-with-pgrouting-driving_distance/) that seems to work for a single point:
SELECT seq, id1 AS node, cost
'SELECT gid as id, source, target, length::float8 AS cost FROM roads',
7, 100000, false, false
However, I have a separate table containing a few hundred points (with lat, lon and geom) for which I need to identify driving distance to other points. Do I need to consider adding some additional join, or perhaps some python code to loop through the other table?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pgrouting-users