...
Export scalar timeseries to csv type format (example config). The resulting csv files has three two header rows. This first row contains the location name for each data column, the second row the location Id for each data column, the third row the parameter. Date/time is in yyyyyyy-mmMM-dd hhHH:mm:ss format.
Warning |
---|
Attention: this CSV format is NOT the same as the CSV import format, which has three header lines |
Example
No Format |
---|
Location Name:,Bewdley,Saxons Lode Location Id:,EA_H-2001,EA_H-2032 Time,Rainfall,Rainfall 2003-03-01 01:00:00,-999,-999 2003-03-01 01:15:00,1.000,1.000 2003-03-01 01:30:00,2.000,2.000 2003-03-01 01:45:00,3.000,3.000 2003-03-01 02:00:00,4.000,4.000 2003-03-01 02:15:00,-999,5.000 2003-03-01 02:30:00,6.000,6.000 2003-03-01 02:45:00,7.000,7.000 2003-03-01 03:00:00,8.000,8.000 2003-03-01 03:15:00,9.000,9.000 2003-03-01 03:30:00,10.000,10.000 2003-03-01 03:45:00,11.000,11.000 2003-03-01 04:00:00,12.000,12.000 2003-03-01 04:15:00,13.000,13.000 2003-03-01 04:30:00,14.000,14.000 2003-03-01 04:45:00,15.000,15.000 2003-03-01 05:00:00,16.000,16.000 2003-03-01 05:15:00,17.000,17.000 2003-03-01 05:30:00,18.000,18.000 2003-03-01 05:45:00,19.000,19.000 2003-03-01 06:00:00,20.000,20.000 |
Export Variations
CSV With Quality Flag Time Series Export
This export type standard will display both observed values and quality flags for that observation over two columns.
Code Block | ||||
---|---|---|---|---|
| ||||
,X.obs,X.obs quality 15-10-2020 00:00,23.0,original reliable 15-10-2020 01:00,34.0,completed unreliable 15-10-2020 01:00,45.0,original doubtful SH |
Code Block | ||||
---|---|---|---|---|
| ||||
<exportTypeStandard>csvwithquality</exportTypeStandard> |
CSV With Flag Source Time Series Export
This export type standard will display both observed values and flag sources for that observation over two columns.
Code Block | ||||
---|---|---|---|---|
| ||||
,X.obs,X.obs quality
15-10-2020 00:00,23.0,
15-10-2020 01:00,34.0,
15-10-2020 01:00,45.0,SH |
Code Block | ||||
---|---|---|---|---|
| ||||
<exportTypeStandard>csvwithflagsource</exportTypeStandard> |
Java source code
CsvTimeSeriesSerializer.java
CsvDutchTimeSeriesSerializer.java