Mercurial > gemma
annotate schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 5410:8b6018ed3ffd marking-single-beam
If doing SR imports, lock sounding_results_marking_points table, too.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 07 Jul 2021 09:29:06 +0200 |
parents | ac846e085553 |
children |
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'); |