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.
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<?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/
Info |
---|
Defines mappings between DINO and FEWS parameters and locations. |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<?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/
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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.javaDINO Groundwater Data