From: Sarah Hoffmann <lonvia@denofr.de>
Date: Mon, 22 Jul 2019 21:30:06 +0000 (+0200)
Subject: Merge pull request #1430 from mtmail/exclude-negative-tiger-housenumber-ranges
X-Git-Tag: v3.4.0~23
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/de15d10f86d83f1ae44e8a42e901c4b58f9550a8?hp=55d414bd728845402556c8cf0166c8e6f6218169

Merge pull request #1430 from mtmail/exclude-negative-tiger-housenumber-ranges

during TIGER import skip records with negative house number range
---

diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql
index 5acb3e59..ef55e11c 100644
--- a/sql/tiger_import_start.sql
+++ b/sql/tiger_import_start.sql
@@ -26,6 +26,11 @@ BEGIN
     endnumber = in_startnumber;
   END IF;
 
+  IF startnumber < 0 THEN
+    RAISE WARNING 'Negative house number range (% to %) on %, %', startnumber, endnumber, in_street, in_isin;
+    RETURN 0;
+  END IF;
+
   numberrange := endnumber - startnumber;
 
   IF (interpolationtype = 'odd' AND startnumber%2 = 0) OR (interpolationtype = 'even' AND startnumber%2 = 1) THEN