From 0e446590338927bf5251bc569b4e77d6c75a6b5f Mon Sep 17 00:00:00 2001
From: marc tobias <mtmail@gmx.net>
Date: Sun, 21 Jul 2019 21:41:12 +0200
Subject: [PATCH] during TIGER import skip records with negative house number
 range

---
 sql/tiger_import_start.sql | 5 +++++
 1 file changed, 5 insertions(+)

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
-- 
2.43.2