X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/53c526c01d145ca27bc3bea298305e483272eb29..043f9d8298d911c2bc9839a4a4f7ebb22e893783:/sql/partition-functions.src.sql?ds=sidebyside diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql index cc11cf96..efb59542 100644 --- a/sql/partition-functions.src.sql +++ b/sql/partition-functions.src.sql @@ -96,7 +96,7 @@ BEGIN SELECT place_id, name_vector, address_rank, search_rank, ST_Distance(centroid, point) as distance, null as isguess FROM search_name_-partition- - WHERE name_vector @> isin_token + WHERE name_vector && isin_token AND ST_DWithin(centroid, point, 0.015) AND search_rank between 26 and 27 ORDER BY distance ASC limit 1 @@ -124,8 +124,8 @@ BEGIN SELECT place_id, name_vector, address_rank, search_rank, ST_Distance(centroid, point) as distance, null as isguess FROM search_name_-partition- - WHERE name_vector @> isin_token - AND ST_DWithin(centroid, point, 0.03) + WHERE name_vector && isin_token + AND ST_DWithin(centroid, point, 0.04) AND search_rank between 16 and 22 ORDER BY distance ASC limit 1 LOOP