1
--#############################################################################
2
-- This SQL script generates two views to access all map specific tables.
4
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
5
--#############################################################################
8
-- Create the views to access all cols for the absolute and relative time
10
CREATE VIEW raster_view_abs_time AS SELECT
12
A1.name, A1.temporal_type,
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,
18
A4.nsres, A4.ewres, A4.min, A4.max,
19
A4.number_of_cells, A5.registered_stds
20
FROM raster_base A1, raster_absolute_time A2,
21
raster_spatial_extent A3, raster_metadata A4,
22
raster_stds_register A5
23
WHERE A1.id = A2.id AND A1.id = A3.id AND
24
A1.id = A4.id AND A1.id = A5.id;
26
CREATE VIEW raster_view_rel_time AS SELECT
28
A1.name, A1.temporal_type,
31
A2.start_time, A2.end_time, A2.unit,
32
A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj,
33
A4.datatype, A4.cols, A4.rows,
34
A4.nsres, A4.ewres, A4.min, A4.max,
35
A4.number_of_cells, A5.registered_stds
36
FROM raster_base A1, raster_relative_time A2,
37
raster_spatial_extent A3, raster_metadata A4,
38
raster_stds_register A5
39
WHERE A1.id = A2.id AND A1.id = A3.id AND
40
A1.id = A4.id AND A1.id = A5.id;