Introduction
Export scalar timeseries to csv type format (example config). The resulting csv files has two header rows. This first row contains the location name for each data column, the second row the parameter. Date/time is in yyyy-MM-dd HH:mm:ss format.
Attention: this CSV format is NOT the same as the CSV import format, which has three header lines
Example
,Bewdley,Saxons Lode ,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.
,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
<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.
,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
<exportTypeStandard>csvwithflagsource</exportTypeStandard>
Java source code
CsvTimeSeriesSerializer.java
CsvDutchTimeSeriesSerializer.java