From ff47f6f65dccf085fa859965445a06b2c23b8d4f Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 11 Oct 2020 12:29:49 +0200 Subject: [PATCH] when linking always check against original address rank --- sql/functions/placex_triggers.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql index 8c9cfae1..1f664a4a 100644 --- a/sql/functions/placex_triggers.sql +++ b/sql/functions/placex_triggers.sql @@ -211,7 +211,11 @@ BEGIN FOR linked_placex IN SELECT placex.* from placex WHERE make_standard_name(name->'name') = bnd_name - AND ((bnd.rank_address > 0 and placex.rank_address = bnd.rank_address) + AND ((bnd.rank_address > 0 + and bnd.rank_address = (compute_place_rank(placex.country_code, + 'N', placex.class, + placex.type, 15::SMALLINT, + false, placex.postcode)).address_rank) OR (bnd.rank_address = 0 and placex.rank_search = bnd.rank_search)) AND placex.osm_type = 'N' AND placex.rank_search < 26 -- needed to select the right index -- 2.39.5