Mercurial > gemma
comparison schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 4992:ac846e085553
Distinguish between HYDRO and IENC features in layer names
This will enable correct display of pretty names in the client.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 06 Mar 2020 18:28:42 +0100 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
4991:6a48e5c6fe2f | 4992:ac846e085553 |
---|---|
1 INSERT INTO sys_admin.published_services ( | |
2 schema, name, style | |
3 ) VALUES | |
4 ('waterway', 'fairway_marks_bcnlat_ienc', ( | |
5 SELECT style FROM sys_admin.published_services | |
6 WHERE schema = 'waterway' AND name = 'fairway_marks_bcnlat')), | |
7 ('waterway', 'fairway_marks_boylat_ienc', ( | |
8 SELECT style FROM sys_admin.published_services | |
9 WHERE schema = 'waterway' AND name = 'fairway_marks_boylat')), | |
10 ('waterway', 'fairway_marks_daymar_ienc', ( | |
11 SELECT style FROM sys_admin.published_services | |
12 WHERE schema = 'waterway' AND name = 'fairway_marks_daymar')); | |
13 | |
14 INSERT INTO sys_admin.grouped_layers VALUES | |
15 ('fairway_marks', 'waterway', 'fairway_marks_boylat_ienc', 0), | |
16 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_ienc', 2), | |
17 ('fairway_marks', 'waterway', 'fairway_marks_daymar_ienc', 5); | |
18 | |
19 WITH upd AS ( | |
20 UPDATE sys_admin.grouped_layers | |
21 SET name = name || '_hydro' | |
22 WHERE schema = 'waterway' AND name IN( | |
23 'fairway_marks_bcnlat', | |
24 'fairway_marks_boylat', | |
25 'fairway_marks_daymar')) | |
26 UPDATE sys_admin.published_services | |
27 SET name = name || '_hydro' | |
28 WHERE schema = 'waterway' AND name IN( | |
29 'fairway_marks_bcnlat', | |
30 'fairway_marks_boylat', | |
31 'fairway_marks_daymar'); |