From 71429b91b40921acc9c4d059b3b8e2d5c53ef07a Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 15 Oct 2013 21:10:46 +0200 Subject: [PATCH] take non-admin boundaries out of address computation fixes #90 --- sql/functions.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/sql/functions.sql b/sql/functions.sql index 5bbaad5b..bc366f8b 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1123,7 +1123,11 @@ BEGIN return NULL; END IF; NEW.rank_search := NEW.admin_level * 2; - NEW.rank_address := NEW.rank_search; + IF NEW.type = 'administrative' THEN + NEW.rank_address := NEW.rank_search; + ELSE + NEW.rank_address := 0; + END IF; ELSEIF NEW.class = 'landuse' AND ST_GeometryType(NEW.geometry) in ('ST_Polygon','ST_MultiPolygon') THEN NEW.rank_search := 22; NEW.rank_address := NEW.rank_search; -- 2.39.5