Mercurial > gemma
changeset 5417:2d294ad81241 marking-single-beam
Dont loose Z values in markings.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 07 Jul 2021 18:14:04 +0200 |
parents | 31b0e865e7a0 |
children | e89ff1894bb4 |
files | pkg/imports/sr.go schema/gemma.sql schema/updates/1460/01.markings.sql |
diffstat | 3 files changed, 3 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- 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 `
--- 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) )
--- 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) );