[pgrouting-users] Shortest Path TRSP
"Christophe Damour (SIGéal)"
sigeal at sigeal.com
Tue Feb 28 02:25:38 EST 2012
Hi,
Thank you very much for all the helpfull answers...
I finally worked it out by casting id_tron to integer (id_tron::integer
as id) in the query passed to turn_restrict_shortest_path function.
(type of id_tron column is numeric...).
May this should raise an error message ?
Another question : I am testing this on a vps running Ubuntu Natty, but
my development box is a windows 7 64 one.
Is it possible to get pgRouting trsp branch binaries for windows
(compiling for windows seems somewhat complicated) ?
Kind regards,
--
Christophe
Le 27/02/2012 23:07, Stephen Woodbridge a écrit :
> If you think it is a bug, I'm happy to take a look at it, but ideally
> you should try to reduce the problem to a small graph that is
> reproducable.
>
> -Steve
>
> On 2/27/2012 5:01 PM, Max Weninger wrote:
>> Hi again
>>
>> Ok this is strange. Since the soure vertex is already
>> checked before the trsp is called. The message you
>> described comes directly from the C++ impl. of trsp
>> where it is checked again
>>
>> Does the values of your source and target columns start from 0?
>> Since if this is not the case some "renumbering" is done internally
>> Maybe there is a bug.
>>
>> Regards
>>
>> max
>>
>> On Mon, 27 Feb 2012 22:55:22 +0100
>> Max Weninger<max.weninger at gmail.com> wrote:
>>
>>> Hi
>>>
>>> The message "Source not Found" says that trsp
>>> has not found the source node in the table reseau_global
>>> Are you sure there is a node 15326?
>>>
>>> Regards
>>>
>>> max
>>>
>>> On Mon, 27 Feb 2012 22:42:04 +0100
>>> "Christophe Damour (SIGéal)"<sigeal at sigeal.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I am trying to use trsp shortest path function, but get a "Source
>>>> Not Found" error.
>>>> Here is my query :
>>>> SELECT edge_id FROM turn_restrict_shortest_path(
>>>> 'SELECT id_tron as id, source::integer, target::integer,
>>>> cost::double precision as cost, rev_cost::double precision
>>>> as reverse_cost FROM reseau_global',
>>>> 15326,
>>>> 8756,
>>>> true,
>>>> true,
>>>> 'SELECT to_cost::double precision, target_id::integer,
>>>> via_path::text FROM reseau_global_rest'
>>>> ), reseau_global
>>>> WHERE edge_id = id_tron;
>>>>
>>>> reseau_global is my network table, and reseau_global_rest is my
>>>> turn restriction table.
>>>> In the latter, target_id column contains destination edges ids and
>>>> via_path a list of forbidden origin edges.
>>>>
>>>> What am I doing wrong ?
>>>>
>>>> Thank for any hints,
>>>>
>>>
>>
>> _______________________________________________
>> 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
More information about the Pgrouting-users
mailing list