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 raster dataset metadata table.
--
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
--#############################################################################
CREATE TABLE strds_metadata (
id VARCHAR NOT NULL, -- Id of the space-time dataset, this is the primary key
raster_register VARCHAR, -- The id of the table in which the raster maps are registered for this dataset
number_of_maps INTEGER, -- The number of registered raster maps
max_min DOUBLE PRECISION, -- The minimal maximum of the registered raster maps
min_min DOUBLE PRECISION, -- The minimal minimum of the registered raster maps
max_max DOUBLE PRECISION, -- The maximal maximum of the registered raster maps
min_max DOUBLE PRECISION, -- The maximal minimum of the registered raster maps
nsres_min DOUBLE PRECISION, -- The lowest north-south resolution of the registered raster maps
nsres_max DOUBLE PRECISION, -- The highest north-south resolution of the registered raster maps
ewres_min DOUBLE PRECISION, -- The lowest east-west resolution of the registered raster maps
ewres_max DOUBLE PRECISION, -- The highest east-west resolution of the registered raster maps
aggregation_type VARCHAR, -- The aggregation type of the dataset (mean, min, max, ...) set by aggregation modules
number_of_semantic_labels INTEGER, -- The number of registered semantic labels
title VARCHAR, -- Title of the space-time raster dataset
description VARCHAR, -- Detailed description of the space-time raster dataset
command VARCHAR, -- The command that was used to create the space time raster dataset
PRIMARY KEY (id)
);
|
