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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
--#############################################################################
-- This SQL is to update a space-time raster dataset metadata
--
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
-- UPDATE FROM syntax: Stefan Blumentrath stefan <dot> blumentrath <at> gmx <dot> de
--#############################################################################
-- SPACETIME_REGISTER_TABLE is a placeholder for specific stds map register table name (SQL compliant)
-- SPACETIME_ID is a placeholder for specific stds id: name@mapset
-- for TGIS < 3 the lines for semantic lables get replaced / commented out
UPDATE strds_metadata
SET
-- Update the min and max values
number_of_semantic_labels = number_of_semantic_labels_new,
-- Update the min and max values
min_min = new_stats.min_min_new,
min_max = new_stats.min_max_new,
max_min = new_stats.max_min_new,
max_max = new_stats.max_max_new,
-- Update the resolution
nsres_min = new_stats.nsres_min_new,
nsres_max = new_stats.nsres_max_new,
ewres_min = new_stats.ewres_min_new,
ewres_max = new_stats.ewres_max_new
FROM
(SELECT
count(distinct semantic_label) AS number_of_semantic_labels_new,
min(min) AS min_min_new,
max(min) AS min_max_new,
min(max) AS max_min_new,
max(max) AS max_max_new,
min(nsres) AS nsres_min_new,
max(nsres) AS nsres_max_new,
min(ewres) AS ewres_min_new,
max(ewres) AS ewres_max_new
FROM
SPACETIME_REGISTER_TABLE INNER JOIN
raster_metadata ON
SPACETIME_REGISTER_TABLE.id = raster_metadata.id
) AS new_stats
WHERE strds_metadata.id = 'SPACETIME_ID';
|
