Mercurial > gemma
comparison schema/isrs.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 | 5b3d778db00c |
children | 4c585b5d4fe8 |
comparison
equal
deleted
inserted
replaced
3430:6994602d2935 | 3431:adf06af7a79c |
---|