...
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
Meta Data Elements
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
Configuration (mode: timeseries lister)
...
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.