[pgrouting-users] Pgrouting-users Digest, Vol 90, Issue 3

Omar_Fernando_Pessoa · March 8, 2016, 8:10pm

Ok guys.

I know how to do it using postgis… Thanks.

I was thinking that there was a function for that.

Thanks

···

2016-03-08 17:00 GMT-03:00 <pgrouting-users-request@lists.osgeo.org>:

Send Pgrouting-users mailing list submissions to
pgrouting-users@lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/mailman/listinfo/pgrouting-users
or, via email, send a message with subject or body ‘help’ to
pgrouting-users-request@lists.osgeo.org

You can reach the person managing the list at
pgrouting-users-owner@lists.osgeo.org

When replying, please edit your Subject line so it is more specific
than “Re: Contents of Pgrouting-users digest…”

Today’s Topics:

Fixed sequence routing. (Omar Fernando Pessôa)

Re: Fixed sequence routing. (Andrea Nardelli)

Re: Fixed sequence routing. (Stephen Woodbridge)

Re: Fixed sequence routing. (Daniel Kastl)

Message: 1
Date: Tue, 8 Mar 2016 11:59:35 -0300
From: Omar Fernando Pessôa <omar.pessoa@gmail.com>
To: pgrouting-users@lists.osgeo.org
Subject: [pgrouting-users] Fixed sequence routing.
Message-ID:
<CAOikBm65TjKQjwc0m6jte=UBU07+Rmf=afzuH-njWqpvP_L1tQ@mail.gmail.com>
Content-Type: text/plain; charset=“utf-8”

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++
-------------- next part --------------
An HTML attachment was scrubbed…
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160308/cdcb6d93/attachment-0001.html>

Message: 2
Date: Tue, 8 Mar 2016 16:40:36 +0100
From: Andrea Nardelli <nrd.nardelli@gmail.com>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Fixed sequence routing.
Message-ID:
<CAKiFJ3vZvnQLsuXWTxFOo88BiBA8XcDJ0kDDSEjLcb-1qD=_Eg@mail.gmail.com>
Content-Type: text/plain; charset=“utf-8”

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_geomFROM
(SELECT * FROM pgr_dijkstra(
‘SELECT id, source, target, cost, reverse_cost FROM edge_table’,
2, 3
)) as d, edge_tableWHERE 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

-------------- next part --------------
An HTML attachment was scrubbed…
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160308/a7b0bc82/attachment-0001.html>

Message: 3
Date: Tue, 8 Mar 2016 11:27:35 -0500
From: Stephen Woodbridge <woodbri@swoodbridge.com>
To: pgrouting-users@lists.osgeo.org
Subject: Re: [pgrouting-users] Fixed sequence routing.
Message-ID: <56DEFD77.6090606@swoodbridge.com>
Content-Type: text/plain; charset=utf-8; format=flowed

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](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](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

Message: 4
Date: Wed, 9 Mar 2016 01:33:49 +0900
From: Daniel Kastl <daniel@georepublic.de>
To: pgrouting-users@lists.osgeo.org
Subject: Re: [pgrouting-users] Fixed sequence routing.
Message-ID: <56DEFEED.4090301@georepublic.de>
Content-Type: text/plain; charset=utf-8

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

Subject: Digest Footer

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

End of Pgrouting-users Digest, Vol 90, Issue 3

…
Omar Fernando Pessôa
http://www.opessoa.info
Desenvolvedor de sistemas
Programador C++