Overview

Imports time series data from the GrondWaterService hosted by TNO.

The GrondWaterService offers a wide variety of data however only imports for the following data types have been implemented:

  • Ground water levels
  • Ground water statistics

Ground water levels

The ground water levels request returns a list of time/value pairs of the measured ground water levels for a measuring station.

Ground water statistics

The ground water statistics request returns a list containing a number of times and for each time a set of statistical parameters that apply to the ground water level. The following parameters are returned:

  • MAX_LEVEL
  • MIN_LEVEL
  • STD_LEVEL
  • MEAN_LEVEL
  • MEDIAN_LEVEL
  • P10_LEVEL
  • P25_LEVEL
  • P75_LEVEL
  • P90_LEVEL

Configuration (Example)

A complete import module configuration consists of an ID Mapping file and a Import Module Instance file.

ModuleConfigFiles/

The following example of an Import Module Instance will import the time series as non-equidistant series.

ImportDINOService.xml
<?xml version="1.0" encoding="UTF-8"?>
<timeSeriesImportRun xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/timeSeriesImportRun.xsd">
  <import>
    <general>
     <importType>dinoservice</importType>
      <serverUrl>http://nit.dinoservices.nl:80/gws-v10/gws-v10</serverUrl>
      <relativeViewPeriod unit="day" start="-365" end="0" />
      <idMapId>IdImportDino</idMapId>
      <unitConversionsId>ImportUnitConversions</unitConversionsId>
      <importTimeZone>
        <timeZoneOffset>+00:00</timeZoneOffset>
<!--        <timeZoneOffset>+01:00</timeZoneOffset>-->
      </importTimeZone>
      <dataFeedId>tnonitg</dataFeedId>
    </general>
    <timeSeriesSet>
      <moduleInstanceId>ImportDinoService</moduleInstanceId>
      <valueType>scalar</valueType>
      <parameterId>G.m</parameterId>
      <locationId>NL-B32C0677-001</locationId>
<!--      <locationSetId>TNO-sensors(SWE)</locationSetId> -->
      <timeSeriesType>external historical</timeSeriesType>
      <timeStep unit="nonequidistant" />
      <readWriteMode>add originals</readWriteMode>
      <synchLevel>1</synchLevel>
      <expiryTime unit="day" multiplier="365"/>
    </timeSeriesSet>
    <timeSeriesSet>
      <moduleInstanceId>ImportDinoService</moduleInstanceId>
      <valueType>scalar</valueType>
      <parameterId>G.stat.gem</parameterId>
      <locationId>NL-B32C0677-001</locationId>
<!--      <locationSetId>TNO-sensors(SWE)</locationSetId> -->
      <timeSeriesType>external historical</timeSeriesType>
      <timeStep unit="nonequidistant" />
      <readWriteMode>add originals</readWriteMode>
      <synchLevel>1</synchLevel>
      <expiryTime unit="day" multiplier="365"/>
    </timeSeriesSet>
    <timeSeriesSet>
      <moduleInstanceId>ImportDinoService</moduleInstanceId>
      <valueType>scalar</valueType>
      <parameterId>G.stat.min</parameterId>
      <locationId>NL-B32C0677-001</locationId>
<!--      <locationSetId>TNO-sensors(SWE)</locationSetId> -->
      <timeSeriesType>external historical</timeSeriesType>
      <timeStep unit="nonequidistant" />
      <readWriteMode>add originals</readWriteMode>
      <synchLevel>1</synchLevel>
      <expiryTime unit="day" multiplier="365"/>
    </timeSeriesSet>
    <timeSeriesSet>
      <moduleInstanceId>ImportDinoService</moduleInstanceId>
      <valueType>scalar</valueType>
      <parameterId>G.stat.max</parameterId>
      <locationId>NL-B32C0677-001</locationId>
<!--      <locationSetId>TNO-sensors(SWE)</locationSetId> -->
      <timeSeriesType>external historical</timeSeriesType>
      <timeStep unit="nonequidistant" />
      <readWriteMode>add originals</readWriteMode>
      <synchLevel>1</synchLevel>
      <expiryTime unit="day" multiplier="365"/>
    </timeSeriesSet>    
  </import>
</timeSeriesImportRun>

IdMapFiles/

Defines mappings between DINO and FEWS parameters and locations.

MapIdDinoService.xml
<?xml version="1.0" encoding="UTF-8"?>
<idMap version="1.1" xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/idMap.xsd">


	<parameter internal="G.m" external="findMeetreeks" externalQualifier="SFL"></parameter>
	<parameter internal="G.stat.max" external="findGrondwaterStatistiek" externalQualifier="SFL" externalQualifier1="MAX_LEVEL"></parameter>
	<parameter internal="G.stat.min" external="findGrondwaterStatistiek" externalQualifier="SFL" externalQualifier1="MIN_LEVEL"></parameter>
	<parameter internal="G.stat.gem" external="findGrondwaterStatistiek" externalQualifier="SFL" externalQualifier1="MEAN_LEVEL"></parameter>
	
<!--data reeksen voor grondwatergegevens: level-->
	<location internal="NL-B01D0040-001" external="B01D0040-001"/>
	<location internal="NL-B03D0308-001" external="B03D0308-001"/>
	<location internal="NL-B03G0080-001" external="B03G0080-001"/>
	<location internal="NL-B03G0080-002" external="B03G0080-002"/>
	<location internal="NL-B06F0094-001" external="B06F0094-001"/>
	<location internal="NL-B06F0094-002" external="B06F0094-002"/>
	<location internal="NL-B06F0094-003" external="B06F0094-003"/>
	...
</idMap>	

Important in this configuration is the externalQualifier, this is used to map the statistical parameters to FEWS parameters.

GrondWaterService WSDL

GrondwaterService.wsdl

Example SOAP request and response/

Ground Water Levels - Request
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws="http://ws.gws.dino.tno.nl/">
   <soapenv:Header/>
   <soapenv:Body>
      <ws:findMeetreeks>
         <WELL_NITG_NR>B14G0057</WELL_NITG_NR>
         <WELL_TUBE_NR>002</WELL_TUBE_NR>
         <START_DATE>2007-01-01</START_DATE>
         <END_DATE>2008-12-31</END_DATE>
         <UNIT>SFL</UNIT>
      </ws:findMeetreeks>
   </soapenv:Body>
</soapenv:Envelope>
Ground Water Levels - Response
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
   <S:Body>
      <ns2:findMeetreeksResponse xmlns:ns2="http://ws.gws.dino.tno.nl/">
         <GROUND_WATER_LEVELS>
            <LEVELS>
               <DATE>2007-01-01+01:00</DATE>
               <LEVEL>187.0</LEVEL>
               <REMARK/>
            </LEVELS>
            <LEVELS>
               <DATE>2007-01-02+01:00</DATE>
               <LEVEL>190.0</LEVEL>
               <REMARK/>
            </LEVELS>
            <LEVELS>
               <DATE>2007-01-03+01:00</DATE>
               <LEVEL>193.0</LEVEL>
               <REMARK/>
            </LEVELS>
            <LEVELS>
               <DATE>2007-01-04+01:00</DATE>
               <LEVEL>188.0</LEVEL>
               <REMARK/>
            </LEVELS>
            <LEVELS>
               <DATE>2007-01-05+01:00</DATE>
               <LEVEL>190.0</LEVEL>
               <REMARK/>
            </LEVELS>
            <LEVELS>
               <DATE>2007-01-05+01:00</DATE>
               <LEVEL>189.0</LEVEL>
               <REMARK/>
            </LEVELS>
         </GROUND_WATER_LEVELS>
      </ns2:findMeetreeksResponse>
   </S:Body>
</S:Envelope>

java source code

DinoServiceTimeSeriesParser.java

  • No labels