Mercurial > gemma

changeset 2589:f4c399a496cb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Morphological differences: Add SRID to cast in ios-lines view.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 11 Mar 2019 18:46:09 +0100
parents 2fcb2f969321
children 1686ec185155
files schema/gemma.sql
diffstat 1 files changed, 6 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Mar 11 18:35:44 2019 +0100
+++ b/schema/gemma.sql	Mon Mar 11 18:46:09 2019 +0100
@@ -776,12 +776,12 @@
 ;
 
 CREATE VIEW waterway.sounding_differences AS SELECT
-    sd.id                AS id,
-    bn.objnam            AS objnam,
-    srm.date_info        AS minuend,
-    srs.date_info        AS subtrahend,
-    sdcl.height          AS height,
-    sdcl.lines::geometry AS lines
+    sd.id           AS id,
+    bn.objnam       AS objnam,
+    srm.date_info   AS minuend,
+    srs.date_info   AS subtrahend,
+    sdcl.height     AS height,
+    CAST(sdcl.lines AS geometry(multilinestring, 4326)) AS lines
 FROM
     caching.sounding_differences sd JOIN
     caching.sounding_differences_contour_lines sdcl ON sd.id = sdcl.sounding_differences_id JOIN