Overview

Imports time series data from tabular ASCII formatted file

Input file structure

The input file is of ASCII type. Data is structured in 14 columns, separated by a whitespace.

The following snippet illustrates a sample data file :

810 2009 4 18 8 0.0000 4.5400 76.3414 122.3708 14.0900 1.5760 50.9380 0.0505 6.4438
810 2009 4 18 9 0.0000 5.2833 68.0622 221.7067 22.5300 2.0883 50.4450 0.0485 6.0487
810 2009 4 18 10 0.0000 6.1333 60.2494 248.2750 19.9600 2.5067 49.6933 0.0475 5.6804



The next table explains the columns from the input and states what parameter ID and parameter unit is assigned by the time series parser during import:

Column

Parameter description

Assigned parameter ID

unit

1

Location ID

-

-

2

Year

-

-

3

Month

-

-

4

Day

-

-

5

Hour

-

-

6

Precipitation

precipitation

mm

7

Air temperature

air_temperature

degc

8

Relative humidity

relative_humidity

%

9

Global radiation

global_radiation

W/m2

10

Sunshine duration

sunshine_duration

min

11

Wind speed

windspeed

m/s

12

Snow depth

snow_depth

cm

13

Discharge

discharge

m3/s

14

Vapour pressure

vapour_pressure

hPa


During import the location ID is set to the (numeric) value found in the first column of the row.

The time stamp is created from the next 4 columns (year, month, day, hour); minutes are set to zero, so values are hourly.

Configuration

To import configure a module like this:

<?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>
		<general>
			<importType>IFKIS</importType>
			<folder>$IMPORT_FOLDER_IFKIS$</folder>
			<failedFolder>$IMPORT_FOLDER_IFKIS$</failedFolder>
			<backupFolder>$IMPORT_FOLDER_IFKIS$</backupFolder>
			<idMapId>IdImportIFKIS</idMapId>
			<importTimeZone>
				<timeZoneOffset>+01:00</timeZoneOffset>
			</importTimeZone>
			<dataFeedId>IFKIS-DF</dataFeedId>
			<reportChangedValues>true</reportChangedValues>
		</general>
		<timeSeriesSet>
			<moduleInstanceId>ImportIFKIS</moduleInstanceId>
			<valueType>scalar</valueType>
			<parameterId>P</parameterId>
			<locationSetId>IFKIS-LOCS</locationSetId>
			<timeSeriesType>external historical</timeSeriesType>
			<timeStep unit="hour" multiplier="1"/>
			<readWriteMode>add originals</readWriteMode>
			<synchLevel>1</synchLevel>
		</timeSeriesSet>

                    .
                    .
                    .


	</import>
</timeSeriesImportRun>

idMapping

The parser assigns the numerical ID found on each row to LocationID.
Parameters are named by the parser according to the table above.
To map these to current FEWS location and parameter 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="precipitation" internal="P"/>
     <location external="810" internal="The_FEWS_location1"/>
</idMap>
  • No labels

Disclaimer