Mercurial > gemma

changeset 2752:018f979f9e23

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Bottlenecks import allow ISRS_from > ISRS_to. The order constraint on isrsranges are arbitrary and should be satisfied by the WAMOS back end not by the user data.
author Sascha Wilde <wilde@intevation.de>
date Thu, 21 Mar 2019 12:53:39 +0100
parents 5da81634bdc4
children 2aa1620ffd9e
files pkg/imports/bn.go
diffstat 1 files changed, 5 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/bn.go	Thu Mar 21 12:33:43 2019 +0100
+++ b/pkg/imports/bn.go	Thu Mar 21 12:53:39 2019 +0100
@@ -64,9 +64,12 @@
   isrs_fromText($2),
   $3,
   $4,
-  isrsrange(isrs_fromText($5), isrs_fromText($6)),
+  isrsrange(least(isrs_fromText($5), isrs_fromText($6)),
+            greatest(isrs_fromText($5), isrs_fromText($6))),
   ISRSrange_area(
-    ISRSrange_axis(isrsrange(isrs_fromText($5), isrs_fromText($6)), $14),
+    ISRSrange_axis(isrsrange(least(isrs_fromText($5), isrs_fromText($6)),
+                             greatest(isrs_fromText($5), isrs_fromText($6))),
+                   $14),
     (SELECT ST_Collect(CAST(area AS geometry))
         FROM waterway.waterway_area)),
   $7,