Introduction

The iBever file format is a special CSV ASCII format for water quality data that can be imported by iBever. In FEWS it can be used to export sample time series.

Each timeseries value in the timeseries content is written as a separate row in the file.

  • Each row contains information on the location ID and name, parameter ID and name, date and time, value, unit, flag
  • Only non-missing values are printed.

More information on the iBever CSV format can be found on the iBever internet site:

http://www.helpdeskwater.nl/ibever/formulieren_en/handleidingen/?ActItmIdt=3314

The Export module in FEWS exports the following columns

iBever tag

FEWS Info

mpn_mpnomsch

Location Name

mpn_mpnident

Location ID

mwa_mwadtmb

Measurement datum

mwa_mwatijdb

Measurement Time

mwa_mwawrden

Value

mep_domgwcod

Unit

mco_domgwcod

Compartment, at present only '10'

mrsinovs_domafkrt

Detection Limit '<' or '>'

hoe_domgwcod

Parameter qualifier

mps_domgwcod

Parameter ID

Example configuration file (example config).

Example File

mpn_mpnomsch;mpn_mpnident;mwa_mwadtmb;mwa_mwatijdb;mwa_mwawrden;mep_domgwcod;mco_domgwcod;mrsinovs_domafkrt;hoe_domgwcod;mps_domgwcod
WB Sevenum buffer Groot Luttel;DSVNLUT1;2007-12-19;13:50:00;2.0;ug/kg;10;<;NVT;24DDTS
WB Tungelroysebeek trace 1;DTUNG001;2007-05-09;11:30:00;2.0;ug/kg;10;<;NVT;24DDTS
WB Tungelroysebeek trace 2;DTUNG002;2007-05-09;00:15:00;2.0;ug/kg;10;<;NVT;24DDTS
WB Tungelroysebeek trace 3;DTUNG003;2007-05-09;14:15:00;2.0;ug/kg;10;<;NVT;24DDTS
WB Sevenum buffer Groot Luttel;DSVNLUT1;2007-12-19;13:50:00;2.0;ug/kg;10;<;NVT;44DDDS
WB Tungelroysebeek trace 1;DTUNG001;2007-05-09;11:30:00;2.0;ug/kg;10;<;NVT;44DDDS
WB Tungelroysebeek trace 2;DTUNG002;2007-05-09;00:15:00;2.0;ug/kg;10;<;NVT;44DDDS
WB Tungelroysebeek trace 3;DTUNG003;2007-05-09;14:15:00;2.0;ug/kg;10;<;NVT;44DDDS
WB Sevenum buffer Groot Luttel;DSVNLUT1;2007-12-19;13:50:00;1.0;ug/kg;10;<;NVT;44DDES
WB Tungelroysebeek trace 1;DTUNG001;2007-05-09;11:30:00;1.0;ug/kg;10;<;NVT;44DDES
WB Tungelroysebeek trace 2;DTUNG002;2007-05-09;00:15:00;1.0;ug/kg;10;<;NVT;44DDES
WB Tungelroysebeek trace 3;DTUNG003;2007-05-09;14:15:00;1.0;ug/kg;10;<;NVT;44DDES
WB Sevenum buffer Groot Luttel;DSVNLUT1;2007-12-19;13:50:00;2.0;ug/kg;10;<;NVT;44DDTS

Java souce code

IbeverTimeSeriesSerializer.java

  • No labels