Introduction
figure 1: the GUI of the Database Viewer
The database viewer is a configuration support tool for inspecting the contents of the FEWS database (localdatastore). It shows the content (=values) and statistics of scalar or gridded timeseries. 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 open this mode, some configuration is required
The Database Viewer provides an overview in a tabular form which specifies many different meta data elements (columns) are specified. Rows can be selected and filtered
Configuration (mode: timeseries lister)
<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>
Context Menu Options
figure 2: context menu of the Database Viewer
The Graphical User Interface contains a number of context menu options for selection/filtering and inspection of 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 |
|
|
|
Copy TimeseriesSet.xml to clipboard |
|
Copies the TimeSeriesSet in XML format |
|
|
Shows the XML in popup |
Export to CSV |
|
Export selected timeserie(s) to a CSV file |
|
|
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 Viewer
The meta data elements are grouped as follows.
- General (e.g. moduleinstanceId, location, parameter, timestep, blobsize etc.)
- Basis Statistics (Sum, Mean, Median, Standard Deviation, Percentile-5, Percentile-95)
The below mentioned groups give an overview of number of values and periods based on quality flags, primary and secondary validation.
- Missing
- Original Reliable
- Corrected Reliable
- Completed Reliable
- Original Doubtful
- Corrected Doubtful
- Completed Doubtful
- Original Unreliable
- Corrected Unreliable
- Completed Unreliable
- Soft Min
- Soft Max
- Hard Min
- Hard Max
- Same Reading
- Rate of Change
- Temporary shift
- Series Comparison
- Flag Comparison
- Spatial Homogeneity
The list of available columns can be adjusted by (un)selecting the individual elements. Only the selected ones will be visible in Database Viewer after confirming after 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 then use the <Paste Selection> button to update your selected columns (figure 6). See below:
figure 6: Copying the selection of columns to clipboard
figure 6: Pasting the selection of columns from the clipboard