Location Parameters (Rollup)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Location Parameter Reports >

Location Parameters (Rollup)

Report Name: Location Parameters (Rollup)

 

Report Type: Standard

 

Description: The Location Parameters (Rollup) Report compiles the hourly, daily, weekly or monthly average values of PARAM_VALUES in DT_LOCATION_PARAMETER based on selected parameters. It uses the Location Parameters Report. Note that the MEASUREMENT_DATE is precise to hours and that the max values of PARAM_UNIT, X_COORD, Y_COORD, longitude and latitude are reported.

 

File Name: v54.location_parameters_rollup

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection you make to customize the output of a report.

 

Input Parameters

 

Input Parameter Screenshot

Output Columns

Location



30072-input

FACILITY_ID,

FACILITY_CODE,

SYS_LOC_CODE,

MEASUREMENT_DATE,

PARAM_CODE,

PARAM_VALUE,

PARAM_UNIT,

MEASUREMENT_METHOD,

TASK_CODE,

X_COORD,

Y_COORD,

LONGITUDE,

LATITUDE,

COUNT


Individual(s)



Group(s)


Measurement




Date Range




Start



End

Parameter




Individual(s)



Group(s)



Unit


Average By



 

Tables: RT_GROUP

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required).

 

Database Version: EQuIS 5.5.1+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: IGrid  

 

Example Output:

30072-output

 

v54.location_parameters_rollup