From 92c5d3b720908d8ae5c38aff00ec5dfa258eb6d9 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 18 Feb 2020 22:46:32 +0100 Subject: [PATCH] make sure that linked places are within a boundary This is a regression from previous code refactoring. Fixes #1684. --- sql/functions/placex_triggers.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql index d6ae8838..d247651e 100644 --- a/sql/functions/placex_triggers.sql +++ b/sql/functions/placex_triggers.sql @@ -226,7 +226,7 @@ BEGIN AND placex.rank_address = bnd.rank_address AND placex.osm_type = 'N' AND placex.rank_search < 26 -- needed to select the right index - AND st_covers(geometry, placex.geometry) + AND _st_covers(bnd.geometry, placex.geometry) LOOP --DEBUG: RAISE WARNING 'Found matching place node %', linkedPlacex.osm_id; RETURN linked_placex; -- 2.39.5