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
43
44
45
46
|
--#############################################################################
-- This SQL script is for now a placeholder, till the vector metadata
-- concept is clear
--
-- 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
-- Update the vector features and topology
UPDATE stvds_metadata
SET
points = new_stats.points_new,
lines = new_stats.lines_new,
boundaries = new_stats.boundaries_new,
centroids = new_stats.centroids_new,
faces = new_stats.faces_new,
kernels = new_stats.kernels_new,
primitives = new_stats.primitives_new,
nodes = new_stats.nodes_new,
areas = new_stats.areas_new,
islands = new_stats.islands_new,
holes = new_stats.holes_new,
volumes = new_stats.volumes_new
FROM
(SELECT
sum(points) AS points_new,
sum(lines) AS lines_new,
sum(boundaries) AS boundaries_new,
sum(centroids) AS centroids_new,
sum(faces) AS faces_new,
sum(kernels) AS kernels_new,
sum(primitives) AS primitives_new,
sum(nodes) AS nodes_new,
sum(areas) AS areas_new,
sum(islands) AS islands_new,
sum(holes) AS holes_new,
sum(volumes) AS volumes_new
FROM
SPACETIME_REGISTER_TABLE INNER JOIN
vector_metadata ON
SPACETIME_REGISTER_TABLE.id = vector_metadata.id
) AS new_stats
WHERE stvds_metadata.id = 'SPACETIME_ID';
|
