Only use placex that are fully indexed for reverse geocoding

diff --git a/website/reverse.php b/website/reverse.php
index fda11582b23abe2ed30a2ac29dcf0447467d9d77..f6925846a172c75012f80b90316147b7034e1bb5 100755 (executable)
--- 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 (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);
                        $sSQL .= ' OR ST_DWithin('.$sPointSQL.', centroid, '.$fSearchDiam.'))';
                        $sSQL .= ' ORDER BY ST_distance('.$sPointSQL.', geometry) ASC limit 1';
                        if (CONST_Debug) var_dump($sSQL);