From: Sarah Hoffmann Date: Wed, 25 Nov 2020 20:42:27 +0000 (+0100) Subject: Merge pull request #2075 from lonvia/filter-postcodes-from-location-area-large X-Git-Tag: v3.6.0~20 X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/1f07d63dc5a043c44faa478f418c38455cc6dd75?hp=c5d98effc0f5fcd8d154b0a3ba3fccd374445685 Merge pull request #2075 from lonvia/filter-postcodes-from-location-area-large Filter postcodes by search rank when adding to address list --- diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql index 1197b3b7..703c08af 100644 --- a/sql/partition-functions.src.sql +++ b/sql/partition-functions.src.sql @@ -47,6 +47,9 @@ BEGIN WHERE geometry && feature AND is_relevant_geometry(ST_Relate(geometry, feature), ST_GeometryType(feature)) AND rank_address < maxrank + -- Postcodes currently still use rank_search to define for which + -- features they are relevant. + AND not (rank_address in (5, 11) and rank_search > maxrank) GROUP BY place_id, keywords, rank_address, rank_search, isguess, postcode, centroid LOOP RETURN NEXT r;