Mercurial > gemma
annotate schema/demo-data/published_services.sql @ 2624:9dbaf69c7a66
Improve geoserver config to better calculate bounding boxes
* Disable the use of estimated extents for the postgis storage
configuration for geoserver, which is set via the gemma middleware.
This way we are able to get better bounding boxes for many layers
where the postgis function `ST_EstimatedExtent()` would be far off.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Wed, 13 Mar 2019 16:18:39 +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') |