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 value column is needed to create a time series in Delft-FEWS.

COMMENT;DATE;VALUE
Comment 1;01-12-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:

<?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$/Import_comments</folder>
			<fileNamePatternFilter>*.csv</fileNamePatternFilter>
			<failedFolder>$IMPORT_FAILED_FOLDER$/Import_comments</failedFolder>
			<deleteImportedFiles>false</deleteImportedFiles>
			<table>
				<dateTimeColumn name="DATE" pattern="dd-MM-yyyy HH:mm"/>
				<commentColumn name="COMMENT"/>
				<valueColumn name="VALUE"/>
			</table>
			<idMapId>IdImportOBS</idMapId>
		</general>
		<timeSeriesSet>
			<moduleInstanceId>Import_comments</moduleInstanceId>
			<valueType>scalar</valueType>
			<parameterId>Comment</parameterId>
			<locationId>Comment_loc</locationId>
			<timeSeriesType>external historical</timeSeriesType>
			<timeStep unit="nonequidistant"/>
			<readWriteMode>add originals</readWriteMode>
			<synchLevel>1</synchLevel>
			<expiryTime unit="year" multiplier="5"/>
		</timeSeriesSet>
	</import>
</timeSeriesImportRun>
  


With idImportOBS:

<?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">
	<enableOneToOneMapping/>
</idMap>



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

	<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="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:

<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

Disclaimer