use address counts for improving index lookup

[nominatim.git] / nominatim / api / search / db_searches.py

diff --git a/nominatim/api/search/db_searches.py b/nominatim/api/search/db_searches.py
index 6631c7cb522ceef2f02fa9173660e4dbfa043058..3f294de7c925ba5b2017bfd247496ef2c28c189c 100644 (file)
--- a/nominatim/api/search/db_searches.py
+++ b/nominatim/api/search/db_searches.py
@@ -609,8 +609,11 @@ class PostcodeSearch(AbstractSearch):
                                                AND osm_type = 'R'"""))\
                              .where(p.c.country_code == row.country_code)\
                              .where(p.c.postcode == row.postcode)\
                                                AND osm_type = 'R'"""))\
                              .where(p.c.country_code == row.country_code)\
                              .where(p.c.postcode == row.postcode)\

-                             .where(_exclude_places(p))\

                              .limit(1)
                              .limit(1)

+
+            if details.geometry_output:
+                placex_sql = _add_geometry_columns(placex_sql, p.c.geometry, details)
+

             for prow in await conn.execute(placex_sql, _details_to_bind_params(details)):
                 result = nres.create_from_placex_row(prow, nres.SearchResult)
                 break
             for prow in await conn.execute(placex_sql, _details_to_bind_params(details)):
                 result = nres.create_from_placex_row(prow, nres.SearchResult)
                 break


@@ -618,8 +621,9 @@ class PostcodeSearch(AbstractSearch):
                 result = nres.create_from_postcode_row(row, nres.SearchResult)
 
             assert result
                 result = nres.create_from_postcode_row(row, nres.SearchResult)
 
             assert result

-            result.accuracy = row.accuracy
-            results.append(result)
+            if result.place_id not in details.excluded:
+                result.accuracy = row.accuracy
+                results.append(result)

 
         return results
 
 
         return results