From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 19 Sep 2013 21:42:15 +0000 (+0200)
Subject: restrict max admin_level when patching in tag changes into placex
X-Git-Tag: v2.2.0~17^2~22
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/e3aa2ea78772525bb875edf76169e9bba43942ef

restrict max admin_level when patching in tag changes into placex
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 09ff155c..5bbaad5b 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2251,7 +2251,7 @@ BEGIN
       country_code = NEW.country_code,
       parent_place_id = null,
       extratags = NEW.extratags,
-      admin_level = NEW.admin_level,
+      admin_level = CASE WHEN NEW.admin_level > 15 THEN 15 ELSE NEW.admin_level END,
       indexed_status = 2,    
       geometry = NEW.geometry
       where place_id = existingplacex.place_id;