[pgrouting-users] create geometry table with the result

[Daniel Kastl]

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> 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> 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
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>
>
>
> _______________________________________________
> Pgrouting-users mailing listPgrouting-users at lists.osgeo.orghttp://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
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120316/1949217a/attachment.html