[pgrouting-users] Fixed sequence routing.

pgRouting pgrouting-users
1

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++

2

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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

3

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@gmail.com
<mailto:omar.pessoa@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@lists.osgeo.org <mailto:Pgrouting-users@lists.osgeo.org>
    http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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

4

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.

Not to forget the workshop, which also gives a practical example using
OSM data:
http://workshop.pgrouting.org/chapters/wrapper.html

The single geometry Steve mentions is done in the workshop using
ST_Makeline:
http://workshop.pgrouting.org/chapters/geoserver.html

Best regards,
Daniel

--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: https://georepublic.info