Tabular Data

Overview

Point data can be displayed in a tabular format. Click on the Tabular Data menu to display the Tabular Data Request page.

tabular-data-request

Tabular Data Request (see also the full-size image)

Tabular Data Request

The Tabular Data Request page is used to query the database for data from a selected point. The data returned from the database query depends on the data request parameters. The data display is organized based on the tabular data list details. Click the Display button to retrieve the data specified in the input fields organized under the Select Point, Select Display Time and Interval, Select Data Analysis, Display Options headings within the page. The web browser will remember the tabular data request parameters and restore them the next time the page is selected. Click Cancel to return the previous page.

Select Point

The Point pick list selects a point from the database.

Data Label Description
Point Select the point to display from the pick list. Click Point: button to change Point Pick Details and order, see the Point Pick Details section. View button displays the Point Edit page for the selected point, see the Point Edit section.

Point Pick Details

The check boxes on Point Pick Details page control the items, organization, sort order, and limit the records displayed on the pick list.

point-pick-details

Point Pick Details (see also the full-size image)

Select the details to display

  • Check the box to the left of a detail to display. Details are displayed in the order shown.
  • Check the Order by box for the detail to sort first. Check Reverse for a descending sort.
  • Check the Then by box for the detail to sort second. Check Reverse for a descending sort.
  • Check the second Then by box for the detail to sort third. Check Reverse for a descending sort.
Button Action
Move Up Move the selected detail up one row.
Move Down Move the selected detail down one row.
Select All Select all details.
Reset Reset to default details.
OK Return to previous page with new details selected.
Cancel Return to previous page with no changes.

Select the limits for the display

Data Label                             Description
Station Limit display to points assigned to the station(s). Click Station: button to change the Station Pick Details and order. The pick list is a single select list by default. Click the button-expand-section button to change to a multiple pick list. Control the pick list length with the buttons that appear below the pick list label button.

button-reset-pick-list Reset pick list to single select.
button-decrease-pick-list Decrease pick list length.
button-increase-pick-list Increase pick list length.
Point type Limit display to points assigned to the point type(s). Click Point type: button to change Point Type Pick Details and order. The pick list is a single select list by default. Click the button-expand-section button to change to a multiple pick list. Control the pick list length with the buttons that appear below the pick list label button.
User Group Limit display to points assigned to the user group(s). Click User Group: button to change User Group Pick Details and order. The pick list is a single select list by default. Click the button-expand-section button to change to a multiple pick list. Control the pick list length with the buttons that appear below the pick list label button.
Out of Service Limit display to points with out of service state: all ignores out of service, false only displays points in service, true only displays points out of service.

Select Display Time and Interval

Data Label                             Description
Starting Time Select the starting time for the data display. Click Reset Time to start of day for ending time. Note: the starting time must be before the ending time.
Ending Time Select the ending time for the data display. Select Current in the pick list to set the ending time to the current time.
The Historic selection is shown when a past ending time is selected.
Display Interval Select the time interval for the data display. The database query will return data reports at even time intervals from the starting time to the ending time. Select Show Data Reports to display all data reports between the starting and ending time. Click the button to alternate between interval selection from a pick list or from time interval fields.
Refresh Interval Select the interval to automatically refresh the data display. Click the Refresh Interval: button to select from a list of intervals. Click the button again to use the time interval fields. This field is only available when the Ending Time is set to the Current time.

Select Data Analysis

These fields are hidden when the display interval is set to Show Data Reports.

Data Label                             Description
Data Analysis Select the data analysis for the data display. See the data analysis appendix for a description of the analysis types. Use default analysis will do the default analysis for the point type.
Analysis Interval The Rainfall Intensity data analysis requires an analysis interval. Click the Analysis Interval: button to select from a list of intervals. Click the button again to use the time interval fields.
Multiplier Multiply the data analysis computed value by this constant.
Adder Add this constant to the data analysis computed value.

Display Options

Data Label                             Description
Show Ratings Click the No rating field to expand the pick list. Select one or more ratings (Rating 1 - Rating 5) to display in this multiple pick list with the Ctrl mouse click combination. Click the No rating field again to collapse the pick list.
Show Rating Flags Select true to display rating flags as well as the rating data values.
Display Only Select the display data restrictions:

All data: All data, valid or questioned
Valid data: Data reports with a valid flag. A valid flag is automatically set by the system when data checking criteria is met.
Verified data: Data reports with a verified flag. A verified flag is set by an operator using the data editor to certify that the data is valid.
Maintenance data: Data reports with a maintenance flag. A maintenance flag is manually set by an operator to indicate test data not used for public viewing. The maintenance flag is also set when a point of station is out of service or when the data report received has the test flag set.
Display digits Select default to display scaled or analysis data with the number of decimal digits assigned to the point type. Select a number of decimal digits to override the default.
Raw digits Select default to display raw data with the number of decimal digits assigned to the point type. Select a number of decimal digits to override the default.
Display Score Select true to highlight the data display with colored backgrounds when the data report score is greater than one.

Tabular Data Display

After the tabular data request parameters are entered in the Tabular Data Request, click Display to display the data. The header above the data table displays the point label for the point and data analysis.

tabular-data-display-interval-data

Tabular Data Display Interval Data (see also the full-size image)

Data Label                             Description
Point Click on the point label to activate the point pick list. If a new point is selected from the point pick list then its data is immediately displayed.
Click Point: button to change Point Pick Details and order, see the Point Pick Details section
View button displays the Point Edit page for the selected report, see the Point Edit section..

tabular-data-display-show-reports

Tabular Data Display Show Reports (see also the full-size image)

Tabular Data List Details

Click on the table column headers to resort the table for this column; first ascending, then descending. Click on the Choose details... button to change the details and display order, see Tabular Data Display Show Reports image above. Click Edit button to display and modify the point data from the starting to ending time in the Data Edit page, see the Data Edit section.

The check boxes on Tabular Data List Details page control the items, organization, sort order, and affect the data analysis and display of the point data.

Select the details to display

  • Check the box to the left of a detail to display. Details are displayed in the order shown.
  • Check the Order by box for the detail to sort first. Check Reverse for a descending sort.
  • Check the Then by box for the detail to sort second. Check Reverse for a descending sort.
  • Check the second Then by box for the detail to sort third. Check Reverse for a descending sort.
Button Action
Move Up Move the selected detail up one row.
Move Down Move the selected detail down one row.
Select All Select all details.
Reset Reset to default details.
OK Return to previous page with new details selected.
Cancel Return to previous page with no changes.

tabular-data-list-details

Tabular Data List Details (see also the full-size image)

Data Label                             Description
Display Only Select the display data restrictions:

All data: All data, valid or questioned
Valid data: Data reports with a valid flag. A valid flag is automatically set by the system when data checking criteria is met.
Verified data: Data reports with a verified flag. A verified flag is set by an operator using the data editor to certify that the data is valid.
Maintenance data: Data reports with a maintenance flag. A maintenance flag is manually set by an operator to indicate test data not used for public viewing. The maintenance flag is also set when a point of station is out of service or when the data report received has the test flag set.

Data List Details

Detail                       Description
Date and time Time of the data report when the display interval is Show Data Reports. Otherwise it is the time of the display time interval.
Data report Scaled data value stored in the database when the display interval is Show Data Reports. Otherwise it is the value returned by the data analysis.
Raw data Raw data value received from the remote sensor.
Data flags Flags set for data report, see the Data Flag List section.
Data score Nova score flag, see the Nova Score List section.
Report time Report time of report found by analysis for display interval. For example, the time of a report returned by a maximum analysis request.
Data Rating 1 - 5 Data rating values for data report. Up to 5 different ratings can be computed and stored with each data report. For example, discharge may be computed for a water level sensor. Incremental and seasonal rainfall are computed for precipitation sensors.
Rating Flags 1 - 5 Data rating flags for data report ratings. Data ratings flags can be V for valid, U for under or below the lowest rating index value, O for over or above the highest rating index value.
Point ID Point numeric ID for selected point.
Point name Point name for selected point.
Point tag Point tag for selected point.
Point type Point type name for selected point.
Station ID Station numeric ID for selected point.
Station name Station name for selected point.
Station Tag Station tag for selected point.
Station type Station type name for selected point.

Tabular Data Print

Click on the Print button at the top or bottom of the Tabular Data Display to prepare the data display for printing. The data display is redrawn with no links, header, footer, or menu.

Use the Print feature in the browser to print the page. Click the browser Back button to return to the Tabular Data Display page.

Tabular Data Export

Click on the Export button at the top or bottom of the Tabular Data Display to prepare the data display for export. The data display is redrawn with no links, header, footer, or menu in a comma delimited format.

tabular-data-export

Tabular Data Export (see also the full-size image)

Use the File / Save As feature in the web browser to save the page to a file. Click the browser Back button to return to the Tabular Data Display page.