From e66df16ecbaf5da3c57b206a12f98e2975d8a74b Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 29 Nov 2012 21:44:59 +0100 Subject: [PATCH] add web view for import_polygon_delete --- website/deletable.php | 103 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 103 insertions(+) create mode 100755 website/deletable.php diff --git a/website/deletable.php b/website/deletable.php new file mode 100755 index 00000000..8d3fa823 --- /dev/null +++ b/website/deletable.php @@ -0,0 +1,103 @@ +'name' as name, i.* from placex, import_polygon_delete i where placex.osm_id = i.osm_id and placex.osm_type = i.osm_type and placex.class = i.class and placex.type = i.type"; + $aPolygons = $oDB->getAll($sSQL); + if (PEAR::isError($aPolygons)) + { + failInternalError("Could not get small viewbox.", $sSQL, $aPolygons); + } + + +//var_dump($aPolygons); +?> + + + + + + + Nominatim Deleted Data + + + + + + + + +

Objects in this table have been deleted in OSM but are still in the Nominatim database.

+ + +"; +//var_dump($aPolygons[0]); + foreach($aPolygons[0] as $sCol => $sVal) + { + echo ""; + } + echo ""; + foreach($aPolygons as $aRow) + { + echo ""; + foreach($aRow as $sCol => $sVal) + { + switch($sCol) + { + case 'osm_id': + $sOSMType = ($aRow['osm_type'] == 'N'?'node':($aRow['osm_type'] == 'W'?'way':($aRow['osm_type'] == 'R'?'relation':''))); + echo ''; + break; + case 'place_id': + echo ''; + break; + default: + echo ""; + break; + } + } + echo ""; + } +?> +
".$sCol."
'.$sVal.''.$sVal.'".($sVal?$sVal:' ')."
+ + + + + -- 2.39.5