1
--#############################################################################
2
-- This SQL script is to update a space-time raster3d dataset metadata
4
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
5
--#############################################################################
7
-- SPACETIME_REGISTER_TABLE is a placeholder for specific stds map register table name (SQL compliant)
8
-- SPACETIME_ID is a placeholder for specific stds id: name@mapset
10
-- Update the min and max values
11
UPDATE str3ds_metadata SET min_min =
12
(SELECT min(min) FROM raster3d_metadata WHERE raster3d_metadata.id IN
13
(SELECT id FROM SPACETIME_REGISTER_TABLE)
14
) WHERE id = 'SPACETIME_ID';
15
UPDATE str3ds_metadata SET min_max =
16
(SELECT max(min) FROM raster3d_metadata WHERE raster3d_metadata.id IN
17
(SELECT id FROM SPACETIME_REGISTER_TABLE)
18
) WHERE id = 'SPACETIME_ID';
19
UPDATE str3ds_metadata SET max_min =
20
(SELECT min(max) FROM raster3d_metadata WHERE raster3d_metadata.id IN
21
(SELECT id FROM SPACETIME_REGISTER_TABLE)
22
) WHERE id = 'SPACETIME_ID';
23
UPDATE str3ds_metadata SET max_max =
24
(SELECT max(max) FROM raster3d_metadata WHERE raster3d_metadata.id IN
25
(SELECT id FROM SPACETIME_REGISTER_TABLE)
26
) WHERE id = 'SPACETIME_ID';
27
-- Update the resolution
28
UPDATE str3ds_metadata SET nsres_min =
29
(SELECT min(nsres) FROM raster3d_metadata WHERE raster3d_metadata.id IN
30
(SELECT id FROM SPACETIME_REGISTER_TABLE)
31
) WHERE id = 'SPACETIME_ID';
32
UPDATE str3ds_metadata SET nsres_max =
33
(SELECT max(nsres) FROM raster3d_metadata WHERE raster3d_metadata.id IN
34
(SELECT id FROM SPACETIME_REGISTER_TABLE)
35
) WHERE id = 'SPACETIME_ID';
36
UPDATE str3ds_metadata SET ewres_min =
37
(SELECT min(ewres) FROM raster3d_metadata WHERE raster3d_metadata.id IN
38
(SELECT id FROM SPACETIME_REGISTER_TABLE)
39
) WHERE id = 'SPACETIME_ID';
40
UPDATE str3ds_metadata SET ewres_max =
41
(SELECT max(ewres) FROM raster3d_metadata WHERE raster3d_metadata.id IN
42
(SELECT id FROM SPACETIME_REGISTER_TABLE)
43
) WHERE id = 'SPACETIME_ID';
44
UPDATE str3ds_metadata SET tbres_min =
45
(SELECT min(tbres) FROM raster3d_metadata WHERE raster3d_metadata.id IN
46
(SELECT id FROM SPACETIME_REGISTER_TABLE)
47
) WHERE id = 'SPACETIME_ID';
48
UPDATE str3ds_metadata SET tbres_max =
49
(SELECT max(tbres) FROM raster3d_metadata WHERE raster3d_metadata.id IN
50
(SELECT id FROM SPACETIME_REGISTER_TABLE)
51
) WHERE id = 'SPACETIME_ID';