[pgrouting-users] Build the "right" direction in a network, from a fixed starting point
andy
aborruso at gmail.com
Sun May 20 02:43:48 PDT 2018
Hi Vicky,
On Sat, 19 May 2018 at 19:18, Vicky Vergara vicky at georepublic.de
<http://mailto:vicky@georepublic.de> wrote:
> I don't see your data, can you put the contents of the data
>
> The only similar thing as "data" I have is your interpretation of a table
> contents.
>
> This is the data:
>
> SELECT ogc_fid as id, source, target, st_length(wkb_geometry)
> as "cost" FROM linee;
>
> Here the output (I have added the geom)
id source target cost geom
1 1 2 1875.887941 SRID=32632;LINESTRING(526471.864222973
5083313.32108108,527988.654493243 5082209.55351351)
2 3 1 1551.56248159 SRID=32632;LINESTRING(525738.392871622
5081946.07351351,526471.864222973 5083313.32108108)
3 1 4 1506.74402482 SRID=32632;LINESTRING(526471.864222973
5083313.32108108,527803.506385135 5084018.30810811)
4 4 5 1208.08883443 SRID=32632;LINESTRING(527803.506385135
5084018.30810811,528985.605844594 5084267.54594595)
5 2 6 1447.12212188 SRID=32632;LINESTRING(527988.654493243
5082209.55351351,527020.187466217 5081134.27027027)
And this is an image generated from this data (my starting point is 1).
[image: immagine.png]
Thank you very much
--
___________________
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/20180520/8151743e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 29188 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20180520/8151743e/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: immagine.png
Type: image/png
Size: 18287 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20180520/8151743e/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: immagine.png
Type: image/png
Size: 16712 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20180520/8151743e/attachment-0005.png>
More information about the Pgrouting-users
mailing list