[pgrouting-users] create geometry table with the result

[James David Smith]

Pedro,

Daniel is right. This should do it?

SELECT * INTO new_table
   FROM passeios
   JOIN
   (SELECT * FROM shortest_path('
      SELECT gid AS id,
          start_id::int4 AS source,
          end_id::int4 AS target,
          lenght::float8 AS cost
      FROM passeios',
      438,
      439,
      false,
      false)) AS route
   ON
   network.gid = route.edge_id;

James


On 16 March 2012 10:16, Daniel Kastl <daniel at georepublic.de> 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> 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 list
>> 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
>>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>