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.

Example Output
,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
Export Type Standard
<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.

Example Output
,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
Export Type Standard
<exportTypeStandard>csvwithflagsource</exportTypeStandard>

Java source code


CsvTimeSeriesSerializer.java
CsvDutchTimeSeriesSerializer.java

  • No labels

Disclaimer