Overview:
Imports time series data in SHT format.
This data includes observations and forecasts on different dates, which are specified on top of each column. Therefore, to distinguish observations from forecasts, two different qualifiers are used: Observations use "Obs" as a qualifier, while forecasts use "Sim" as a qualifier.
The date of forecasting is provided at the beginning of the file.
In addition, location ids and parameters ids are also provided, in the first two columns, respectively.
Below is an example of the data to be imported.
Example:
DATE: 2019-02-26
DAILY REGULATION FORECASTING, OTTAWA RIVER BASIN
FORECAST FOR --> 2019-02-26 TO 2019-03-07
23 24 25 * 26 27 28 1 2
FEB FEB FEB * FEB FEB FEB MAR MAR
MEASURED * FORCASTED
BA DR 141 141 139 * 100 60 1 0 0
DZ RC 47 47 46 * 46 46 45 44 44
DZ RU 6 6 6 * 6 6 6 6 6
DZ DN 188 188 185 * 146 106 46 44 44
Each observation or forecast is associated to a location id (e.g., BA) and a parameter id (e.g., DR), which are given in the first two columns, respectively.
Java source code:
To import this data, OttawaRiverRegulationPlanningBoardSHTTimeSeriesParser.java
provides the parser.