Openlayers/pgRouting

NerfNerder · 18-04-2010 9:50pm #1

I am trying to implement a routing application using openlayers and pgrouting. I am almost finished, however I cannot execute the final step. Basically I am using a php file to connect to the database, do the routing algorithm and give me back the points neededfor the routing in an xml file. That works fine. I then have a second file containing the map, and some javascript. Howeverthe function I am trying to use to read the xml just does not work. I have no idea why. Here is my code:

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">
#map {
width: 800px;
height: 450px;
border: 1px solid black;
}

</style>

<script src="http://www.openlayers.org/api/OpenLayers.js"></script>
<script src="http://www.openstreetmap.org/openlayers/OpenStreetMap.js"></script>
<script src="MapTest2.php?startpoint="+inverseMercator(startPoint.geometry.x,startPoint.geometry.y)+"&finalpoint="+inverseMercator(stopPoint.geometry.x,stopPoint.geometry.y)+"&srid=4326&plon="+lon+"&plat="+lat type="text/xml"></script>
<script type="text/javascript">

</script>

</head>
<body onload="init()">
<div id="map"></div>

<ul>
<li>
<input type="radio" name="control" id="noneToggle"
onclick="toggleControl(this);" checked="checked" />
<label for="noneToggle">navigate</label>
</li>
<li>
<input type="radio" name="control" value="start" id="startToggle"
onclick="toggleControl(this);" />
<label for="startToggle">set start point</label>
</li>
<li>
<input type="radio" name="control" value="stop" id="stopToggle"
onclick="toggleControl(this);" />
<label for="stopToggle">set stop point</label>
</li>
</ul>

<button onclick="compute()">Calculate Route</button>

</body>
</html>

<?php
ini_set('short_open_tag','Off');

// Database connection settings
define("PG_DB" , "routing");
define("PG_HOST", "localhost");
define("PG_PASS", "postgres");
define("PG_USER", "postgres");
define("PG_PORT", "5432");
define("TABLE", "ways");

// FUNCTION findNearestEdge
function findNearestEdge($lonlat) {

// Connect to database
$dbcon = pg_connect("dbname=".PG_DB." host=".PG_HOST." password=".PG_PASS." user=".PG_USER);

$sql = "SELECT gid, source, target, the_geom,
distance(the_geom, GeometryFromText(
'POINT(".$lonlat[0]." ".$lonlat[1].")', 4326)) AS dist
FROM ".TABLE."
WHERE the_geom && setsrid(
'BOX3D(".($lonlat[0]-200)."
".($lonlat[1]-200).",
".($lonlat[0]+200)."
".($lonlat[1]+200).")'::box3d, 4326)
ORDER BY dist LIMIT 1;";

$query = pg_query($dbcon,$sql);

$edge = pg_fetch_result($query, 0, 0);
$edge = pg_fetch_result($query, 0, 1);
$edge = pg_fetch_result($query, 0, 2);
$edge = pg_fetch_result($query, 0, 3);

// Close database connection
pg_close($dbcon);

return $edge;
}

//http://localhost:1980/routing2/ol_osm_routing/routing.php?startpoint=-720023.40608569%207055317.3361107&finalpoint=%22-722698.7020752%207058909.8764395%22

$counter = $pathlength = 0;

//?startpoint=-6.452029968261393 53.399780357200676&finalpoint=-6.443768764495955 53.395263954164655&method=SPD&srid=4326

if($_REQUEST!=null){

// Retrieve start point
$start = split(' ',$_REQUEST);

$startPoint = array($start[0], $start[1]);

// Retrieve end point
$end = split(' ',$_REQUEST);

$endPoint = array($end[0], $end[1]);

// Find the nearest edge
$startEdge = findNearestEdge($startPoint);

$endEdge = findNearestEdge($endPoint);

// Select the routing algorithm

$sql = "SELECT rt.gid, AsText(rt.the_geom) AS wkt,
length(rt.the_geom) AS length, ".TABLE.".id
FROM ".TABLE.",
(SELECT gid, the_geom
FROM dijkstra_sp_delta(
'".TABLE."',
".$startEdge.",
".$endEdge.",
3000)
) as rt
WHERE ".TABLE.".gid=rt.gid;";

// http://localhost:1980/routing2/ol_osm_routing/routing.php?startpoint=-6.45419%2053.40087&finalpoint=-6.44833%2053.40066

// Database connection and query
$dbcon = pg_connect("dbname=".PG_DB." host=".PG_HOST." password=".PG_PASS." user=".PG_USER);

$query = pg_query($dbcon,$sql);

$xml = "<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\"?>\n";

$xml .= "<route>\n";

// Add edges to XML file
while($edge=pg_fetch_assoc($query)) {

$pathlength += $edge;

$xml .= "\t<edge id='".++$counter."'>\n";
$xml .= "\t\t<id>".$edge."</id>\n";
$xml .= "\t\t<wkt>".$edge."</wkt>\n";
$xml .= "\t\t<length>".round(($pathlength/1000),3)."</length>\n";
$xml .= "\t</edge>\n";
}

$xml .= "</route>\n";

// Close database connection
pg_close($dbcon);
// Return routing result
header('Content-type: text/xml',true);

echo $xml;
}
?>

jozefvodny · 29-09-2010 3:07pm

hallo, i like to ask you if you solved your problem. I have the same one and have no idea how to solve it.

Openlayers/pgRouting

Comments