# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1536576664 -7200
# Node ID 255f9a4e747f33d1139bc3473e5f287d75d74fc6
# Parent  4d97066c311c4b41a32dd3e289fe9f91c4baf315
Sounding results: We store the raw data as point clouds.

diff -r 4d97066c311c -r 255f9a4e747f schema/gemma.sql
--- 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
     )