Introduction
The Time Series Lister is a display to verify and inspect time series which are written to the database in any workflow.
figure 1a: the GUI of the Time Series Lister (with a workflow selected)
When a filter - location - parameter selection is made via the Data Viewer, the Time Series Lister results will be filtered accordingly.
figure 1bfigure 1: the GUI of the Database ViewerTime Series Lister (with a workflow selected AND a Data Viewer selection)
The Time Series Lister is a pre configured display and a very handy The database viewer is a configuration support 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 Database Viewer From the Time Series Lister it is also possible to access the content (=values) of selected timeseries by opening the timeseries dialog. The database viewer is available in two different modes:
- Workflow based database viewer - for each available workflow, all timeseries written to the database in that workflow can be inspected. From the Explorer, the Database Viewer can be accessed using <F12> + J.
- Timeseries lister - for the selection made in the Data Viewer or Forecasts (Explorer Tabs) all available timeseries in the database are listed and can be inspected. To enable this mode, some configuration is required.
Configuration (mode: timeseries lister)
display or the spatial (grid) display.
Configuration
To enable the Time Series ListerTo enable the timeseries 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 database viewer 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).
...
This filter mechanism is applicable on all available columns, including the Start and End Time. When the users changes the start and/or end time, the visible columns will be updated accordingly.
Two types of filters - with or without data hierarchy
Note well that there are two modes for using the Database Viewer. When using the filters on the top of the screen of the database viewer, the timeseries can be viewed as they are available in the database. However, when using the other filters from for instance FEWS-Explorer (left below), the database viewer shows the timeseries as they are in the data hierarchy. In the first case this means that external data with a scenario can be made visible, and in the latter case, the external timeseries are viewed as they were imported, i.e. without the scenario applied. For more info read about the fews data hierarchy.
Context Menu Options (lower table)
figure 2: context menu of the Database ViewerTime Series Lister
The Graphical User Interface contains a number of context menu options for selection/filtering and inspection of data. Right-click the mouse on one of the cells to access the context menu.
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.
Doubleclicking in these time columns will provide the user with the following, see figure below.
figure 3: Special filter in the Start/End time columns
Meta Data Elements / Select Columns (F8)
figure 4: Selecting different columns (elements) in the Database ViewerTime Series Lister
The meta data elements are grouped as follows.
...
The list of available columns can be adjusted by (un)selecting the individual elements. Only the selected ones will be visible in Database Viewer Time Series Lister after confirming by clicking <OK>.
Selections can be copied to the clipboard (<Copy Selection> button) and adjusted in a text editor (figure 5). These lists can be shared amongst users (e.g. e-mail). From a text editor you can adjust the list by removing rows, select the remaining rows and then copy it the clipboard (<CTRL+C>) again. After that use the <Paste Selection> button to update your selected columns (figure 6). See below: 
figure 5: Copying the selection of columns to clipboard
figure 6: Pasting the selection of columns from the clipboard
Delete module instance from Database ViewerTime Series Lister
From build 2016.02 it is possible to remove module instances from Local Data Store via Database ViewerTime Series Lister. This function only exists in FEWS stand alone mode. The procedure is as follows:
- In Database ViewerTime Series Lister, select one workflow, press F12, a menu will pop out (figure 7).
figure 7: F12 <F12> menu in Database ViewerTime Series Lister
2. Select '9 Delete module instance for selection', the module instances in this workflow will be displayed for selection. One can select the module instances that should be removed from the database.
figure 8: select module instances to be removed from database
3. Press 'OK', the selected module instances will be removed. If all module instances in one workflow are all removed, the workflow will become empty, but the workflow still appears in the Database ViewerTime Series Lister.
To completely remove this workflow from the list, go to FEWS F12 menu (in log panel, press F12), select 'P database', select 'validate, repair, and compact datastore indices and cache files', then restart FEWS, the workflow will be completely removed. To completely remove the data from the localDataStore (i.e. reduce file size), press F12, select 'P database,' and select 'repair and defrag localdatastore'.
figure 9: Remove workflow and data using F12 - P - database menu