'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 = 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 "
";
}
?>