[pgrouting-users] driving distance for multiple nodes
alaw005 at gmail.com
Fri Aug 29 17:43:20 PDT 2014
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
> 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...
More information about the Pgrouting-users