Mercurial > gemma

diff pkg/imports/sec.go @ 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 91cb4a7b1b13
children ca6a5f722471
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,