From 229ad01042bb93d834e5f1459a738ce0d1f895aa Mon Sep 17 00:00:00 2001 From: gemo1011 Date: Thu, 21 Jun 2018 13:26:04 +0200 Subject: [PATCH] added search diameter for the place node search, depending on rank --- lib/ReverseGeocode.php | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/lib/ReverseGeocode.php b/lib/ReverseGeocode.php index 91a043da..bceb59be 100644 --- a/lib/ReverseGeocode.php +++ b/lib/ReverseGeocode.php @@ -150,6 +150,15 @@ class ReverseGeocode $iRankSearch = $aPoly['rank_search']; $iPlaceID = $aPoly['place_id']; + //search diameter for the place node search + if ($iMaxRank <= 30) $fSearchDiam = 0.1; + if ($iMaxRank <= 18) $fSearchDiam = 0.2; + if ($iMaxRank <= 17) $fSearchDiam = 0.6; + if ($iMaxRank <= 12) $fSearchDiam = 0.8; + if ($iMaxRank <= 10) $fSearchDiam = 1; + if ($iMaxRank <= 8) $fSearchDiam = 2; + if ($iMaxRank <= 4) $fSearchDiam = 4; + if ($iRankAddress != $iMaxRank) { $sSQL = 'SELECT *'; $sSQL .= ' FROM ('; @@ -166,6 +175,7 @@ class ReverseGeocode $sSQL .= ' AND rank_address > '.$iRankAddress; $sSQL .= ' AND rank_address <= ' .Min(25, $iMaxRank); } + $sSQL .= ' AND ST_DWithin('.$sPointSQL.', geometry, '.$fSearchDiam.')'; $sSQL .= ' AND type != \'postcode\''; $sSQL .= ' AND name IS NOT NULL '; $sSQL .= ' and indexed_status = 0 and linked_place_id is null'; -- 2.39.5