Mercurial > gemma

comparison schema/default_sysconfig.sql @ 5259:680be197844d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged branch new-fwa.
author Sascha Wilde <wilde@intevation.de>
date Wed, 13 May 2020 11:28:34 +0200
parents 0b051ee3f238
children 6b0274693b48
comparison
equal deleted inserted replaced
5183:1b5c80ea5582 5259:680be197844d
2 -- without warranty, see README.md and license for details. 2 -- without warranty, see README.md and license for details.
3 3
4 -- SPDX-License-Identifier: AGPL-3.0-or-later 4 -- SPDX-License-Identifier: AGPL-3.0-or-later
5 -- License-Filename: LICENSES/AGPL-3.0.txt 5 -- License-Filename: LICENSES/AGPL-3.0.txt
6 6
7 -- Copyright (C) 2018, 2019 by via donau 7 -- Copyright (C) 2018, 2019, 2020 by via donau
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH 8 -- – Österreichische Wasserstraßen-Gesellschaft mbH
9 -- Software engineering by Intevation GmbH 9 -- Software engineering by Intevation GmbH
10 10
11 -- Author(s): 11 -- Author(s):
12 -- * Sascha Wilde <wilde@intevation.de> 12 -- * Sascha Wilde <wilde@intevation.de>
218 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id 218 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id
219 $$), 219 $$),
220 ('waterway', 'bottleneck_overview', 4326, NULL, $$ 220 ('waterway', 'bottleneck_overview', 4326, NULL, $$
221 SELECT 221 SELECT
222 objnam AS name, 222 objnam AS name,
223 bn.bottleneck_id,
223 ST_Centroid(area) AS point, 224 ST_Centroid(area) AS point,
224 (lower(stretch)).hectometre AS from, 225 (lower(stretch)).hectometre AS from,
225 (upper(stretch)).hectometre AS to, 226 (upper(stretch)).hectometre AS to,
226 sr.current::text, 227 sr.current::text,
227 responsible_country 228 responsible_country