Mercurial > gemma

changeset 2911:a75c546ef498

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use buffer around axis for stretch area
author Tom Gottfried <tom@intevation.de>
date Tue, 02 Apr 2019 19:24:08 +0200
parents c8c7122047a2
children 93fa55bce126
files pkg/imports/st.go
diffstat 1 files changed, 7 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- 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,