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