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" but overruled by Location attribute EXTERNE_AANDUIDING when available. |
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 | |
MAAIVELD NAP | Optional, location attribute with surface level (MAAIVELD). Only if available, else it remains empty. |
MEETPUNT NAP | Optional, location attribute with gauge level (MEETPUNT). Only if available, else it remains empty. |
BOVENKANT FILTER | Optional, location attribute with level of top of filter. Only if available, else it remains empty. |
ONDERKANT FILTER | Optional, location attribute with level of bottom of filter. Only if available, else it remains empty. |
START DATUM | Measurement datum start |
EINDE DATUM | Measurement datum end |
Using the optional elements can be configured as in the below examples. Notice that the internalAttributeId should point to your own configured attributes.The externalAttributeId is fixed!
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
Source code
MenyanthesTimeSeriesSerializer.java
LOCATION_ATTRIBUTE_EXTERNE_AANDUIDING