[pgrouting-users] very hight costs

[Pedro Costa]

Thank you Steve.

But for now, i'm not using openlayers and so I'm searching examples with 
mapserver...

But it is a good example. I want implement one with more options....








On 06/11/2012 07:08 PM, Stephen Woodbridge wrote:
> This page is in error:
>
> http://www.pgrouting.org/docs/howto/mapserver.html
>
> The result of the dijkstra_sp() function returns a record set like:
>    vertex_id | edge_id | cost
> which does not contain a geometry column.
>
> To get the geometry column which is in your dourol table you need to 
> join the results back to that table, change you DATA statement to 
> something like:
>
> DATA "the_geom from (
> select b.the_geom, a.* from
>   (SELECT * FROM shortest_path('SELECT gid AS id, source::int4,
>              target::int4, length::double precision AS cost,
>         FROM dourol',3, 7, false, false)) as a
>   dourol b where a.edge_id=b.gid) AS
>               foo using unique gid using srid=-1"
>
> Also for what it is worth, if you are also using OpenLayers, I 
> typically write a simple PHP ajax handler to interact with postgresql 
> and format the results as XML or JSON then use an OpenLayers geometry 
> feature to display the route. This way I compute the route once and 
> can pan an zoom on the result in OpenLayers without having to requext 
> a new route until I want to change the route. Look at this page to get 
> some ideas:
>
> http://gis.imaptools.com/routing/leaddog/?zoom=11&lat=33.86651&lon=35.51184&layers=B0TTTF&start=35.493583%2033.826664&stop=35.565174%2033.864285&method=STS&lang=eng 
>
>
> -Steve W
>
> On 6/11/2012 1:59 PM, Pedro Costa wrote:
>> Thank you to all.
>> I resolved with a where statement but i also will try using '-1'.
>> I have another question, anybody know examples of using pgrouting with
>> mapserver?
>> Or know information about that....
>>
>> Thanks
>>
>>
>>
>>
>>
>>
>> On 06/11/2012 06:05 PM, Max Weninger wrote:
>>> Hi
>>>
>>> On Mon, 11 Jun 2012 11:03:33 -0400
>>> Stephen Woodbridge<woodbri at swoodbridge.com> wrote:
>>>> I'm pretty sure TRSP allows -1 for a cost and drops that edge
>>>> internally.
>>> Yes
>>> If you look at the code starting at line 361
>>>
>>> Edges are only "used" if>=0.0
>>>
>>> ...
>>> if(cur_edge.m_dCost>= 0.0)
>>> ...
>>> if(cur_edge.m_dReverseCost>= 0.0)
>>> ...
>>>
>>> Regards
>>>
>>> max
>>>
>>>> -Steve W
>>>>
>>>> On 6/11/2012 10:45 AM, James David Smith wrote:
>>>>> Hi Pedro,
>>>>>
>>>>> Could you someone temporarily remove the roads from the network
>>>>> instead? When you do the select statement to query your network, you
>>>>> could do a WHERE statement which ignores certain roads?
>>>>>
>>>>> Might not work, just thinking out loud....
>>>>>
>>>>> James
>>>>>
>>>>>
>>>>>
>>>>> On 11 June 2012 15:40, Pedro Costa<pedrocostaarma at sapo.pt> wrote:
>>>>>> Em 11-06-2012 15:38, Steve Horn escreveu:
>>>>>>> high cost (such as 99999999
>>>>>>
>>>>>> Hello Steve,
>>>>>>
>>>>>> With me the hight cost is a problem because my network have few
>>>>>> roads....
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>> _______________________________________________
>>> 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