1
--#############################################################################
2
-- This SQL is to update a space-time raster 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 strds_metadata SET min_min =
12
(SELECT min(min) FROM raster_metadata WHERE raster_metadata.id IN
13
(SELECT id FROM SPACETIME_REGISTER_TABLE)
14
) WHERE id = 'SPACETIME_ID';
15
UPDATE strds_metadata SET min_max =
16
(SELECT max(min) FROM raster_metadata WHERE raster_metadata.id IN
17
(SELECT id FROM SPACETIME_REGISTER_TABLE)
18
) WHERE id = 'SPACETIME_ID';
19
UPDATE strds_metadata SET max_min =
20
(SELECT min(max) FROM raster_metadata WHERE raster_metadata.id IN
21
(SELECT id FROM SPACETIME_REGISTER_TABLE)
22
) WHERE id = 'SPACETIME_ID';
23
UPDATE strds_metadata SET max_max =
24
(SELECT max(max) FROM raster_metadata WHERE raster_metadata.id IN
25
(SELECT id FROM SPACETIME_REGISTER_TABLE)
26
) WHERE id = 'SPACETIME_ID';
27
-- Update the resolution
28
UPDATE strds_metadata SET nsres_min =
29
(SELECT min(nsres) FROM raster_metadata WHERE raster_metadata.id IN
30
(SELECT id FROM SPACETIME_REGISTER_TABLE)
31
) WHERE id = 'SPACETIME_ID';
32
UPDATE strds_metadata SET nsres_max =
33
(SELECT max(nsres) FROM raster_metadata WHERE raster_metadata.id IN
34
(SELECT id FROM SPACETIME_REGISTER_TABLE)
35
) WHERE id = 'SPACETIME_ID';
36
UPDATE strds_metadata SET ewres_min =
37
(SELECT min(ewres) FROM raster_metadata WHERE raster_metadata.id IN
38
(SELECT id FROM SPACETIME_REGISTER_TABLE)
39
) WHERE id = 'SPACETIME_ID';
40
UPDATE strds_metadata SET ewres_max =
41
(SELECT max(ewres) FROM raster_metadata WHERE raster_metadata.id IN
42
(SELECT id FROM SPACETIME_REGISTER_TABLE)
43
) WHERE id = 'SPACETIME_ID';