Mercurial > gemma

annotate schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 5666:37c2354a6024 clickable-links

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Render links only to known bottlenecks
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 05 Dec 2023 15:34:31 +0100
parents ac846e085553
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4992
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 INSERT INTO sys_admin.published_services (
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 schema, name, style
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 ) VALUES
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 ('waterway', 'fairway_marks_bcnlat_ienc', (
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 SELECT style FROM sys_admin.published_services
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 WHERE schema = 'waterway' AND name = 'fairway_marks_bcnlat')),
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 ('waterway', 'fairway_marks_boylat_ienc', (
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 SELECT style FROM sys_admin.published_services
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9 WHERE schema = 'waterway' AND name = 'fairway_marks_boylat')),
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 ('waterway', 'fairway_marks_daymar_ienc', (
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 SELECT style FROM sys_admin.published_services
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 WHERE schema = 'waterway' AND name = 'fairway_marks_daymar'));
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14 INSERT INTO sys_admin.grouped_layers VALUES
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
15 ('fairway_marks', 'waterway', 'fairway_marks_boylat_ienc', 0),
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
16 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_ienc', 2),
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
17 ('fairway_marks', 'waterway', 'fairway_marks_daymar_ienc', 5);
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
18
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
19 WITH upd AS (
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
20 UPDATE sys_admin.grouped_layers
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
21 SET name = name || '_hydro'
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
22 WHERE schema = 'waterway' AND name IN(
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
23 'fairway_marks_bcnlat',
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
24 'fairway_marks_boylat',
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
25 'fairway_marks_daymar'))
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
26 UPDATE sys_admin.published_services
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
27 SET name = name || '_hydro'
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
28 WHERE schema = 'waterway' AND name IN(
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
29 'fairway_marks_bcnlat',
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
30 'fairway_marks_boylat',
ac846e085553 Distinguish between HYDRO and IENC features in layer names
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
31 'fairway_marks_daymar');