From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 10 Dec 2022 16:30:32 +0000 (+0100)
Subject: Merge pull request #2920 from lonvia/no-postcode-for-rivers
X-Git-Tag: v4.3.0~126
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/4efad0bb95024e2082f73b4ae33613ef8f6ebef3?hp=8a0b2dc0be914c8da8eab1359349151c5a4c6054

Merge pull request #2920 from lonvia/no-postcode-for-rivers

Do not assign postcodes to long linear features
---

diff --git a/lib-sql/functions/placex_triggers.sql b/lib-sql/functions/placex_triggers.sql
index a8fb9fcc..295b838e 100644
--- a/lib-sql/functions/placex_triggers.sql
+++ b/lib-sql/functions/placex_triggers.sql
@@ -1230,7 +1230,11 @@ BEGIN
     {% endif %}
   END IF;
 
-  IF NEW.postcode is null AND NEW.rank_search > 8 THEN
+  IF NEW.postcode is null AND NEW.rank_search > 8
+     AND (NEW.rank_address > 0
+          OR ST_GeometryType(NEW.geometry) not in ('ST_LineString','ST_MultiLineString')
+          OR ST_Length(NEW.geometry) < 0.02)
+  THEN
     NEW.postcode := get_nearest_postcode(NEW.country_code, NEW.geometry);
   END IF;