Overview

Imports time series data from the TNO DINO files.

There are two types of DINO ASCII files:

  • GWS_PutXXXXXXX files
  • Put_XXXXXXX files

Where XXXXXX is the location ID.

Status

  • Import is coded and tested.
  • Both file types can be imported.
  • File can be ',' or ';' seperated

Not yet supported:

  • The column "BIJZONDERHEID" is not yet imported or interpreted. 

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.

ImportDINO.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>DINO</importType>
      <folder>$IMPORT_FOLDER_DINO$</folder>
      <failedFolder>$IMPORT_FAILED_FOLDER_DINO$</failedFolder>
      <idMapId>IdImportDINO</idMapId>
      <unitConversionsId>ImportUnitConversions</unitConversionsId>
      <importTimeZone>
        <timeZoneOffset>+01:00</timeZoneOffset>
      </importTimeZone>
      <dataFeedId>DINO</dataFeedId>
    </general>
    <timeSeriesSet>
      <moduleInstanceId>ImportDINO</moduleInstanceId>
      <valueType>scalar</valueType>
      <parameterId>G.meting</parameterId>
      <locationSetId>DINO_G.meting_nonequidistant</locationSetId>
      <timeSeriesType>external historical</timeSeriesType>
      <timeStep unit="nonequidistant"/>
      <readWriteMode>add originals</readWriteMode>
      <synchLevel>1</synchLevel>
    </timeSeriesSet>
  </import>
</timeSeriesImportRun>

IdMapFiles/

Defines mappings between DINO and FEWS parameters and locations.

MapIdTmx.xml
<?xml version="1.0" encoding="UTF-8"?>
<idMap 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" version="1.1">
	<!--DINO locaties-->
	<map internalLocation="B45F0142" internalParameter="G.meting" externalLocation="B45F0142" externalParameter="STAND (MV)" externalParameterQualifier="1"/>
	<map internalLocation="B51F0423" internalParameter="G.meting" externalLocation="B51F0423" externalParameter="STAND (MV)" externalParameterQualifier="1"/>
</idMap>

Important in this configuration is the externalParameterQualifier, this is used to indicate the Filternumber.

Example File/

GWS_PutB45H0224.csv
Titel: null;;;;;;;;;;;
Gebruikersnaam: AAAAAAAAA;;;;;;;;;;;
Periode aangevraagd: 01/01/1800-12/09/2007;;;;;;;;;;;
Datum: 12/09/2007;;;;;;;;;;;
Referentie: Maaiveld (MV);;;;;;;;;;;

LOCATIE;FILTERNUMMER;EXTERNE AANDUIDING;X-COORDINAAT;Y-COORDINAAT;MAAIVELD NAP;GESCHAT;MEETPUNT NAP;BOVENKANT FILTER;ONDERKANT FILTER;START DATUM;EIND DATUM
B45H0224;1;45HL0037;179790;408310;1691;;1696;1496;1446;28-2-1974;6-12-1989
B45H0224;1;45HL0037;179790;408310;1691;;1684;1534;1484;6-12-1989;29-11-1999

LOCATIE;FILTERNUMMER;PEIL DATUM TIJD;STAND (MV);BIJZONDERHEID;;;;;;;
B45H0224;1;28-2-1974 12:02;103;;;;;;;;
B45H0224;1;14-3-1974 12:03;95;;;;;;;;
B45H0224;1;28-3-1974 12:03;97;;;;;;;;
B45H0224;1;16-4-1974 12:04;110;;;;;;;;
B45H0224;1;29-4-1974 12:04;106;;;;;;;;
B45H0224;1;14-5-1974 12:05;106
B45H0224;1;28-5-1974 12:05;115
B45H0224;1;14-6-1974 12:06;113
B45H0224;1;28-6-1974 12:06;100

java source code

DinoTimeSeriesParser.java

  • No labels