demo (#22) - Error 'Invalid OGC WKT (too short)' from 'An Introduction to pgRouting with OpenLayers?' (#251) - Message List

Hi!

Thanks for the quick reply, again :) Now I am at work, so I can't check anything. I would be at home in about 2,3 hours. I am guessing you would be a sleep :), you live in USA, am I right? I am going to write whether I did it or not. I am really,really, really thankful for your help. Thanks a lot :)

Poul

Hi!

I manage to deal with the projection stuff :) Now everything in my database is all right. here is screen:

 http://img22.imageshack.us/img22/2484/dbase900913.jpg

I also had some other problems with php, but finally a manage I handled with them. But unfortunately now I have other problem. The rout that is drawing not exacly correct. here is some examples.

 http://img509.imageshack.us/img509/9250/routing.jpg

In the php file the method findingnearles looks like that:

  function findNearestEdge($lonlat) {
  	    // Connect to database
    $con = pg_connect("dbname=".PG_DB." host=".PG_HOST." user=".PG_USER);
	$lonlat1=$lonlat[0]-200;
	$lonlat2=$lonlat[1]-200;
	$lonlat3=$lonlat[0]+200;
	$lonlat4=$lonlat[1]+200;
    $sql = "SELECT gid, source, target, the_geom,
			 distance(the_geom, GeometryFromText(
                  'POINT(".$lonlat[0]." ".$lonlat[1].")', 900913)) AS dist
            FROM ".TABLE."
            WHERE the_geom && setsrid(
                  'BOX3D(".$lonlat1."
                         ".$lonlat2.",
                         ".$lonlat3."
                         ".$lonlat4.")'::box3d, 900913)
            ORDER BY dist LIMIT 1";
    $query = pg_query($con,$sql);
    $edge['gid']      = pg_fetch_result($query, 0, 0);
    $edge['source']   = pg_fetch_result($query, 0, 1);
    $edge['target']   = pg_fetch_result($query, 0, 2);
    $edge['the_geom'] = pg_fetch_result($query, 0, 3);
    // Close database connection
    pg_close($con);
    return $edge;
  }

Are there any parameters that I can change , that could help me ? Or maybe it is because of the shp that I have at the begging. I am not sure if for example road looks like this:

- road
* node
= the vector layer, found path
^ start point

*-------*---------------------------* ...end

and some click in the middle of the second road, like this

*-------*------------^--------------* ...end

then the roud on the map would looks like this

*-------*------------^==============* ...end

or maybe

*-------*============^==============* ...end

I hope you understand what I mean... Please help me understand all this stuff. I was hoping that it would be working like on the las example, for example something like that:

 http://demo.postlbs.org/openrouting/web/geobase.html

or

 http://demo.postlbs.org/openrouting/web/suuchi.html

And I am also trying to figure it out how come in the pages that I mentioned before when I click and hold the left mouse button I can move the map, but in may page there is an option 'navigate', and when it is checked I can move my page, I just input start or end point. Any ideas how can I get rid of the 'navigation' option an just have start and end points. Thanks a lot for your help...

Regards Paul