Mercurial > gemma

diff schema/geoserver_views.sql @ 3442:030dc48382c9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapt color scheme for waterlevel prediction accuracy
author Tom Gottfried <tom@intevation.de>
date Fri, 24 May 2019 11:37:24 +0200
parents 6e15c3c1e9b7
children 7f65790b6bd6
line wrap: on
line diff
--- a/schema/geoserver_views.sql	Fri May 24 11:31:43 2019 +0200
+++ b/schema/geoserver_views.sql	Fri May 24 11:37:24 2019 +0200
@@ -18,7 +18,7 @@
         g.source_organization,
         r.rwls AS reference_water_levels,
         wl.water_level AS gm_waterlevel,
-        fca.forecast_accuracy,
+        fca.forecast_accuracy_3d,
         fca.forecast_accuracy_1d
     FROM waterway.gauges g
         LEFT JOIN (SELECT location, validity,
@@ -33,13 +33,13 @@
                     max(acc) FILTER (WHERE
                         measure_date <= current_timestamp + '1 day'::interval)
                         AS forecast_accuracy_1d,
-                    max(acc) AS forecast_accuracy
+                    max(acc) AS forecast_accuracy_3d
                 FROM waterway.gauge_predictions,
                     GREATEST(water_level - lower(conf_interval),
                         upper(conf_interval) - water_level) AS acc (acc)
                 WHERE measure_date
                     BETWEEN current_timestamp
-                        AND current_timestamp + '4 days'::interval
+                        AND current_timestamp + '3 days'::interval
                 GROUP BY location) AS fca
             USING (location)
     WHERE NOT g.erased;