# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1554225848 -7200
# Node ID a75c546ef49854cdad5e8275107846fb13510f5b
# Parent  c8c7122047a2284f061ff01016b9c10364863b44
Use buffer around axis for stretch area

diff -r c8c7122047a2 -r a75c546ef498 pkg/imports/st.go
--- a/pkg/imports/st.go	Tue Apr 02 18:59:26 2019 +0200
+++ b/pkg/imports/st.go	Tue Apr 02 19:24:08 2019 +0200
@@ -97,8 +97,9 @@
               $8::char(5),
               $9::char(5),
               $10::int)::isrs)
-    ) AS r
-)
+    ) AS r),
+axs AS (
+  SELECT ISRSrange_axis((SELECT r FROM r), $16::double precision) AS axs)
 INSERT INTO waterway.stretches (
   name,
   stretch,
@@ -110,10 +111,10 @@
 ) VALUES (
   $11,
   (SELECT r FROM r),
-  ISRSrange_area(
-    ISRSrange_axis((SELECT r FROM r), $16::double precision),
-    (SELECT ST_Collect(CAST(area AS geometry))
-      FROM waterway.waterway_area)),
+  ST_Transform(ISRSrange_area(
+      (SELECT axs FROM axs),
+      (SELECT ST_Buffer(axs, 10000) FROM axs)),
+    4326),
   $12,
   $13,
   $14,