1--#############################################################################
2-- This SQL script generates two views to access all map specific tables.
3--
4-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
5--#############################################################################
6
7
8-- Create the views to access all cols for the absolute and relative time
9
10CREATE VIEW raster3d_view_abs_time AS SELECT
11            A1.id, A1.mapset,
12            A1.name, A1.temporal_type,
13            A1.creation_time,
14            A1.creator,
15            A2.start_time, A2.end_time,
16            A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj,
17            A4.datatype, A4.cols, A4.rows, A4.depths,
18            A4.nsres, A4.ewres, A4.tbres,
19            A4.min, A4.max,
20            A4.number_of_cells, A5.registered_stds
21            FROM raster3d_base A1, raster3d_absolute_time A2,
22            raster3d_spatial_extent A3, raster3d_metadata A4,
23            raster3d_stds_register A5
24            WHERE A1.id = A2.id AND A1.id = A3.id AND
25            A1.id = A4.id AND A1.id = A5.id;
26
27CREATE VIEW raster3d_view_rel_time AS SELECT
28            A1.id, A1.mapset,
29            A1.name, A1.temporal_type,
30            A1.creation_time,
31            A1.creator,
32            A2.start_time, A2.end_time, A2.unit,
33            A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj,
34            A4.datatype, A4.cols, A4.rows, A4.depths,
35            A4.nsres, A4.ewres, A4.tbres,
36            A4.min, A4.max,
37            A4.number_of_cells, A5.registered_stds
38            FROM raster3d_base A1, raster3d_relative_time A2,
39            raster3d_spatial_extent A3, raster3d_metadata A4,
40            raster3d_stds_register A5
41            WHERE A1.id = A2.id AND A1.id = A3.id AND
42            A1.id = A4.id AND A1.id = A5.id;
43
44
45