connect();
$sSQL = 'select placex.place_id, country_code,';
$sSQL .= " name->'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 = $oDB->getAll($sSQL, null, '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 '
';
}
?>