From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 25 Nov 2023 21:38:59 +0000 (+0100)
Subject: Merge remote-tracking branch 'upstream/master'
X-Git-Tag: deploy~34
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/d9639a98671786f74b2be7588f4af2405ea08a68?hp=8c82f6ceb3b77ebadc0bfc08422652902fc437a8

Merge remote-tracking branch 'upstream/master'
---

diff --git a/nominatim/api/search/db_searches.py b/nominatim/api/search/db_searches.py
index 41434f06..63da4c5d 100644
--- a/nominatim/api/search/db_searches.py
+++ b/nominatim/api/search/db_searches.py
@@ -296,7 +296,7 @@ class NearSearch(AbstractSearch):
             sql = sql.join(table, t.c.place_id == table.c.place_id)\
                      .join(tgeom,
                            table.c.centroid.ST_CoveredBy(
-                               sa.case((sa.and_(tgeom.c.rank_address < 9,
+                               sa.case((sa.and_(tgeom.c.rank_address > 9,
                                                 tgeom.c.geometry.is_area()),
                                         tgeom.c.geometry),
                                        else_ = tgeom.c.centroid.ST_Expand(0.05))))\