[pgrouting-users] Fixed sequence routing.

[Stephen Woodbridge]

And if you want to combine the edges into a single linestring you can 
union the edges together, with the caveat that the total path is not 
self intersecting.

In general, we do not imbed functionality into pgRouting that can be 
easily done in PostGIS. We have supplied some pgsql utility functions 
that are mostly PostGIS stuff where there is a common function that 
everyone will need. But mostly try to avoid these.

There are are lots of PostGIS tutorials around the web:
https://www.google.com/search?q=postgis+tutorial&ie=utf-8&oe=utf-8

That will get you started if you need some help in this area.

Best regards,
   -Steve

On 3/8/2016 10:40 AM, Andrea Nardelli wrote:
> Hello,
> you can just do a JOIN on the edge id between the Dijkstra result and
> the edge table:
>
> SELECT  seq,  path_seq,  node,  edge,  d.cost,  agg_cost,  the_geom
> FROM  (SELECT  *  FROM  pgr_dijkstra(
>        'SELECT id, source, target, cost, reverse_cost FROM edge_table',
>        2,  3
>    ))  as  d,  edge_table
> WHERE  d.edge=edge_table.id
>
> ~Andrea
>
>
>
> 2016-03-08 15:59 GMT+01:00 Omar Fernando Pessôa <omar.pessoa at gmail.com
> <mailto:omar.pessoa at gmail.com>>:
>
>     Hi guys, sorry about question...
>
>     Does have some of pgrouting functions thats returns linestring
>     dijkstra from sequenced nodes?
>
>     for all itens on sequency
>        accum linestring from dijkstra item, item+1
>
>
>     Thanks.
>     ..
>     *Omar Fernando Pessôa*
>     http://www.opessoa.info
>     Desenvolvedor de sistemas
>     Programador C++
>
>     _______________________________________________
>     Pgrouting-users mailing list
>     Pgrouting-users at lists.osgeo.org <mailto:Pgrouting-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus