# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1625674444 -7200
# Node ID 2d294ad812418769e218be73254c18c0cd701f0b
# Parent  31b0e865e7a0180f0bc355a0199d4522c6a0a878
Dont loose Z values in markings.

diff -r 31b0e865e7a0 -r 2d294ad81241 pkg/imports/sr.go
--- a/pkg/imports/sr.go	Wed Jul 07 14:57:30 2021 +0200
+++ b/pkg/imports/sr.go	Wed Jul 07 18:14:04 2021 +0200
@@ -208,7 +208,7 @@
 SELECT
   $1,
   $2,
-  ST_Transform(ST_Force2D(ST_GeomFromWKB($4, $3::integer)), 4326)
+  ST_Transform(ST_GeomFromWKB($4, $3::integer), 4326)
 FROM waterway.sounding_results sr
 WHERE id = $1
 `
diff -r 31b0e865e7a0 -r 2d294ad81241 schema/gemma.sql
--- a/schema/gemma.sql	Wed Jul 07 14:57:30 2021 +0200
+++ b/schema/gemma.sql	Wed Jul 07 18:14:04 2021 +0200
@@ -833,7 +833,7 @@
         sounding_result_id int NOT NULL REFERENCES sounding_results
           ON DELETE CASCADE,
         height numeric NOT NULL,
-        points geography(MULTIPOINT, 4326) NOT NULL,
+        points geometry(MULTIPOINTZ, 4326) NOT NULL,
         PRIMARY KEY (sounding_result_id, height)
     )
 
diff -r 31b0e865e7a0 -r 2d294ad81241 schema/updates/1460/01.markings.sql
--- a/schema/updates/1460/01.markings.sql	Wed Jul 07 14:57:30 2021 +0200
+++ b/schema/updates/1460/01.markings.sql	Wed Jul 07 18:14:04 2021 +0200
@@ -4,7 +4,7 @@
    sounding_result_id int NOT NULL REFERENCES waterway.sounding_results
      ON DELETE CASCADE,
    height numeric NOT NULL,
-   points geography(MULTIPOINT, 4326) NOT NULL,
+   points geometry(MULTIPOINTZ, 4326) NOT NULL,
    PRIMARY KEY (sounding_result_id, height)
 );