Overview
Excerpt | ||
---|---|---|
| ||
Imports ASCII type time series data from CSV formatted files. |
Note |
---|
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:
No Format |
---|
"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:
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>
<!--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:
Code Block | ||||
---|---|---|---|---|
| ||||
<?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>
|
...