[pgrouting-users] driving distance for multiple nodes

Adam Lawrence alaw005 at gmail.com
Fri Aug 29 17:43:20 PDT 2014

Hi Geoff,

I am also new to this, but have been experimenting with the same sort of

My workings and particularly the "my_get_network_catchment.sql" function
which I have uploaded to https://github.com/alaw005/pgrouting_functions
might be helpful. The solution was to use a loop within a postgis function.


> Date: Fri, 29 Aug 2014 10:41:19 -0400
> From: "Dougherty, Geoff" <geoffdougherty at gmail.com>
> To: pgrouting-users at lists.osgeo.org
> Subject: [pgrouting-users] driving distance for multiple nodes
> Message-ID: <705E7660-B5D6-4848-BD8A-30692DBBEBCF at gmail.com>
> Content-Type: text/plain; charset="windows-1252"
> Hi, all.
> 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
>         FROM pgr_drivingDistance(
>                 '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...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20140830/7ac607d5/attachment.html>

More information about the Pgrouting-users mailing list