1--#############################################################################
2-- This SQL script generates the space time 3D raster dataset views.
3--
4-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
5--#############################################################################
6
7-- Create the views to access all cols for absolute or relative time
8
9CREATE VIEW str3ds_view_abs_time AS SELECT
10            A1.id, A1.name, A1.mapset, A1.temporal_type,
11            A1.semantic_type,
12            A1.creation_time, A1.modification_time,
13            A1.creator,
14            A2.start_time, A2.end_time, A2.granularity,
15            A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj,
16            A4.raster3d_register,
17            A4.number_of_maps,
18            A4.nsres_min, A4.ewres_min,
19            A4.nsres_max, A4.ewres_max,
20            A4.tbres_min, A4.tbres_max,
21            A4.min_min, A4.min_max,
22            A4.max_min, A4.max_max, A4.aggregation_type,
23            A4.title, A4.description, A4.command
24            FROM str3ds_base A1, str3ds_absolute_time A2,
25            str3ds_spatial_extent A3, str3ds_metadata A4 WHERE A1.id = A2.id AND
26	    A1.id = A3.id AND A1.id = A4.id;
27
28CREATE VIEW str3ds_view_rel_time AS SELECT
29            A1.id, A1.name, A1.mapset, A1.temporal_type,
30            A1.semantic_type,
31            A1.creation_time, A1.modification_time,
32            A1.creator,
33            A2.start_time, A2.end_time, A2.unit, A2.granularity,
34            A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj,
35            A4.raster3d_register,
36            A4.number_of_maps,
37            A4.nsres_min, A4.ewres_min,
38            A4.nsres_max, A4.ewres_max,
39            A4.tbres_min, A4.tbres_max,
40            A4.min_min, A4.min_max,
41            A4.max_min, A4.max_max, A4.aggregation_type,
42            A4.title, A4.description, A4.command
43            FROM str3ds_base A1, str3ds_relative_time A2,
44            str3ds_spatial_extent A3, str3ds_metadata A4 WHERE A1.id = A2.id AND
45            A1.id = A3.id AND A1.id = A4.id;
46
47