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 (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 (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 to change to a multiple pick list. Control the pick list length with the buttons that appear below the pick list label button. Reset pick list to single select. Decrease pick list length. 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 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 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 (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 (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 (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 (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.