changeset 4706:a38d846d9fd5

morphology difference: buffer common boundary polygon by 10cm to fix numerical problems leading to unexpected holes.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 16 Oct 2019 22:06:17 +0200
parents 901a74d866ac
children 6a0fa1e0224d
files pkg/octree/polygon.go
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/octree/polygon.go	Wed Oct 16 19:49:19 2019 +0200
+++ b/pkg/octree/polygon.go	Wed Oct 16 22:06:17 2019 +0200
@@ -51,10 +51,10 @@
   WHERE sr.bottleneck_id = $1
 )
 SELECT ST_AsBinary(
-  ST_intersection(
+  ST_Buffer(ST_intersection(
     (SELECT ST_Transform(area::geometry, $2::int) FROM joined WHERE date_info = $3::date),
     (SELECT ST_Transform(area::geometry, $2::int) FROM joined WHERE date_info = $4::date)
-  )
+  ), 0.1)
   ) AS area
 `
 )