Versions Compared

Old Version 4

changes.mady.by.user Gerben Boot

Saved on

compared with

New Version 5

changes.mady.by.user Gerben Boot

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
(Met Data Elements/groups)

 

 

 

Show Timeseries Dialog

<F10>

Opens the TimeSeriesDialog and shows
the content of the selected (scalar) timeserie(s)

 

 

 

Show Spatial Display

<F11>

Opens the Spatial Display and shows
the content of the selected (gridded) timeserie(s)

 

 

 

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.