[ka-Map-users] Adding kaRouting

[manu -]

Hey,

I've been working on the kaRouting implementation and i think i'm quite close to make it work. Now my problem is with the reference table, i mean te map i use to make the route.

When i set the two points in the map (start and end) I get the next message in the postgres log:

2008-10-08 17:29:10 CST ERROR:  operator does not exist: numeric | numeric at character 355
2008-10-08 17:29:10 CST HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2008-10-08 17:29:10 CST STATEMENT:  INSERT INTO kroute (the_geom, sessionid, date) SELECT Collect(GeometryN(the_geom,1)) As geom, 
	'' as id , current_date As dd  FROM carreteras 
	,(SELECT  * from shortest_path_astar('SELECT gid as id, source::int4,target::int4,
	 fnode_::double precision as cost, fnode_::double precision as reverse_cost, x1, y1, x2, y2 
	FROM carreteras', 793749.5713752315|1861607.3280653763,845607.87670508|1792815.6985461896 , false, false)) as foo where gid=foo.edge_id;

Hope someone can help me.

Thank you!

Manu

----------------------------------------
> Date: Sat, 4 Oct 2008 01:14:11 +0200
> From: lorenzo at ominiverdi.com
> CC: ka-map-users at lists.maptools.org
> Subject: Re: [ka-Map-users] Adding kaRouting
> 
> Manu,
> setting up kaRouting is nothing easy.
> user firebug to see what happens to your calls
> you'll probably have problems with your DB setup and you should read the 
> php error output.
> 
> ciao
> lorenzo
> 
> 
> manu - wrote:
>> Hello everyone!
>>
>> I'm trying to add the kaRouting functionality to my system, but i'm 
>> having some problems.
>>
>> At this moment i have installed pgrouting library for postgresql and 
>> adapted the database to use the library functions. I have modified the 
>> config.php file and added the kaRoute array with the next 
>> configuration with the default configuration. One of the problems i 
>> had is where to find the description of each field of the array, cause 
>> i'm having problems to set "costColumn" and "reverseCostColumn".
>>
>> Anyway, i have set the map for the route which contains the roads of 
>> the place represented in the map, but i don't know i the postgis table 
>> needs special columns to be recognized by kaRoute.
>>
>> When i set the Routing option in the system i can draw the begin and 
>> end flag, but i get no results on Firefox (it keeps on requesting the 
>> server (the tile_router.php file)) and a stack overflow in internet 
>> explorer 7.
>>
>> I'm using ka-map with postgresql/postgis as geo-database and mapserver.
>>
>> Thank you in advance for your help.
>>
>> Manu
>>
>> ------------------------------------------------------------------------
>> Juega a las preguntas de Live Quiz con tus contactos de Messenger 
>> ¡Empieza ahora! 
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> ka-Map-users mailing list
>> ka-Map-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/ka-map-users
>>   
> _______________________________________________
> ka-Map-users mailing list
> ka-Map-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/ka-map-users

_________________________________________________________________
Llega la nueva temporada. Consulta las nuevas tendencias en MSN Estilo
http://estilo.es.msn.com/moda/