| Table of Contents |
|---|
Introduction
The Time Series Lister is a display to verify and inspect time series which are written to the database in any workflow.
...
The Time Series Lister is a pre configured display and a very handy tool for inspecting the contents of the FEWS database (localdatastore). It provides an overview in tabular form of statistics and other metadata (columns) of the timeseries (rows) in the database. To aid the inspection of data, the user can add or remove columns, and select and filter rows. From the Time Series Lister it is also possible to access the content (=values) of selected timeseries by opening the timeseries display or the spatial (grid) display.
Configuration
To enable the Time Series Lister, it must be added as explorertask in Explorer.xml:
| No Format |
|---|
<explorerTask name="Timeseries Lister"> <iconFile>tableInfo.jpg</iconFile> <taskClass>nl.wldelft.fews.gui.plugin.timeseriestableviewer.TimeSeriesTableViewer</taskClass> <toolbarTask>true</toolbarTask> <menubarTask>true</menubarTask> <allowMultipleInstances>false</allowMultipleInstances> <accelerator>ctrl T</accelerator> </explorerTask> |
Usage
The Time Series Lister enables the user to inspect the database. The database records are visualised as individual rows, which can be selected. When selected it can be browsed through (all columns) or its values can be inspected through a graph (scalar series) or the spatial display (grid data).
...
Menu option | Shortcut | Functionality | Alternative | Remark | Visible effect |
|---|---|---|---|---|---|
Filter for selection | <insert> | Uses the cell content as a filter | Doubleclicking the cell | You can set different filters in different columns | Cell background turns blue |
Remove filter for column | <F3> | Show all timeseries (again) for this column | Doubleclicking the blue cell | Cell background turns white | |
Remove all filters | <F6> | Show all timeseries (again) | Doubleclicking the blue cell | Cell background turns white | |
Sort column | <F7> | Sort the content of the column | Clicking the header | ||
Select columns | <F8> | Opens a dialog for selecting the columns | |||
Show Timeseries Dialog | <F10> | Opens the TimeSeriesDialog and shows | |||
Show Spatial Display | <F11> | Opens the Spatial Display and shows | |||
| Show Rating Curve | SHIFT + <F12> | Opens the TimeSeriesDialog and shows the details of the selected rating curve | |||
Copy TimeseriesSet.xml to clipboard | Copies the TimeSeriesSet in XML format | Shows the XML in popup | |||
Highlight in workflow navigator | Highlights selected time series in workflow navigator | Workflow navigator will be shown | |||
Export to CSV | Exports the tabular overview of (filtered) timeserie(s) to a CSV file | For exporting the data to a CSV file, use the Timeseries Dialog (select the data in the table and use context menu / save as...) | File dialog opens for saving the CSV file |
Special Filter option: Start time / End time
Two columns have special features: The Start and End time columns can be used to increase or limit the view period. If you adjust these all statistical columns or columns showing information about quality flags and (secondary) validation will be adjusted automatically.
...
figure 3: Special filter in the Start/End time columns
Meta Data Elements / Select Columns (F8)
figure 4: Selecting different columns (elements) in the Time Series Lister
...
figure 5: Copying the selection of columns to clipboard
figure 6: Pasting the selection of columns from the clipboard
Delete module instance from Time Series Lister
From build 2016.02 it is possible to remove module instances from Local Data Store via Time Series Lister. This function only exists in FEWS stand alone mode. The procedure is as follows:
...