...
The database viewer is a configuration support tool for inspecting the contents of the FEWS database (localdatastore). It shows provides an overview in tabular form of statistics and other metadata (columns) of the timeseries (rows) in the database. From the Database Viewer it is also possible to access the content (=values) and statistics of scalar or gridded timeseriesof selected timeseries by opening the timeseries dialog. The database viewer is available in two different modes:
- workflow 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 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 enable this mode, some configuration is required.
To aid the inspection of data, the user can add or remove columns, and select and filter rows.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)
To 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> |
...
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 |
|
|
|
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 |
...