From e2329c03fed8cdf56c19f6bfda7b16f3b2a5e3fc Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 3 Feb 2021 10:23:38 +0100 Subject: [PATCH] Revert "increase splitting for large geometries" This reverts commit 559fe513fa8ffa3a5bc3a7d07c252a872614c073. Increasing the splitting results in geometries where with rounding issues at the split points, so that contain operations do not work as expected anymore. Fixes #2137. --- sql/functions/utils.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/functions/utils.sql b/sql/functions/utils.sql index 0a49eef5..18d4211b 100644 --- a/sql/functions/utils.sql +++ b/sql/functions/utils.sql @@ -426,7 +426,7 @@ DECLARE geo RECORD; BEGIN -- 10000000000 is ~~ 1x1 degree - FOR geo IN select quad_split_geometry(geometry, 0.01, 20) as geom LOOP + FOR geo IN select quad_split_geometry(geometry, 0.25, 20) as geom LOOP RETURN NEXT geo.geom; END LOOP; RETURN; -- 2.39.5