Introduction
The Menyanthes file format is a special CSV ASCII format that can be imported by Menyanthes. In FEWS it can be used to export sample time series.
Each export file consist of 3 parts, first a header followed by a description of the series and last the timeseries.
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 Qualifier id, date and time, value, flag
- Only non-missing values are printed.
More information on the Menyanthes format can be found on the Menyanthes internet site: (http://www.waterware.nl/Menyanthes/)
Description of file format
The Export module in FEWS exports the following header:
Menyanthes tag | FEWS info |
---|---|
TITEL | "FEWS Menyanthes Export" |
GEBRUIKERSNAAM | userName |
PERIODE | Content period start date |
DATUM | Content period end date |
REFERENTIE | NAP |
The Export module in FEWS exports the following series description:
Menyanthes tag | FEWS info |
---|---|
LOCATIE | Location Id |
FILTERNUMMER | Qualifier id |
EXTERNE AANDUIDING | "n/a" |
X COORDINAAT | Geometry X |
Y COORDINAAT | Geometry Y |
MAAIVELD | Geometry Z but overruled by Location attribute MAAIVELD_NAP when available. When both are unavailable "0" is written. |
GESCHAT | |
MEETPUNT NAP | Location attribute MEETPUNT_NAP when available or else it remains empty |
BOVENKANT FILTER | Location attribute BOVENKANT_FILTER when available or else it remains empty |
ONDERKANT FILTER | Location attribute ONDERKANT_FILTER when available or else it remains empty |
START DATUM | Measurement datum start |
EINDE DATUM | Measurement datum end |
The Export module in FEWS exports the following timeseries description:
Menyanthes tag | FEWS info |
---|---|
LOCATIE | Location Id |
FILTERNUMMER | Qualifier id |
PEIL DATUM TIJD | Measurement date time |
STAND (NAP) | Value |
BIJZONDERHEID | Flag |
Example export file
TITEL: FEWS Menyanthes Export GEBRUIKERSNAAM: ansink PERIODE: 2009/02/20-2010/03/22 DATUM:2010/03/22 08:16:22 REFERENTIE: NAP LOCATIE,FILTERNUMMER,EXTERNE AANDUIDING,X COORDINAAT,Y COORDINAAT,MAAIVELD NAP,GESCHAT,MEETPUNT NAP,BOVENKANT FILTER,ONDERKANT FILTER,START DATUM,EINDE DATUM 40145,1,n/a,156352.0,467817.0,2.27,,,,,2009/02/20,2010/03/22 LOCATIE,FILTERNUMMER,PEIL DATUM TIJD,STAND (NAP),BIJZONDERHEID 40145,1,2009/02/20 08:00:00,-1.36,8 40145,1,2009/02/20 09:00:00,-1.36,8 40145,1,2009/02/20 10:00:00,-1.36,8 40145,1,2009/02/20 11:00:00,-1.36,8