[pgrouting-users] create geometry table with the result

[Pedro Costa]

Thanks Daniel, I understand now....:-)


On 16-03-2012 10:16, Daniel Kastl wrote:
> Hi Pedro,
>
> The "core" shortest path function only returns a list of edge id's 
> with costs.
> To include geometry information you need to link again to the original 
> table or just use one of the wrapper functions:
> http://workshop.pgrouting.org/chapters/shortest_path.html#wrapper
>
> Daniel
>
>
> On Fri, Mar 16, 2012 at 7:10 PM, Pedro Costa <pedrocostaarma at sapo.pt 
> <mailto:pedrocostaarma at sapo.pt>> wrote:
>
>     Thanks to Talin and James but the problem is that the new table
>     has no geometry. My difficulty is to give the table geometry. How
>     I do that?
>
>     thanks
>
>
>
>
>
>     On 16-03-2012 00:22, James David Smith wrote:
>>
>>     Hi,
>>
>>     Unless I'm missing something, you just need to change the first
>>     line to
>>
>>     SELECT * INTO new_table FROM shortest_path( ...... etc.
>>
>>     James
>>
>>     On 16 Mar 2012 00:14, "Pedro Costa" <pedrocostaarma at sapo.pt
>>     <mailto:pedrocostaarma at sapo.pt>> wrote:
>>
>>         Hello to all,
>>
>>         Can anybody help me to solve this problem:
>>
>>         I want to create a geometry table with the result of this query:
>>
>>
>>         SELECT * FROM shortest_path
>>         ('SELECT gid AS id,
>>         source::int4 AS source,
>>         target::int4 AS target,
>>         lenght::float8 AS cost
>>         FROM passeios',
>>         438,
>>         439,
>>         false,
>>         false)
>>
>>         someone know how I do that?
>>         thanks
>>         _______________________________________________
>>         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  <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
>     <mailto:Pgrouting-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> -- 
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de <mailto:daniel.kastl at georepublic.de>
> Web: http://georepublic.de <http://georepublic.de/>
>
>
> _______________________________________________
> 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/20120316/01e475d3/attachment.html