'name' as name, i.* from placex, import_polygon_delete i";
$sSQL .= " where placex.osm_id = i.osm_id and placex.osm_type = i.osm_type";
$sSQL .= " and placex.class = i.class and placex.type = i.type";
$aPolygons = chksql($oDB->getAll($sSQL), "Could not get list of deleted OSM elements.");
if (CONST_Debug) {
var_dump($aPolygons);
exit;
}
?>
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 "| ".$sCol." | ";
}
echo "";
foreach ($aPolygons as $aRow) {
echo "";
foreach ($aRow as $sCol => $sVal) {
switch ($sCol) {
case 'osm_id':
echo '| '.osmLink($aRow).' | ';
break;
case 'place_id':
echo ''.detailsLink($aRow).' | ';
break;
default:
echo "".($sVal?$sVal:' ')." | ";
break;
}
}
echo "
";
}
?>