From: marc tobias <mtmail@gmx.net>
Date: Sun, 21 Jul 2019 19:41:12 +0000 (+0200)
Subject: during TIGER import skip records with negative house number range
X-Git-Tag: v3.4.0~23^2
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/0e446590338927bf5251bc569b4e77d6c75a6b5f

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