Mercurial > gemma
annotate schema/demo-data/published_services.sql @ 2455:54c9fe587fe6
Subdivide SQL function to prepare for improved error handling
The context of an error (e.g. the function in which it occured)
can be inferred by the database client. Not doing all in one
statement will render the context more meaningful.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 01 Mar 2019 18:38:02 +0100 |
| parents | 960550ccca55 |
| children | c9032a57996e |
| rev | line source |
|---|---|
|
1318
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
1 -- This is Free Software under GNU Affero General Public License v >= 3.0 |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
2 -- without warranty, see README.md and license for details. |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
3 |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
4 -- SPDX-License-Identifier: AGPL-3.0-or-later |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
5 -- License-Filename: LICENSES/AGPL-3.0.txt |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
6 |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
7 -- Copyright (C) 2018 by via donau |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
9 -- Software engineering by Intevation GmbH |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
10 |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
11 -- Author(s): |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
12 -- * Tom Gottfried <tom@intevation.de> |
|
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1110
diff
changeset
|
13 |
|
1110
ed8fbbc48440
Add demo-data for published OGC services
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
14 INSERT INTO sys_admin.published_services (name) VALUES |
|
1929
f538d9a23329
Better suited GeoServer view for waterway.stretches.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1919
diff
changeset
|
15 ('waterway.stretches_geoserver'), |
|
1110
ed8fbbc48440
Add demo-data for published OGC services
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
16 ('waterway.fairway_dimensions'), |
| 2451 | 17 ('waterway.gauges_geoserver'), |
|
2300
3dd2de314b1b
Use distance marks from wamos db in map.
Sascha Wilde <wilde@intevation.de>
parents:
2157
diff
changeset
|
18 ('waterway.distance_marks_ashore_geoserver'), |
|
1110
ed8fbbc48440
Add demo-data for published OGC services
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
19 ('waterway.distance_marks_geoserver'), |
|
ed8fbbc48440
Add demo-data for published OGC services
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
20 ('waterway.sounding_results_contour_lines_geoserver'), |
|
1963
f7a35ba9f409
Added view for publishing bottlenecks
Sascha Wilde <wilde@intevation.de>
parents:
1929
diff
changeset
|
21 ('waterway.bottlenecks_geoserver'), |
|
1719
a005816388b7
Use internal waterway axis data for map (not d4d wfs).
Sascha Wilde <wilde@intevation.de>
parents:
1318
diff
changeset
|
22 ('waterway.bottleneck_overview'), |
|
1794
de4543bfbad5
Use internal waterway area data for map (not d4d wfs).
Sascha Wilde <wilde@intevation.de>
parents:
1719
diff
changeset
|
23 ('waterway.waterway_axis'), |
|
2157
8be0fbac2297
Added layer for waterway profiles.
Sascha Wilde <wilde@intevation.de>
parents:
1963
diff
changeset
|
24 ('waterway.waterway_area'), |
|
8be0fbac2297
Added layer for waterway profiles.
Sascha Wilde <wilde@intevation.de>
parents:
1963
diff
changeset
|
25 ('waterway.waterway_profiles') |