Mercurial > gemma
annotate schema/updates/1426/02.configure_wms-t.sql @ 5267:aca4bf7af270
client: remove mapState from import statement
author | Fadi Abbud <fadi.abbud@intevation.de> |
---|---|
date | Wed, 10 Jun 2020 16:33:10 +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'; |