[pgrouting-users] Build the "right" direction in a network, from a fixed starting point

andy aborruso at gmail.com
Thu May 17 03:11:56 PDT 2018


On Thu, 17 May 2018 at 12:07, Vicky Vergara <vicky at georepublic.de> wrote:

> So, one thing is the direction of the geometry which is a matter of
> postGIS, another is graph logic
> for the edge circled green if the geometry is "backwards" that is one
> thing, you fix with postGIS,
> I dont know your data, but suppose
> id = 1, source = A, target = B, cost > 0, reverse_cost = -1 and that
> vertex A is not reachable
> then "manually" would be:
> UPDATE TABLE foo set source = target, target = source WHERE source IS IN
> (<set of unreachable vertices>)
>
>
Great, I will try!!

-- 
___________________

Andrea Borruso
website: https://medium.com/tantotanto
38° 7' 48" N, 13° 21' 9" E, EPSG:4326
___________________

"cercare e saper riconoscere chi e cosa,
 in mezzo all’inferno, non è inferno,
e farlo durare, e dargli spazio"

Italo Calvino
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20180517/bc65abe1/attachment.html>


More information about the Pgrouting-users mailing list