From 287ba2570e288f9dce46771d99624f4e3d139789 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 8 Jul 2025 13:50:20 +0200 Subject: [PATCH] reduce area for geometry rank for very small countries --- lib-sql/functions/ranking.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/lib-sql/functions/ranking.sql b/lib-sql/functions/ranking.sql index c16ad1db..cee72fcb 100644 --- a/lib-sql/functions/ranking.sql +++ b/lib-sql/functions/ranking.sql @@ -88,6 +88,10 @@ BEGIN area := area / 3; ELSIF country_code IN ('bo', 'ar', 'sd', 'mn', 'in', 'et', 'cd', 'mz', 'ly', 'cl', 'zm') THEN area := area / 2; + ELSIF country_code IN ('sg', 'ws', 'st', 'kn') THEN + area := area * 5; + ELSIF country_code IN ('dm', 'mt', 'lc', 'gg', 'sc', 'nr') THEN + area := area * 20; END IF; IF area > 1 THEN -- 2.39.5