From e158017086fd538d28264522a48daa51f8236dc3 Mon Sep 17 00:00:00 2001
From: Sarah Hoffmann <lonvia@denofr.de>
Date: Tue, 28 Mar 2023 14:57:39 +0200
Subject: [PATCH] ignore broken data in interpolation table

---
 nominatim/api/reverse.py | 1 +
 1 file changed, 1 insertion(+)

diff --git a/nominatim/api/reverse.py b/nominatim/api/reverse.py
index ef6d1041..f454a837 100644
--- a/nominatim/api/reverse.py
+++ b/nominatim/api/reverse.py
@@ -209,6 +209,7 @@ class ReverseGeocoder:
                         t.c.linegeo.ST_Distance(wkt).label('distance'),
                         t.c.linegeo.ST_LineLocatePoint(wkt).label('position'))\
                 .where(t.c.linegeo.ST_DWithin(wkt, distance))\
+                .where(t.c.startnumber != None)\
                 .order_by('distance')\
                 .limit(1)
 
-- 
2.39.5