[pgrouting-users] Pgrouting-users Digest, Vol 90, Issue 3
Omar Fernando Pessôa
omar.pessoa at gmail.com
Tue Mar 8 12:10:06 PST 2016
Ok guys.
I know how to do it using postgis... Thanks.
I was thinking that there was a function for that.
Thanks
..
*Omar Fernando Pessôa*
http://www.opessoa.info
Desenvolvedor de sistemas
Programador C++
2016-03-08 17:00 GMT-03:00 <pgrouting-users-request at lists.osgeo.org>:
> Send Pgrouting-users mailing list submissions to
> pgrouting-users at 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 at lists.osgeo.org
>
> You can reach the person managing the list at
> pgrouting-users-owner at 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:
>
> 1. Fixed sequence routing. (Omar Fernando Pessôa)
> 2. Re: Fixed sequence routing. (Andrea Nardelli)
> 3. Re: Fixed sequence routing. (Stephen Woodbridge)
> 4. Re: Fixed sequence routing. (Daniel Kastl)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 8 Mar 2016 11:59:35 -0300
> From: Omar Fernando Pessôa <omar.pessoa at gmail.com>
> To: pgrouting-users at lists.osgeo.org
> Subject: [pgrouting-users] Fixed sequence routing.
> Message-ID:
> <CAOikBm65TjKQjwc0m6jte=UBU07+Rmf=
> afzuH-njWqpvP_L1tQ at 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 at gmail.com>
> To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
> Subject: Re: [pgrouting-users] Fixed sequence routing.
> Message-ID:
> <CAKiFJ3vZvnQLsuXWTxFOo88BiBA8XcDJ0kDDSEjLcb-1qD=_
> Eg at 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 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
> > 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 at swoodbridge.com>
> To: pgrouting-users at lists.osgeo.org
> Subject: Re: [pgrouting-users] Fixed sequence routing.
> Message-ID: <56DEFD77.6090606 at 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 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
>
>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 9 Mar 2016 01:33:49 +0900
> From: Daniel Kastl <daniel at georepublic.de>
> To: pgrouting-users at lists.osgeo.org
> Subject: Re: [pgrouting-users] Fixed sequence routing.
> Message-ID: <56DEFEED.4090301 at 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 at georepublic.de
> Web: https://georepublic.info
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
> ------------------------------
>
> End of Pgrouting-users Digest, Vol 90, Issue 3
> **********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160308/be23f16b/attachment.html>
More information about the Pgrouting-users
mailing list