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

Disclaimer