Forum

RE: Vertical lines in time series graph with text from table

CV
Chiel van van Brunschot, modified 15 Days ago.

Vertical lines in time series graph with text from table

Youngling Posts: 1 Join Date: 6/21/19 Recent Posts
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?
HH
Herman Haaksma, modified 6 Days ago.

RE: Vertical lines in time series graph with text from table

Youngling Posts: 1 Join Date: 11/4/13 Recent Posts
Hello Chiel van Brunschot,

There is no direct solution in Delft-FEWS as far as I know. However, there is a workaround that is being used in other systems to display vertical lines with comments.

Step 1:
Create a CSV file containing the information you would like to show in Delft-FEWS. Delft-FEWS supports the functionality to read comments only. Empty values will be stored at these date/time steps.
WLOCATION;DATE;TIME;TYPELocationID1;16-12-2014;04:01:22;
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 similarly 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.
<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>

In the SystemConfigFiles\TimeSeriesDisplayConfig.xml  add the following:
<parameterDisplayOptions id="Comment"><preferredColor>orange</preferredColor><lineStyle>verticalLine</lineStyle></parameterDisplayOptions>

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

Herman Haaksma