Introduction
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
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 |
Meta Data Elements / Select Columns (F8)
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)selected. Only the selected ones will be visible in Database Viewer after confirming.