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 | - | ||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1720451d-dd19-47d5-804c-2132a28ddf2a"><ac:plain-text-body><![CDATA[ | 10 | temperature air [in 0.1 °C] | temperature_air | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f49db084-7bb2-44ff-bfb2-a81ca3e3ddbf"><ac:plain-text-body><![CDATA[ | 18 | rain [in 0.1 mm] | precipitation | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="3f07616d-9f10-4e6a-a6a2-8c82f5cc350e"><ac:plain-text-body><![CDATA[ | 21 | water height (digital and priority) [in mm] | waterlevel_1 | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="ec3c5a94-1b06-46f7-a41c-0e67b5e52c21"><ac:plain-text-body><![CDATA[ | 22 | water height (analogic) [in mm] | waterlevel_2 | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="bed9a299-c519-4d57-94f7-0601d0b31429"><ac:plain-text-body><![CDATA[ | 34 | discharge (flowmeter) [in m3/s] | discharge | ]]></ac:plain-text-body></ac:structured-macro> |
Date/time is formatted as "dd.MM.yyyy HH:mm"
The following snippet illustrates 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>
<!--Bayern-->
<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>Bayern</locationSetId>
<timeSeriesType>external forecasting</timeSeriesType>
<timeStep unit="hour" multiplier="1"/>
<readWriteMode>add originals</readWriteMode>
<synchLevel>1</synchLevel>
<expiryTime unit="day"/>
<ensembleId>IP1</ensembleId>
</timeSeriesSet>
</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"/>
<location external="C0D2" internal="KNMI_NL001"/>
</idMap>
|
...