1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
--#############################################################################
-- This SQL script generates the space time 3D raster dataset metadata table.
--
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
--#############################################################################
CREATE TABLE str3ds_metadata (
id VARCHAR NOT NULL, -- Id of the space time 3D raster dataset, this is the primary key
raster3d_register VARCHAR, -- The id of the table in which the 3D raster maps are registered for this dataset
number_of_maps INTEGER, -- The number of registered 3D raster maps
max_min DOUBLE PRECISION, -- The minimal maximum of the registered 3D raster maps
min_min DOUBLE PRECISION, -- The minimal minimum of the registered 3D raster maps
max_max DOUBLE PRECISION, -- The maximal maximum of the registered 3D raster maps
min_max DOUBLE PRECISION, -- The maximal minimum of the registered 3D raster maps
nsres_min DOUBLE PRECISION, -- The lowest north-south resolution of the registered 3D raster maps
nsres_max DOUBLE PRECISION, -- The highest north-south resolution of the registered 3D raster maps
ewres_min DOUBLE PRECISION, -- The lowest east-west resolution of the registered 3D raster maps
ewres_max DOUBLE PRECISION, -- The highest east-west resolution of the registered 3D raster maps
tbres_min DOUBLE PRECISION, -- The lowest top-bottom resolution of the registered 3D raster maps
tbres_max DOUBLE PRECISION, -- The highest top-bottom resolution of the registered 3D raster maps
aggregation_type VARCHAR, -- The aggregation type of the dataset (mean, min, max, ...) set by aggregation modules
title VARCHAR, -- Title of the space time 3D raster dataset
description VARCHAR, -- Detailed description of the space time 3D raster dataset
command VARCHAR, -- The command that was used to create the space time 3D raster dataset
PRIMARY KEY (id)
);
|
