1
--#############################################################################
2
-- This SQL script generates the space time vector dataset view.
4
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
5
--#############################################################################
7
-- Create the views to access all columns for absolute or relative time
9
CREATE VIEW stvds_view_abs_time AS SELECT
10
A1.id, A1.name, A1.mapset, A1.temporal_type,
12
A1.creation_time, A1.modification_time,
14
A2.start_time, A2.end_time,
16
A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj,
19
A4.title, A4.description, A4.command, A4.points, A4.lines,
20
A4.boundaries, A4.centroids, A4.faces, A4.kernels,
21
A4.primitives, A4.nodes, A4.areas, A4.islands,
23
FROM stvds_base A1, stvds_absolute_time A2,
24
stvds_spatial_extent A3, stvds_metadata A4 WHERE A1.id = A2.id AND
25
A1.id = A3.id AND A1.id = A4.id;
27
CREATE VIEW stvds_view_rel_time AS SELECT
28
A1.id, A1.name, A1.mapset, A1.temporal_type,
30
A1.creation_time, A1.modification_time,
32
A2.start_time, A2.end_time, A2.unit, A2.granularity,
33
A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj,
36
A4.title, A4.description, A4.command, A4.points, A4.lines,
37
A4.boundaries, A4.centroids, A4.faces, A4.kernels,
38
A4.primitives, A4.nodes, A4.areas, A4.islands,
40
FROM stvds_base A1, stvds_relative_time A2,
41
stvds_spatial_extent A3, stvds_metadata A4 WHERE A1.id = A2.id AND
42
A1.id = A3.id AND A1.id = A4.id;