'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 list of deleted OSM elements.", $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 "| ".$sCol." | ";
}
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 '| '.$sVal.' | ';
break;
case 'place_id':
echo ''.$sVal.' | ';
break;
default:
echo "".($sVal?$sVal:' ')." | ";
break;
}
}
echo "
";
}
?>