Mercurial > gemma
diff schema/gemma.sql @ 605:255f9a4e747f
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 | 4854a1e85870 |
| children | 6dc1b586328e |
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 )