From 93b1089866cbfd4e639c4a6f9db9e6ea612a827f Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Wed, 8 May 2013 12:16:45 +0100 Subject: [PATCH] Only use placex that are fully indexed for reverse geocoding --- website/reverse.php | 1 + 1 file changed, 1 insertion(+) 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); -- 2.39.5