Mercurial > gemma

changeset 1631:6ee06eb37fa9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use new function to calculate bn area.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 19 Dec 2018 18:37:40 +0100
parents f6218f11062a
children 0123a120e999
files pkg/imports/bn.go
diffstat 1 files changed, 5 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/bn.go	Wed Dec 19 18:12:03 2018 +0100
+++ b/pkg/imports/bn.go	Wed Dec 19 18:37:40 2018 +0100
@@ -57,7 +57,11 @@
   $3,
   $4,
   isrsrange(isrs_fromText($5), isrs_fromText($6)),
-  ST_MakePolygon(ST_ExteriorRing(ST_Buffer(ST_SetSRID(ST_Makepoint(13.05501, 47.80949), 4326), 0.01)))::Geography,
+  ISRSrange_area(
+    isrsrange(isrs_fromText($5), isrs_fromText($6)),
+    (SELECT ST_Union(CAST(area AS geometry))
+        FROM waterway.fairway_dimensions
+        WHERE level_of_service = 3)),
   $7,
   $8,
   $9,