From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 11 May 2022 14:24:47 +0000 (+0200)
Subject: Merge pull request #2709 from lonvia/less-strict-country-assignment
X-Git-Tag: v4.1.0~42
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/2d1a22705f7f2f067f2c839c32caf55941a37b01?hp=a7a5f0161f27833513b81466fd5d4c57cd7ee4d4

Merge pull request #2709 from lonvia/less-strict-country-assignment

Be more strict with country assignments
---

diff --git a/lib-sql/functions/utils.sql b/lib-sql/functions/utils.sql
index d7fdae3d..ad262670 100644
--- a/lib-sql/functions/utils.sql
+++ b/lib-sql/functions/utils.sql
@@ -170,15 +170,6 @@ BEGIN
 
 -- RAISE WARNING 'near osm fallback: %', ST_AsText(place_centre);
 
-  -- 
-  FOR nearcountry IN
-    SELECT country_code from country_osm_grid
-    WHERE st_dwithin(geometry, place_centre, 0.5)
-    ORDER BY st_distance(geometry, place_centre) asc, area asc limit 1
-  LOOP
-    RETURN nearcountry.country_code;
-  END LOOP;
-
   RETURN NULL;
 END;
 $$