Mercurial > gemma
annotate schema/updates/1426/02.configure_wms-t.sql @ 5154:a33f1d51d1b7
Changed FD coordinate calculation from polygon to multipolygon.
author | Raimund Renkert <raimund@renkert.org> |
---|---|
date | Wed, 01 Apr 2020 15:48:07 +0200 |
parents | cf25b23e3eec |
children |
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'; |