From: Brian Quinion Date: Wed, 8 May 2013 11:16:45 +0000 (+0100) Subject: Only use placex that are fully indexed for reverse geocoding X-Git-Tag: v2.2.0~74 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/93b1089866cbfd4e639c4a6f9db9e6ea612a827f Only use placex that are fully indexed for reverse geocoding --- diff --git a/website/reverse.php b/website/reverse.php index fda11582..f6925846 100755 --- a/website/reverse.php +++ b/website/reverse.php @@ -100,6 +100,7 @@ $sSQL .= ' and (name is not null or housenumber is not null)'; $sSQL .= ' and class not in (\'waterway\',\'railway\',\'tunnel\',\'bridge\')'; $sSQL .= ' and (ST_GeometryType(geometry) not in (\'ST_Polygon\',\'ST_MultiPolygon\') '; + $sSQL .= ' and indexed_status = 0 '; $sSQL .= ' OR ST_DWithin('.$sPointSQL.', centroid, '.$fSearchDiam.'))'; $sSQL .= ' ORDER BY ST_distance('.$sPointSQL.', geometry) ASC limit 1'; if (CONST_Debug) var_dump($sSQL);