public static function findFromRouteNo($parish, $routeno)
{
$ROWs = array();
$result = pg_query("SELECT *,ST_AsGeoJSON(the_geom) AS geojson " . "FROM hampshire WHERE parish='{$parish}' " . " AND routeno='{$routeno}'");
while ($row = pg_fetch_array($result, null, PGSQL_ASSOC)) {
$rightofway = new RightOfWay();
$rightofway->loadFromRow($row);
$ROWs[] = $rightofway;
}
return $ROWs;
}
header("HTTP/1.1 400 Bad Request");
echo "Required information missing or email in invalid format";
}
break;
case "addMultiProblems":
$valid = false;
if (isset($cleaned["data"]) && $cleaned["data"] != "" && isset($cleaned["reporter_name"]) && $cleaned["reporter_name"] != "" && isset($cleaned["reporter_email"]) && filter_var($cleaned["reporter_email"], FILTER_VALIDATE_EMAIL)) {
$data = @simplexml_load_string(stripslashes($_POST["data"]));
if ($data) {
foreach ($data->annotation as $annotation) {
$attrs = $annotation->attributes();
if (isset($attrs["x"]) && isset($attrs["y"]) && isset($annotation->description) && isset($annotation->extras) && isset($annotation->extras->row_id)) {
$desc = pg_escape_string($annotation->description);
$type = isset($annotation->type) ? pg_escape_string($annotation->type) : "unknown";
$id = pg_escape_string($annotation->extras->row_id);
$rightofway = new RightOfWay($id);
if ($rightofway->isValid()) {
// Note attributes need to be cast to float
// otherwise this will not work
$rightofway->addProblem($desc, $type, $cleaned["reporter_name"], $cleaned["reporter_email"], (double) $attrs["x"], (double) $attrs["y"]);
}
}
}
}
} else {
header("HTTP/1.1 400 Bad Request");
echo "Unexpected format";
}
break;
case "getProblems":
if (isset($cleaned["id"])) {
