Mercurial > gemma

changeset 2248:cce158db02b0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Input area as multipolygons to generate area from stretch Doing so is more resilient against invalid geometries and gives more plausible results if tributaries are involved (i.e. does not include the adjacent area of the tributary in the result).
author Tom Gottfried <tom@intevation.de>
date Wed, 13 Feb 2019 16:48:52 +0100
parents e6fba449aa3c
children 35db2e11c966 23c03e2eaf4f
files pkg/imports/bn.go pkg/imports/st.go
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/bn.go	Wed Feb 13 16:41:00 2019 +0100
+++ b/pkg/imports/bn.go	Wed Feb 13 16:48:52 2019 +0100
@@ -64,7 +64,7 @@
   isrsrange(isrs_fromText($5), isrs_fromText($6)),
   ISRSrange_area(
     isrsrange(isrs_fromText($5), isrs_fromText($6)),
-    (SELECT ST_Union(CAST(area AS geometry))
+    (SELECT ST_Collect(CAST(area AS geometry))
         FROM waterway.waterway_area)),
   $7,
   $8,
--- a/pkg/imports/st.go	Wed Feb 13 16:41:00 2019 +0100
+++ b/pkg/imports/st.go	Wed Feb 13 16:48:52 2019 +0100
@@ -100,7 +100,7 @@
   (SELECT r FROM r),
   ISRSrange_area(
     (SELECT r FROM r),
-    (SELECT ST_Union(CAST(area AS geometry))
+    (SELECT ST_Collect(CAST(area AS geometry))
       FROM waterway.waterway_area)),
   $12,
   $13,