Mercurial > gemma

changeset 4306:2336f75637d1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
sections: Use blown up axis as geometry. (Nicked from current stretches) As using the waterway area geometry just imposes another sources of errors (and failed on me repeatedly) this change eliminates these potential problems.
author Sascha Wilde <wilde@intevation.de>
date Mon, 02 Sep 2019 18:26:12 +0200
parents 0f467a839fe2
children e5a831ecd557
files pkg/imports/sec.go
diffstat 1 files changed, 4 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/sec.go	Mon Sep 02 18:01:45 2019 +0200
+++ b/pkg/imports/sec.go	Mon Sep 02 18:26:12 2019 +0200
@@ -103,10 +103,10 @@
 ) VALUES (
   $11,
   (SELECT r FROM r),
-  ISRSrange_area(
-    (SELECT axs FROM axs),
-    (SELECT ST_Collect(CAST(area AS geometry))
-       FROM waterway.waterway_area)),
+  ST_Transform(ISRSrange_area(
+      (SELECT axs FROM axs),
+      (SELECT ST_Buffer(axs, 150) FROM axs)),
+    4326),
   $12,
   $13,
   $14,