Data Display and Data Editor
The Data Display and Data Editor offer graphical displays for presenting and editing of data. Both have the nearly the same functionality but only the Data Editor allows you to edit data.
This display offers the following features:
- Display of time series in:
- graphs
- tables
- Tabular data editor
- Display of actual data with:
- Historical events__
- Threshold levels__
Data is displayed in a table and a graph simultaneously. The splitter between the table and the graph can be moved to modify the display. Select the data series, that should be displayed with help of the List Boxes and/or the Map Display (see also Filters ).
When the display is started through the FEWS Tools menu item Data Editor , data can be edited and the edited data can be stored in the FEWS data base. When the display is started through the FEWS Tools menu item Data Display or through the FEWS toolbar, the data can only be viewed.
1.1 <ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="c8a58d66-05e6-4291-9843-aea9da521eb3"><ac:parameter ac:name="">_Toc172823841</ac:parameter></ac:structured-macro><ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="5bec13c4-0a7d-4019-b4ed-478495a9de2a"><ac:parameter ac:name="">_Toc140564169</ac:parameter></ac:structured-macro>Data Display
Press the [Data Display ] button on the toolbar to present graphs displaying the data. The splitter is normally positioned on the left of the display.
When data series of different data types have been selected, the data will be presented in different subplots with the data series of a single data type merged into one subplot.
The data in the graph is updated automatically in case new data becomes available.
Following buttons are used in the Time Series Display:
Table
By clicking this button the time series in the graph is also displayed in tabular format. Please note that in case you like to edit data, you have to select the Data Editor from the Tools menu (see section 4.3).
Shortcuts
Display templates are available for rapid assessment of data. The templates can be activated by clicking the above mentioned button. The left side of the display shows the available shortcuts in a pre-configured grouping.
The data shown via the Shortcuts belong to the forecasts selected in the Forecasts panel of the FEWS Explorer. Please note that the current forecast is always displayed in the graphs.
Rotate Splitter
With this button the splitter between table and graph can be placed in a horizontal position. Clicking the same button again returns the splitter to its default vertical position.
Rotate Legend
This button can be used to place the graph legend underneath the graph. Clicking the same button again returns the legend to its default position at the right hand side of the graph.
Toggle Graph
When multiple data series are selected for a single data type (parameter), the graphs will be placed in one subplot of the graph. This sometimes complicates the analysis of time series with different data ranges. By clicking the above mentioned button you can change the layout of the chart:
- Merged into a single graph
- Stacked in different subplots
Scale to show unreliable Data
This button can be used to focus on time intervals with unreliable data within the selected time series. Data is marked as unreliable, if values exceed hard limits.
Show no Thresholds
By clicking this button all pre-configured thresholds which can also be shown in the graphs with the selected time series disappear.
Scale to show relevant Thresholds
With this option the graph is scaled in such a way, that relevant thresholds (the closest threshold values) are displayed together with the selected time series in the graph.
Scale to show all Thresholds
This button can be used to show all pre-configured thresholds of a certain parameter at the selected location(s). This means that all thresholds levels (e.g. Standby, Flood Watch, Flood Warning and Severe Flood Warning) are displayed in the graph.
Show data labels
Clicking the 'Show data labels' will you to display quality flags for the data you are presenting. The information is shown at the bottom of the screen.
The following clolour codes have been used:
- the upper line indicates the origin of the data
- original data: no line is displayed
- corrected data (original data flagged as unreliable and automatically interpolated): blue line
- completed data (original data is missing and interpolated by system): magenta line
- the middle line indicates the quality of the data
- reliable data: no line is displayed
- doubtful data: light yellow
- unreliable data: dark yellow
- the lower line indicates where comments have been added to the data
- no comment: no line is displayed
- comment available: dark red
The lines are displayed under the data points. The colours correspond with the colouring used in the tables.
Historical Events
With this button historical events can be activated (provided that they are pre-configured). They will be displayed in the same graph to enable a comparison with the actual timeseries. Further explanation is given in section 4.4.
Display time
To change the view period in the graph, the field Display time in the Status Bar below the graph should be double clicked. The display time can now be changed with help of the menu. Press [OK ] to accept the changed view period. The next time the chart is opened the original configured display time will be used again.
Datum Toggle
The Datum Toggle at the lower right hand corner of the display allows levels to be displayed with reference to Local Datum or mAOD .
Navigating in Graphs
Zooming in and out can be done with help of the scroll wheel of the mouse. Scrolling away from the user results in zooming in while scrolling towards the user results in zooming out.
Zooming is also possible by selecting a zoom range. Drag the mouse holding down the right button to form a rectangular area to zoom in to.
When clicking the right mouse button, the dropdown menu presented below appears. The menu gives you some additional options.
Save As
You can save the graph to file with this option.
This option allows you to print the graph.
Zoom in & out
You can select to zoom in and out along one or both axis with this option.
Allow Domain / Range Axis Zoom
You can select to allow for zooming in and out along one of the axis with this option.
Auto Range
This feature allows you the set automatic scaling along one or both axis.
Data Editor
Select the Data Editor option of the FEWS Tools menu to present tables displaying the data. The splitter can be positioned in such a way, that the complete table is visible.
The most left column shows the date and time of the data. The period displayed spans the overall period defined in the filters for all time series.
The colours in the headings of the columns correspond with the line colour in the graph.
In the date/time column different colours are used to provide a logical meaning to certain important moments:
- Light blue: historical data, either observed or hindcast (data before T~0~ )
- Dark blue: forecast data (data after T~0~ )
For the data columns the background colour is used to indicate the quality of the data, identified by the data flags set of the Validation utility. Further, an indication of the editability of the data is given by the the background colour. The meaning of the background colours in the data fields is:
- White: reliable, editable
- Light yellow: doubtful
- Bright yellow: unreliable
- Gray: not editable
The font colour in the data fields indicates the data origin. Following colours are used:
- Black: original data
- Blue: corrected (original data flagged "Unreliable" and interpolated)
- Magenta: completed (original data missing and interpolated)
Data (only those with a white background) can be edited by double clicking a field in the column. Editing may be done in the table directly. The result of an edit action is directly displayed in the corresponding graph. Manually corrected data will be saved to the database by clicking [Apply ]. With [Cancel ] before saving, changes can be undone. With [Enter ] the changes are validated.
Through manual editing of data, the source of the data changes from original to corrected. The font colour used for edited data is blue to indicate that it is completed data. The background colour remains white, as the data has not yet been validated. If however, after pressing [Apply ] validation indicates that the value exceeds certain validation limits, the background colour will be set accordingly.
Editing Data
By pressing the right mouse button a list with edit actions appears on the screen. These includes to copy and fill in data. The display that pops up after clicking the right mouse button is shown below.
The options have the following meaning...
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1258ae44-fe5c-44d6-a815-f5080e2d7bb1"><ac:plain-text-body><![CDATA[ |
[Select All] |
Select all data displayed in the editor |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f71c65b9-4b83-49d4-84e7-4601efd20226"><ac:plain-text-body><![CDATA[ |
[Select Column] |
Select all data in the column in which the cursor is placed |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="93ea28ea-5e83-4059-bf40-6b1a62c1ce06"><ac:plain-text-body><![CDATA[ |
[Select Row] |
Select all data in the row in which the cursor is placed |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="08b2cf79-7bf5-46c0-9b19-74f2e17e120f"><ac:plain-text-body><![CDATA[ |
[Expand Selection] |
Select all data in the row in which the cursor is placed |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="54791667-32db-4552-9cbc-544f0e4ca6e5"><ac:plain-text-body><![CDATA[ |
[Edit Value] |
The cell on which the cursor is place can be edited |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f4f7986d-f698-4de1-8e89-e38de5825cb8"><ac:plain-text-body><![CDATA[ |
[Cut] |
Move the selected data (including the date / time field) to the clipboard |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="92f4f576-983c-4ce7-bda5-e1a8a774658e"><ac:plain-text-body><![CDATA[ |
[Copy] |
Copy the selected data (included the date / time field) to the clipboard |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="bd3e4518-baca-4402-9812-ca47619f2e80"><ac:plain-text-body><![CDATA[ |
[Copy Values Only] |
Copy the data values in the selection to the clipboard |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="77896579-9bb6-4ab3-bd33-3e8f0830d6aa"><ac:plain-text-body><![CDATA[ |
[Copy Reliable Values Only] |
Copy the data values in the selection classified as reliable to the clipboard |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="988c8830-b8b7-4cfc-87a7-876f81111a83"><ac:plain-text-body><![CDATA[ |
[Copy Reliable and Doubtful Values Only] |
Copy the data values in the selection classified as reliable and doubtful to the clipboard |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="3b79b309-f9da-4b93-9401-8cab5ae62f31"><ac:plain-text-body><![CDATA[ |
[Copy Times Only] |
Copy the selected date / time in the selection to clipboard |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="70c8dcbc-77ba-48d6-8dad-94d17efc7e38"><ac:plain-text-body><![CDATA[ |
[Paste] |
Paste the data from the clipboard into the selected fields |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2ff36bb8-98e0-48d7-82a6-b99bfcdca011"><ac:plain-text-body><![CDATA[ |
[Clear] |
Delete the data values in the selection |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b08c7e0f-b01b-4bb6-a3d3-f4ce2abd11e7"><ac:plain-text-body><![CDATA[ |
[Clear Doubtfuls] |
Delete the data values in the selection classified as doubtful |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="00ee79ef-4386-47b5-a9b9-835cd9b22038"><ac:plain-text-body><![CDATA[ |
[Clear Unreliables] |
Delete the data values in the selection classified as unreliable |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="726e1217-c47a-4004-82be-e78b935c48a2"><ac:plain-text-body><![CDATA[ |
[Block Fill Missing Data] |
Fill the selected fields with the last value available value in the same column |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="02ef7253-c600-43db-b1cc-a205c555963d"><ac:plain-text-body><![CDATA[ |
[Lineair Fill Missing Data] |
Apply lineair interpolation when filling in the selected fields |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="fcb05541-fb0c-43f3-8d47-dda8757bde9f"><ac:plain-text-body><![CDATA[ |
[Fill Missing Data from Clipboard] |
Fill in the selected fields with data copied to the clipboard |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="4b25dbea-a901-4a3f-b864-e2945ed41313"><ac:plain-text-body><![CDATA[ |
[Set maximum fill gap] |
Set the maximum gap size to be interpolated |
]]></ac:plain-text-body></ac:structured-macro> |
Historic Events
A special option in the Data Display is the option to add historic events to the chart window.
To show historic events for a specific location take following steps:
- Select the location from the location list box in the FEWS explorer
- Select the parameter from the parameter list box
- Open the chart display by pressing the chart button
- Press the button in the Chart Display and select one of the historical events from the list
A new (red) line will be added to the chart. This event line can now be shifted forwards and backwards in time using the "+" and "-" keys on your keyboard. To activate this shift procedure press the [Historic Events ] button in the Chart Display and select Shift Time.
A small pop-up window shows that you can now shift the historic event forwards and backwards by pressing the "+" or "-" keys on your keyboard. When the shift procedure is completed press [Done ].