Mercurial > gemma

diff schema/default_sysconfig.sql @ 5144:f11b9b50fcc9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Keep historic data of fairway dimensions ... and accordingly configure the respective layer as WMS-T.
author Tom Gottfried <tom@intevation.de>
date Tue, 31 Mar 2020 18:59:28 +0200
parents 8dc27fc1d05c
children 0b051ee3f238
line wrap: on
line diff
--- a/schema/default_sysconfig.sql	Tue Mar 31 15:30:23 2020 +0200
+++ b/schema/default_sysconfig.sql	Tue Mar 31 18:59:28 2020 +0200
@@ -112,8 +112,7 @@
 -- Directly accessed tables
 INSERT INTO sys_admin.published_services (schema, name) VALUES
     ('waterway', 'waterway_area'),
-    ('waterway', 'waterway_profiles'),
-    ('waterway', 'fairway_dimensions');
+    ('waterway', 'waterway_profiles');
 
 -- GeoServer SQL views without time support
 INSERT INTO sys_admin.published_services (
@@ -306,6 +305,21 @@
                     ORDER BY bottleneck_id DESC) AS srl
                 ON b.bottleneck_id = srl.bottleneck_id
     $$),
+    ('waterway', 'fairway_dimensions', 4326, 'id',
+        'valid_from', 'valid_to', $$
+            SELECT id,
+                lower(validity) AS valid_from,
+                COALESCE(upper(validity), current_timestamp) AS valid_to,
+                area,
+                level_of_service,
+                min_width,
+                max_width,
+                min_depth,
+                date_info,
+                source_organization,
+                staging_done
+            FROM waterway.fairway_dimensions
+        $$),
     ('waterway', 'waterway_axis', 4326, 'id',
         'valid_from', 'valid_to', $$
         SELECT id,