From: Sarah Hoffmann <lonvia@denofr.de>
Date: Tue, 28 Mar 2023 12:57:39 +0000 (+0200)
Subject: ignore broken data in interpolation table
X-Git-Tag: v4.3.0~86^2~5
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/e158017086fd538d28264522a48daa51f8236dc3?hp=36d068871da6921f6f2a7cd81df393f4fa3661a9

ignore broken data in interpolation table
---

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)