<div dir="ltr">Ok guys.<div><br></div><div>I know how to do it using postgis... Thanks.</div><div><br></div><div>I was thinking that there was a function for that.</div><div><br></div><div>Thanks</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div>..<br><b><font face="'arial black', sans-serif">Omar Fernando Pessôa</font></b><br><a href="http://www.opessoa.info" target="_blank">http://www.opessoa.info</a><br>Desenvolvedor de sistemas<br>Programador C++</div></div></div></div>
<br><div class="gmail_quote">2016-03-08 17:00 GMT-03:00 <span dir="ltr"><<a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Pgrouting-users mailing list submissions to<br>
<a href="mailto:pgrouting-users@lists.osgeo.org">pgrouting-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:pgrouting-users-request@lists.osgeo.org">pgrouting-users-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:pgrouting-users-owner@lists.osgeo.org">pgrouting-users-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Pgrouting-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Fixed sequence routing. (Omar Fernando Pessôa)<br>
2. Re: Fixed sequence routing. (Andrea Nardelli)<br>
3. Re: Fixed sequence routing. (Stephen Woodbridge)<br>
4. Re: Fixed sequence routing. (Daniel Kastl)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 8 Mar 2016 11:59:35 -0300<br>
From: Omar Fernando Pessôa <<a href="mailto:omar.pessoa@gmail.com">omar.pessoa@gmail.com</a>><br>
To: <a href="mailto:pgrouting-users@lists.osgeo.org">pgrouting-users@lists.osgeo.org</a><br>
Subject: [pgrouting-users] Fixed sequence routing.<br>
Message-ID:<br>
<CAOikBm65TjKQjwc0m6jte=UBU07+Rmf=<a href="mailto:afzuH-njWqpvP_L1tQ@mail.gmail.com">afzuH-njWqpvP_L1tQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi guys, sorry about question...<br>
<br>
Does have some of pgrouting functions thats returns linestring dijkstra<br>
from sequenced nodes?<br>
<br>
for all itens on sequency<br>
accum linestring from dijkstra item, item+1<br>
<br>
<br>
Thanks.<br>
..<br>
*Omar Fernando Pessôa*<br>
<a href="http://www.opessoa.info" rel="noreferrer" target="_blank">http://www.opessoa.info</a><br>
Desenvolvedor de sistemas<br>
Programador C++<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160308/cdcb6d93/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160308/cdcb6d93/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Tue, 8 Mar 2016 16:40:36 +0100<br>
From: Andrea Nardelli <<a href="mailto:nrd.nardelli@gmail.com">nrd.nardelli@gmail.com</a>><br>
To: pgRouting users mailing list <<a href="mailto:pgrouting-users@lists.osgeo.org">pgrouting-users@lists.osgeo.org</a>><br>
Subject: Re: [pgrouting-users] Fixed sequence routing.<br>
Message-ID:<br>
<CAKiFJ3vZvnQLsuXWTxFOo88BiBA8XcDJ0kDDSEjLcb-1qD=_<a href="mailto:Eg@mail.gmail.com">Eg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hello,<br>
you can just do a JOIN on the edge id between the Dijkstra result and the<br>
edge table:<br>
<br>
SELECT seq, path_seq, node, edge, d.cost, agg_cost, the_geomFROM<br>
(SELECT * FROM pgr_dijkstra(<br>
'SELECT id, source, target, cost, reverse_cost FROM edge_table',<br>
2, 3<br>
)) as d, edge_tableWHERE d.edge=<a href="http://edge_table.id" rel="noreferrer" target="_blank">edge_table.id</a><br>
<br>
~Andrea<br>
<br>
<br>
<br>
2016-03-08 15:59 GMT+01:00 Omar Fernando Pessôa <<a href="mailto:omar.pessoa@gmail.com">omar.pessoa@gmail.com</a>>:<br>
<br>
> Hi guys, sorry about question...<br>
><br>
> Does have some of pgrouting functions thats returns linestring dijkstra<br>
> from sequenced nodes?<br>
><br>
> for all itens on sequency<br>
> accum linestring from dijkstra item, item+1<br>
><br>
><br>
> Thanks.<br>
> ..<br>
> *Omar Fernando Pessôa*<br>
> <a href="http://www.opessoa.info" rel="noreferrer" target="_blank">http://www.opessoa.info</a><br>
> Desenvolvedor de sistemas<br>
> Programador C++<br>
><br>
> _______________________________________________<br>
> Pgrouting-users mailing list<br>
> <a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160308/a7b0bc82/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160308/a7b0bc82/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Tue, 8 Mar 2016 11:27:35 -0500<br>
From: Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>><br>
To: <a href="mailto:pgrouting-users@lists.osgeo.org">pgrouting-users@lists.osgeo.org</a><br>
Subject: Re: [pgrouting-users] Fixed sequence routing.<br>
Message-ID: <<a href="mailto:56DEFD77.6090606@swoodbridge.com">56DEFD77.6090606@swoodbridge.com</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
And if you want to combine the edges into a single linestring you can<br>
union the edges together, with the caveat that the total path is not<br>
self intersecting.<br>
<br>
In general, we do not imbed functionality into pgRouting that can be<br>
easily done in PostGIS. We have supplied some pgsql utility functions<br>
that are mostly PostGIS stuff where there is a common function that<br>
everyone will need. But mostly try to avoid these.<br>
<br>
There are are lots of PostGIS tutorials around the web:<br>
<a href="https://www.google.com/search?q=postgis+tutorial&ie=utf-8&oe=utf-8" rel="noreferrer" target="_blank">https://www.google.com/search?q=postgis+tutorial&ie=utf-8&oe=utf-8</a><br>
<br>
That will get you started if you need some help in this area.<br>
<br>
Best regards,<br>
-Steve<br>
<br>
On 3/8/2016 10:40 AM, Andrea Nardelli wrote:<br>
> Hello,<br>
> you can just do a JOIN on the edge id between the Dijkstra result and<br>
> the edge table:<br>
><br>
> SELECT seq, path_seq, node, edge, d.cost, agg_cost, the_geom<br>
> FROM (SELECT * FROM pgr_dijkstra(<br>
> 'SELECT id, source, target, cost, reverse_cost FROM edge_table',<br>
> 2, 3<br>
> )) as d, edge_table<br>
> WHERE d.edge=<a href="http://edge_table.id" rel="noreferrer" target="_blank">edge_table.id</a><br>
><br>
> ~Andrea<br>
><br>
><br>
><br>
> 2016-03-08 15:59 GMT+01:00 Omar Fernando Pessôa <<a href="mailto:omar.pessoa@gmail.com">omar.pessoa@gmail.com</a><br>
> <mailto:<a href="mailto:omar.pessoa@gmail.com">omar.pessoa@gmail.com</a>>>:<br>
><br>
> Hi guys, sorry about question...<br>
><br>
> Does have some of pgrouting functions thats returns linestring<br>
> dijkstra from sequenced nodes?<br>
><br>
> for all itens on sequency<br>
> accum linestring from dijkstra item, item+1<br>
><br>
><br>
> Thanks.<br>
> ..<br>
> *Omar Fernando Pessôa*<br>
> <a href="http://www.opessoa.info" rel="noreferrer" target="_blank">http://www.opessoa.info</a><br>
> Desenvolvedor de sistemas<br>
> Programador C++<br>
><br>
> _______________________________________________<br>
> Pgrouting-users mailing list<br>
> <a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a> <mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Pgrouting-users mailing list<br>
> <a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
><br>
<br>
<br>
---<br>
This email has been checked for viruses by Avast antivirus software.<br>
<a href="https://www.avast.com/antivirus" rel="noreferrer" target="_blank">https://www.avast.com/antivirus</a><br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Wed, 9 Mar 2016 01:33:49 +0900<br>
From: Daniel Kastl <<a href="mailto:daniel@georepublic.de">daniel@georepublic.de</a>><br>
To: <a href="mailto:pgrouting-users@lists.osgeo.org">pgrouting-users@lists.osgeo.org</a><br>
Subject: Re: [pgrouting-users] Fixed sequence routing.<br>
Message-ID: <<a href="mailto:56DEFEED.4090301@georepublic.de">56DEFEED.4090301@georepublic.de</a>><br>
Content-Type: text/plain; charset=utf-8<br>
<br>
<br>
><br>
> There are are lots of PostGIS tutorials around the web:<br>
> <a href="https://www.google.com/search?q=postgis+tutorial&ie=utf-8&oe=utf-8" rel="noreferrer" target="_blank">https://www.google.com/search?q=postgis+tutorial&ie=utf-8&oe=utf-8</a><br>
><br>
> That will get you started if you need some help in this area.<br>
><br>
<br>
Not to forget the workshop, which also gives a practical example using<br>
OSM data:<br>
<a href="http://workshop.pgrouting.org/chapters/wrapper.html" rel="noreferrer" target="_blank">http://workshop.pgrouting.org/chapters/wrapper.html</a><br>
<br>
The single geometry Steve mentions is done in the workshop using<br>
ST_Makeline:<br>
<a href="http://workshop.pgrouting.org/chapters/geoserver.html" rel="noreferrer" target="_blank">http://workshop.pgrouting.org/chapters/geoserver.html</a><br>
<br>
Best regards,<br>
Daniel<br>
<br>
--<br>
Georepublic UG & Georepublic Japan<br>
eMail: <a href="mailto:daniel.kastl@georepublic.de">daniel.kastl@georepublic.de</a><br>
Web: <a href="https://georepublic.info" rel="noreferrer" target="_blank">https://georepublic.info</a><br>
<br>
<br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
------------------------------<br>
<br>
End of Pgrouting-users Digest, Vol 90, Issue 3<br>
**********************************************<br>
</blockquote></div><br></div>