Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
5143:733f7136a30e 5144:f11b9b50fcc9
110 $$); 110 $$);
111 111
112 -- Directly accessed tables 112 -- Directly accessed tables
113 INSERT INTO sys_admin.published_services (schema, name) VALUES 113 INSERT INTO sys_admin.published_services (schema, name) VALUES
114 ('waterway', 'waterway_area'), 114 ('waterway', 'waterway_area'),
115 ('waterway', 'waterway_profiles'), 115 ('waterway', 'waterway_profiles');
116 ('waterway', 'fairway_dimensions');
117 116
118 -- GeoServer SQL views without time support 117 -- GeoServer SQL views without time support
119 INSERT INTO sys_admin.published_services ( 118 INSERT INTO sys_admin.published_services (
120 schema, name, srid, key_column, view_def 119 schema, name, srid, key_column, view_def
121 ) VALUES 120 ) VALUES
304 FROM waterway.sounding_results 303 FROM waterway.sounding_results
305 GROUP BY bottleneck_id 304 GROUP BY bottleneck_id
306 ORDER BY bottleneck_id DESC) AS srl 305 ORDER BY bottleneck_id DESC) AS srl
307 ON b.bottleneck_id = srl.bottleneck_id 306 ON b.bottleneck_id = srl.bottleneck_id
308 $$), 307 $$),
308 ('waterway', 'fairway_dimensions', 4326, 'id',
309 'valid_from', 'valid_to', $$
310 SELECT id,
311 lower(validity) AS valid_from,
312 COALESCE(upper(validity), current_timestamp) AS valid_to,
313 area,
314 level_of_service,
315 min_width,
316 max_width,
317 min_depth,
318 date_info,
319 source_organization,
320 staging_done
321 FROM waterway.fairway_dimensions
322 $$),
309 ('waterway', 'waterway_axis', 4326, 'id', 323 ('waterway', 'waterway_axis', 4326, 'id',
310 'valid_from', 'valid_to', $$ 324 'valid_from', 'valid_to', $$
311 SELECT id, 325 SELECT id,
312 lower(validity) AS valid_from, 326 lower(validity) AS valid_from,
313 COALESCE(upper(validity), current_timestamp) AS valid_to, 327 COALESCE(upper(validity), current_timestamp) AS valid_to,