From ceeaf77f697976960b11619a821ef5f6430906ec Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 28 Jun 2012 20:39:18 +0200 Subject: [PATCH] ignore railways, tunnels and bridges when reverse geocoding --- website/reverse.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/website/reverse.php b/website/reverse.php index 253b84a5..bbad4a44 100755 --- a/website/reverse.php +++ b/website/reverse.php @@ -111,7 +111,7 @@ $sSQL .= ' WHERE ST_DWithin('.$sPointSQL.', geometry, '.$fSearchDiam.')'; $sSQL .= ' and rank_search != 28 and rank_search >= '.$iMaxRank; $sSQL .= ' and (name is not null or housenumber is not null)'; - $sSQL .= ' and class not in (\'waterway\')'; + $sSQL .= ' and class not in (\'waterway\',\'railway\',\'tunnel\',\'bridge\')'; $sSQL .= ' and (ST_GeometryType(geometry) not in (\'ST_Polygon\',\'ST_MultiPolygon\') '; $sSQL .= ' OR ST_DWithin('.$sPointSQL.', ST_Centroid(geometry), '.$fSearchDiam.'))'; $sSQL .= ' ORDER BY ST_distance('.$sPointSQL.', geometry) ASC limit 1'; -- 2.39.5