From c2d5303192c960b456b2d2ab4b6e14cead2042ac Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Mon, 17 Dec 2012 22:14:11 +0100 Subject: [PATCH] increase search radius for named roads alleviates symptoms of trac ticket #4719 --- sql/partitions.src.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/partitions.src.sql b/sql/partitions.src.sql index 324f35bb..8d5e8eff 100644 --- a/sql/partitions.src.sql +++ b/sql/partitions.src.sql @@ -178,7 +178,7 @@ BEGIN ST_Distance(centroid, point) as distance, null as isguess FROM search_name_-partition- WHERE name_vector @> ARRAY[isin_token] - AND ST_DWithin(centroid, point, 0.01) + AND ST_DWithin(centroid, point, 0.03) AND search_rank between 22 and 27 ORDER BY distance ASC limit 1 LOOP -- 2.39.5