comparison schema/default_sysconfig.sql @ 4934:c6af373b0832 fairway-marks-import

Added fairwaymarks group layer in configuration.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sat, 15 Feb 2020 21:29:38 +0100
parents 9b9b4150f296
children 97533bbfaa2d
comparison
equal deleted inserted replaced
4933:45ef039cf4a8 4934:c6af373b0832
277 ON srm.bottleneck_id = bn.bottleneck_id 277 ON srm.bottleneck_id = bn.bottleneck_id
278 AND srm.date_info::timestamptz <@ bn.validity 278 AND srm.date_info::timestamptz <@ bn.validity
279 $$); 279 $$);
280 280
281 -- 281 --
282 -- group layers
283 --
284 INSERT INTO sys_admin.layer_groups VALUES ('fairway_marks');
285
286 INSERT INTO sys_admin.grouped_layers VALUES
287 ('fairway_marks', 'waterway', 'fairway_marks_boylat', 0),
288 ('fairway_marks', 'waterway', 'fairway_marks_boycar', 1),
289 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat', 2);
290
291 --
282 -- Settings 292 -- Settings
283 -- 293 --
284 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_url', 'https://service.d4d-portal.info/wms/'); 294 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_url', 'https://service.d4d-portal.info/wms/');
285 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_params', '{"LAYERS": "d4d", "VERSION": "1.1.1", "TILED": true}'); 295 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_params', '{"LAYERS": "d4d", "VERSION": "1.1.1", "TILED": true}');
286 INSERT INTO sys_admin.system_config VALUES ('bn_revtime_multiplier', 1.5); 296 INSERT INTO sys_admin.system_config VALUES ('bn_revtime_multiplier', 1.5);