From: Sarah Hoffmann Date: Thu, 28 Jun 2012 18:39:18 +0000 (+0200) Subject: ignore railways, tunnels and bridges when reverse geocoding X-Git-Tag: v2.0.0~54 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/419f90ed75e91ddb06d4809bc07a580fe08874a3?ds=inline ignore railways, tunnels and bridges when reverse geocoding --- diff --git a/website/reverse.php b/website/reverse.php index b053d764..4cd95016 100755 --- a/website/reverse.php +++ b/website/reverse.php @@ -95,7 +95,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';