You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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

-

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e03e4ff0-28a8-42b8-9491-0ccb14d0fe67"><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="fe85286c-730f-4cc8-9171-d35299ad12c7"><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="794320ee-bbe7-42c1-be02-4547f182f227"><ac:plain-text-body><![CDATA[

19

rain corrected [in 0.1 mm]

precipitation_corr

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b71ef1eb-900c-4357-96ac-9a82ac9ae141"><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="93a85c3c-a7de-4d1c-a69a-5ab02db25c17"><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="df882867-3867-4a4a-b3c7-d27254da78d4"><ac:plain-text-body><![CDATA[

34

discharge (flowmeter) [in m3/s]

discharge

]]></ac:plain-text-body></ac:structured-macro>

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>
  • No labels

Disclaimer