Mercurial > gemma

annotate schema/updates/1426/02.configure_wms-t.sql @ 5559:ce9a9a1bf92f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make invalid output of ISRSrange_area() less likely, next try Since ST_MakeValid() might return a collection of lower-to-equal dimension geometries, distill only the polygons from it. This should prevent respective errors when trying to save the result to a column of type MultiPolygon.
author Tom Gottfried <tom@intevation.de>
date Thu, 02 Dec 2021 12:37:33 +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';