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