Mercurial > gemma

changeset 3560:ec1aec03676d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use waterway area as basis for section area
author Tom Gottfried <tom@intevation.de>
date Fri, 31 May 2019 16:54:09 +0200
parents c220ad7e61ed
children 453f15ba8030
files pkg/imports/sec.go
diffstat 1 files changed, 4 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/sec.go	Fri May 31 16:42:43 2019 +0200
+++ b/pkg/imports/sec.go	Fri May 31 16:54:09 2019 +0200
@@ -110,10 +110,10 @@
 ) VALUES (
   $11,
   (SELECT r FROM r),
-  ST_Transform(ISRSrange_area(
-      (SELECT axs FROM axs),
-      (SELECT ST_Buffer(axs, 1500) FROM axs)),
-    4326),
+  ISRSrange_area(
+    (SELECT axs FROM axs),
+    (SELECT ST_Collect(CAST(area AS geometry))
+       FROM waterway.waterway_area)),
   $12,
   $13,
   $14,