Page History

...

Hi,
I would like to display vertical lines in a time series graph on a specific date/time with a text lable from an attribute table. I have added an example figure as attachment. The vertical lines and the black text are what I want to see in a graph. These lines represents the moments when a measurement location was calibrated and display which action was undertaken.
Is such unctionality available in Delft-FEWS?

...

This can be achieved by using the display vertical lines with comments.

Step 1:
Create a CSV file containing the information you would like to show in Delft-FEWS. The CSV should contain Delft-FEWS supports the functionality to read comments only. Empty values will be stored at these date/time steps.

COMMENTWLOCATION;DATE;TIME;VALUE
CommentLocationID1Comment 1;1801-12-2015;04:01:22;
CommentLocationID2;17-12-2014;06:22:31;
CommentLocationID3;17-12-2014;06:24:17;2022 12:00;1
Comment 2;01-12-2022 15:00;1
Comment 3;01-12-2022 16:00;1

Comment Step 2:
The information needs to be imported. Make sure to add the new parameterId (e.g. Comment). This distinguishes this TimeSeriesSets from others and it is essential for displaying the vertical lines at the right timestep. The importer could look similar to the importer below:

Code Block

language	xml

<?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>generalCSV</importType>
			<folder>$IMPORT_FOLDER$/yourImport_folder<comments</folder>
			<fileNamePatternFilter>yourfile<fileNamePatternFilter>*.csv</fileNamePatternFilter>
			<failedFolder>$IMPORT_FAILED_FOLDER$<FOLDER$/Import_comments</failedFolder>
		<backupFolder>$IMPORT_BACKUP_FOLDER$</backupFolder>
		<deleteImportedFiles>false</deleteImportedFiles>
			<table>
			<locationColumn/>
			<dateColumn<dateTimeColumn name="DATE" pattern="dd-MM-yyyy HH:mm"/>
				<timeColumn<commentColumn patternname="HH:mm:ssCOMMENT"/>
				<commentColumn<valueColumn name="VALUE"/>
			<parameterColumn/>
		</table>
		<idMapId>IdImport<	<idMapId>IdImportOBS</idMapId>
		<importTimeZone>
			<timeZoneOffset>+01:00</timeZoneOffset>
		</importTimeZone>general>
	</general>
	<timeSeriesSet>
		<moduleInstanceId>Import<	<moduleInstanceId>Import_comments</moduleInstanceId>
			<valueType>scalar</valueType>
			<parameterId>Comment</parameterId>
			<locationSetId>Comment<locationId>Comment_LocationSets<loc</locationSetId>locationId>
			<timeSeriesType>external historical</timeSeriesType>
			<timeStep unit="nonequidistant"/>
			<readWriteMode>add originals</readWriteMode>
			<synchLevel>1</synchLevel>
			<expiryTime unit="year" multiplier="5"/>
		</timeSeriesSet>
	</import>
</timeSeriesImportRun>

Step 3:
In the RegionConfigFiles add the new parameterId to the parameters.xml and add the timeseries to the filters.xml

Code Block

language	xml

<timeSeriesSet>
    <moduleInstanceId>Import</moduleInstanceId>
    <valueType>scalar</valueType>
    <parameterId>Comment</parameterId>
    <locationSetId>Comment_LocationSets</locationSetId>
    	<parameterGroups>
		<parameterGroup id="Comment_group">
			<parameterType>instantaneous</parameterType>
			<unit>-</unit>
			<parameter id="Comment">
				<shortName>Comment</shortName>
			</parameter>
		</parameterGroup>
	</parameterGroups>

	<filter id="comment_show">
		<timeSeriesSet>
			<moduleInstanceId>Import_csv_test</moduleInstanceId>
			<valueType>scalar</valueType>
			<parameterId>Comment</parameterId>
			<locationId>Comment_loc</locationId>
			<timeSeriesType>external historical</timeSeriesType>
    			<timeStep unit="nonequidistant"/>
    			<relativeViewPeriod unit="day" start="-2" end="0" startOverrulable="true" endOverrulable="false"/>
    <readWriteMode>editing visible to all future task runs</readWriteMode>
</timeSeriesSet>2"/>
			<readWriteMode>read only</readWriteMode>
		</timeSeriesSet>
		<timeSeriesSet>
			<moduleInstanceId>LMW_Import_Measurements</moduleInstanceId>
			<valueType>scalar</valueType>
			<parameterId>H.meting</parameterId>
			<locationId>GOUD</locationId>
			<timeSeriesType>external historical</timeSeriesType>
			<timeStep unit="minute" multiplier="10"/>
			<relativeViewPeriod unit="day" start="-3" end="1"/>
			<readWriteMode>read only</readWriteMode>
		</timeSeriesSet>
	</filter>

Step 4: In the SystemConfigFiles\TimeSeriesDisplayConfig.xml add the following:

Code Block

language	xml

<parameterDisplayOptions id="Comment">
	<preferredColor>orange</preferredColor>
	<lineStyle>verticalLine</lineStyle>
</parameterDisplayOptions>

Step 5:
Enjoy looking at vertical lines when you select the Comment parameter in combination with your 'waterhoogte' parameter.

Image Added

Page tree

Versions Compared

Old Version 1

New Version 2

Key