Mercurial > gemma
comparison schema/auth.sql @ 3431:adf06af7a79c
Add forecast accuracy to gauges view
Forecast accuracy is calculated as the maximum deviation of confidence
interval bounds from the prediction within the next four days.
The JSON-aggregate of reference water levels is moved into a
sub-select to avoid having to add further independent columns to the
GROUP BY clause of the main statement.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 23 May 2019 17:29:34 +0200 |
parents | ec6163c6687d |
children | 73fd4dd9e569 |
comparison
equal
deleted
inserted
replaced
3430:6994602d2935 | 3431:adf06af7a79c |
---|