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 export attribute EXTERNE_AANDUIDING when available, which should point to a valid location attribute

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 NAPOptional, 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!

timeSeriesExportRun 
<timeSeriesExportRun>
  <export>
    <general>menyanthes</general>
    <exportAttribute internalAttributeId="MAAIVELD" externalAttributeId="LOCATION_ATTRIBUTE_MAAIVELD_NAP"/>
    <exportAttribute internalAttributeId="MEETPUNT" externalAttributeId="LOCATION_ATTRIBUTE_MEETPUNT_NAP"/>
    <exportAttribute internalAttributeId="BOVENKANT_FILTER" externalAttributeId="LOCATION_ATTRIBUTE_BOVENKANT_FILTER"/>
    <exportAttribute internalAttributeId="ONDERKANT_FILTER" externalAttributeId="LOCATION_ATTRIBUTE_ONDERKANT_FILTER"/>
    <exportAttribute internalAttributeId="EXTERNE_AANDUIDING" externalAttributeId="LOCATION_ATTRIBUTE_EXTERNE_AANDUIDING"/>
    <timeSeriesSet> ...... </timeSeriesSet>
  </export>
</timeSeriesExportRun>
Explorer interactiveExportFormat 
<interactiveExportFormat>
  <name>Menyanthes</name>
  <exportType>Menyanthes</exportType>
  <IdMapId>IdExportMenyanthes</IdMapId>
  <exportAttribute internalAttributeId="MAAIVELD" externalAttributeId="LOCATION_ATTRIBUTE_MAAIVELD_NAP"/>
  <exportAttribute internalAttributeId="MEETPUNT" externalAttributeId="LOCATION_ATTRIBUTE_MEETPUNT_NAP"/>
  <exportAttribute internalAttributeId="BOVENKANT_FILTER" externalAttributeId="LOCATION_ATTRIBUTE_BOVENKANT_FILTER"/>
  <exportAttribute internalAttributeId="ONDERKANT_FILTER" externalAttributeId="LOCATION_ATTRIBUTE_ONDERKANT_FILTER"/>
  <exportAttribute internalAttributeId="EXTERNE_AANDUIDING" externalAttributeId="LOCATION_ATTRIBUTE_EXTERNE_AANDUIDING"/>
</interactiveExportFormat>

 

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
  • No labels

Disclaimer