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

Compare with Current View Page History

Version 1 Next »

Original question

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?

Solution

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.
WLOCATION;DATE;TIME;

CommentLocationID1;18-12-2015;04:01:22;
CommentLocationID2;17-12-2014;06:22:31;
CommentLocationID3;17-12-2014;06:24:17;

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:

<import>
	<general>
		<importType>generalCSV</importType>
		<folder>$IMPORT_FOLDER$/your_folder</folder>
		<fileNamePatternFilter>yourfile*.csv</fileNamePatternFilter>
		<failedFolder>$IMPORT_FAILED_FOLDER$</failedFolder>
		<backupFolder>$IMPORT_BACKUP_FOLDER$</backupFolder>
		<deleteImportedFiles>false</deleteImportedFiles>
		<table>
			<locationColumn/>
			<dateColumn pattern="dd-MM-yyyy"/>
			<timeColumn pattern="HH:mm:ss"/>
			<commentColumn/>
			<parameterColumn/>
		</table>
		<idMapId>IdImport</idMapId>
		<importTimeZone>
			<timeZoneOffset>+01:00</timeZoneOffset>
		</importTimeZone>
	</general>
	<timeSeriesSet>
		<moduleInstanceId>Import</moduleInstanceId>
		<valueType>scalar</valueType>
		<parameterId>Comment</parameterId>
		<locationSetId>Comment_LocationSets</locationSetId>
		<timeSeriesType>external historical</timeSeriesType>
		<timeStep unit="nonequidistant"/>
		<readWriteMode>add originals</readWriteMode>
		<synchLevel>1</synchLevel>
	</timeSeriesSet>
</import>



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

<timeSeriesSet>
    <moduleInstanceId>Import</moduleInstanceId>
    <valueType>scalar</valueType>
    <parameterId>Comment</parameterId>
    <locationSetId>Comment_LocationSets</locationSetId>
    <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>



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

<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.

  • No labels