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
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