Mercurial > gemma

annotate schema/updates/1426/02.configure_wms-t.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 cf25b23e3eec
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5016
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 UPDATE sys_admin.published_services
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 SET
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 srid = 4326,
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 key_column = 'id',
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 wmst_attribute = 'valid_from',
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 wmst_end_attribute = 'valid_to',
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 view_def = $$
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 SELECT id,
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9 lower(validity) AS valid_from,
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 COALESCE(upper(validity), current_timestamp) AS valid_to,
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 wtwaxs,
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 objnam,
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13 nobjnam
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14 FROM waterway.waterway_axis
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
15 $$
cf25b23e3eec Keep historic data of waterway axis
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
16 WHERE schema = 'waterway' AND name = 'waterway_axis';