Mercurial > gemma

changeset 605:255f9a4e747f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Sounding results: We store the raw data as point clouds.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 10 Sep 2018 12:51:04 +0200
parents 4d97066c311c
children e6d95e6d232b
files schema/gemma.sql
diffstat 1 files changed, 3 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Sep 10 12:32:37 2018 +0200
+++ b/schema/gemma.sql	Mon Sep 10 12:51:04 2018 +0200
@@ -376,7 +376,9 @@
         surtyp varchar NOT NULL REFERENCES survey_types,
         coverage varchar REFERENCES coverage_types,
         depth_reference char(3) NOT NULL REFERENCES depth_references,
-        sounding_data raster NOT NULL,
+        point_cloud geography(MULTIPOINTZ, 4326)),
+        -- XXX: We may raster the data later.
+        -- sounding_data raster NOT NULL,
         staging_done boolean NOT NULL DEFAULT false
     )