[pgrouting-users] Re: Many errors : function driving_distance does not exist, shortest_path_astar , tps

[Jules Kouadio]

Thank you so mutch ! All is running !
I see that my request was not correctly wrotte .
How can i now visualyse all this result on a map (on a  web map server).
Do you have a good tutorial, step by step, whith all details ?

Thanks again


2011/8/22 Daniel Kastl <daniel at georepublic.de>

> Hi Jules,
>
> Here are working examples of your queries:
>
> SELECT * FROM shortest_path_astar(
>     'SELECT gid AS id,source::integer,target::integer,length::double
> precision AS cost,x1,y1,x2,y2 FROM ways',
>     300,400,false,false
> );
>
> SELECT * FROM driving_distance(
>     'SELECT gid AS id,source,target,length::double precision AS cost FROM
> ways',
>     300,1.0,false,false
> );
>
> SELECT * FROM tsp(
>     'SELECT DISTINCT source AS source_id,x1::double precision as
> x,y1::double precision AS y FROM ways WHERE source IN(91,35,75,504,254)',
>     '91,35,75,504,254',75
> );
>
> Best regards,
> Daniel
>
>
> On Tue, Aug 23, 2011 at 12:08 AM, Jules Kouadio <sekedoua at gmail.com>wrote:
>
>> This is all my databse (routing).
>> Please look at this.
>>
>>
>>
>> 2011/8/22 Jules Kouadio <sekedoua at gmail.com>
>>
>>> Hello Danniel. Thanks again for your support. I progress but i have so
>>> much to learn.
>>>
>>> why this error for this 3 request ?*
>>>
>>> SELECT * from driving_distance('select gid as
>>> id,source,target,length::double precision as cost from ways',22777838,0.01);
>>> *
>>>
>>> ERROR: function driving_distance ("unknown", integer, numeric) does not
>>> exist
>>> HINT: No function matches the given name and argument types. You need to
>>> add explicit type conversions.
>>>
>>> *SELECT * FROM shortest_path_astar('select gid as
>>> id,source::int4,target::int4,reverse_cost::double precision as
>>> reverse_cost,x1,y1,x2,y2 from ways',22,150,false,false);*
>>> ERREUR:  Error, query must return columns 'id', 'source', 'target' and
>>> 'cost'
>>>
>>>
>>> *SELECT * from tsp('select distinct source as source_id,x1::double
>>> precision as x,y1::double precision as y from ways where source
>>> in(91,35,75,504,254)','91,35,75,504,254',353);*
>>>
>>> WARNING: stop the connection because of crash of another server process
>>> DETAIL: The postmaster has commanded this server process to cancel the
>>> transaction
>>> Current and leave because another process server left abnormally
>>> and there is probably corrupted shared memory.
>>> TIP: In a moment you should be able to reconnect to the base of
>>> data and restart your order.
>>> the server connection was cut off unexpectedly
>>>          The server may have terminated abnormally before or during
>>>          processing the request.
>>> The server connection was lost. Attempting reset: success / or sometimes
>>> not.
>>>
>>>
>>>
>>> I don't understand why all thes errors becose shortest_path function run
>>> correctly. Exple
>>>
>>> SELECT * FROM shortest_path('SELECT gid as
>>> id,source::integer,target::integer,length::double precision as cost FROM
>>> ways',300,400, false, false); give to me :
>>>
>>>  vertex_id | edge_id |        cost
>>> -----------+---------+--------------------
>>>        300 |     339 |  0.139255214687805
>>>        299 |     338 |  0.179544765048058
>>>        195 |     337 |  0.203993410356029
>>>         63 |      56 |  0.163071365291157
>>>         64 |      57 | 0.0210195901922476
>>>         13 |     592 |  0.154135925931186
>>>        353 |     593 |  0.167432867084967
>>>        255 |     594 | 0.0922310799956524
>>>        111 |     595 |  0.410249680272814
>>>        435 |     596 |  0.323252439058039
>>>        400 |      -1 |                  0
>>> (11 lignes)
>>>
>>> My table "ways" is join.
>>>
>>>
>>>
>>> Thanks !
>>> --
>>> *
>>> *
>>>
>>>
>>>
>>
>>
>> --
>> *
>> *
>>
>>
>>
>
>
> --
> 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
>
>


-- 
*
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110822/34dc23c5/attachment.html