Overview
This import is available in DELFT-FEWS versions after 2011.02
Imports ASCII type time series data in CSV formatted files. Used by FEWS-Basque
Structure of the IP1 file
The data file contains one row with data columns, seperated by a comma (,).
The columns of interest are:
Column |
Description |
Id assigned by IP1 import |
---|---|---|
1 |
code location |
- |
2 |
date/time |
- |
10 |
temperature air [in 0.1 °C] |
temperature_air |
18 |
rain [in 0.1 mm] |
precipitation |
19 |
rain corrected [in 0.1 mm] |
precipitation_corr |
21 |
water height (digital and priority) [in mm] |
waterlevel_1 |
22 |
water height (analogic) [in mm] |
waterlevel_2 |
34 |
discharge (flowmeter) [in m3/s] |
discharge |
Date/time is formatted as "yyyyMMddHHmmss"
Location ID and date/time values are inluded in " (double quotes). These are removed by the import.
The following illustrates the content of a sample data file:
"C0D2","20110912233000",0,0,0,0,0,0,0,159.1,96.7,0,0,0,0,0,0,0,0,0,190,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13.37
Configuration
To import IP1 data, configure a module like:
<?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> <!--IP1--> <general> <importType>IP1</importType> <folder>$IMPORT_FOLDER_IP1$</folder> <failedFolder>$IMPORT_FOLDER_IP1$</failedFolder> <backupFolder>$BACKUP_FOLDER_IP1$</backupFolder> <idMapId>IdImportIP1</idMapId> <unitConversionsId>ImportIP1Units</unitConversionsId> <importTimeZone> <!--EPS is in GMT--> <timeZoneOffset>+00:00</timeZoneOffset> </importTimeZone> <dataFeedId>IP1-DF</dataFeedId> <reportChangedValues>true</reportChangedValues> </general> <timeSeriesSet> <moduleInstanceId>ImportIP1</moduleInstanceId> <valueType>scalar</valueType> <parameterId>wlevel</parameterId> <locationSetId>IP1</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minutes" multiplier="10"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> <expiryTime unit="day"/> <ensembleId>IP1</ensembleId> </timeSeriesSet> <timeSeriesSet> <moduleInstanceId>ImportIP1</moduleInstanceId> <valueType>scalar</valueType> <parameterId>T_air</parameterId> <locationSetId>IP1</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minutes" multiplier="10"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> <expiryTime unit="day"/> <ensembleId>IP1</ensembleId> </timeSeriesSet> <timeSeriesSet> <moduleInstanceId>ImportIP1</moduleInstanceId> <valueType>scalar</valueType> <parameterId>Precip</parameterId> <locationSetId>IP1</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minutes" multiplier="10"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> <expiryTime unit="day"/> <ensembleId>IP1</ensembleId> </timeSeriesSet> <timeSeriesSet> <moduleInstanceId>ImportIP1</moduleInstanceId> <valueType>scalar</valueType> <parameterId>wlevel_ana</parameterId> <locationSetId>IP1</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minutes" multiplier="10"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> <expiryTime unit="day"/> <ensembleId>IP1</ensembleId> </timeSeriesSet> <timeSeriesSet> <moduleInstanceId>ImportIP1</moduleInstanceId> <valueType>scalar</valueType> <parameterId>Discharge</parameterId> <locationSetId>IP1</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minutes" multiplier="10"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> <expiryTime unit="day"/> <ensembleId>IP1</ensembleId> </timeSeriesSet> <externUnit parameterId="Precip" unit="0.1 mm" cumulativeSum="true"/> <externUnit parameterId="T_air" unit="0.1 mm" cumulativeSum="true"/> </import> </timeSeriesImportRun>
idMapping
The parser assigns IDs for the parameters as indicated in the table above.
To map these to current FEWS parameters an idMapping can be configured.
For example:
<?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 external="waterlevel_1" internal="wlevel"/> <parameter external="waterlevel_2" internal="wlevel_ana"/> <parameter external="temperature_air" internal="T_air"/> <parameter external="precipitation" internal="Precip"/> <parameter external="discharge" internal="Discharge"/> <location external="C0D2" internal="KNMI_NL001"/> </idMap>