From 8138729aea652acd1c9148df9d9318cbfb9c4da2 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 9 Apr 2017 23:12:35 +0200 Subject: [PATCH] use centroid for near feature search on rank 30 Rank 30 has some very large geometries (peninsulas, time zones, etc.) for which a near feature search for the full geometry is too expensive, so do the search on the centroid only. --- sql/functions.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/sql/functions.sql b/sql/functions.sql index e6938866..1db32d1d 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1681,8 +1681,10 @@ BEGIN -- RAISE WARNING ' getNearFeatures(%,''%'',%,''%'')',NEW.partition, place_centroid, search_maxrank, isin_tokens; FOR location IN SELECT * from getNearFeatures(NEW.partition, - CASE WHEN NEW.rank_search >= 26 THEN NEW.geometry - ELSE place_centroid END, + CASE WHEN NEW.rank_search >= 26 + AND NEW.rank_search < 30 + THEN NEW.geometry + ELSE place_centroid END, search_maxrank, isin_tokens) LOOP -- 2.39.5