View – WQX.BIOLOGICALHABITATINDEX

View Name: WQX.WQX.BIOLOGICALHABITATINDEX

View Type: WQX

Description: WQX.WQX.BIOLOGICALHABITATINDEX returns data detailing the biological index score of a particular habitat.

Language: English

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

MONLOCID = DT_LOCATION_PARAMETER.SYS_LOC_CODE

INDEXID = DT_LOCATION_PARAMETER.IDENTIFIER

INDEXTYPEID = DT_LOCATION_PARAMETER.PARAM_CODE

INDEXTYPEIDCONTEXT = RT_LOCATION_PARAM_TYPE.CONTEXT

INDEXTYPENAME = RT_LOCATION_PARAM_TYPE.PARAM_DESC

RESOURCETITLE = DT_FILE.TITLE

RESOURCECREATOR = DT_FILE.AUTHOR

RESOURCESUBJECT = DT_FILE.REMARK

RESOURCEPUBLISHER = DT_FILE.PUBLISHER

RESOURCEDATE = DT_FILE.FILE_DATE

RESOURCEID = DT_FILE.FILE_NAME

INDEXTYPESCALE = RT_LOCATION_PARAM_TYPE.SCALE

INDEXSCORE = DT_LOCATION_PARAMETER.SCORE

INDEXQUALIFIERCODE = DT_LOCATION_PARAMETER.QUALIFIER

INDEXCOMMENT = DT_LOCATION_PARAMETER.REMARK

INDEXCALCULATEDDATE = DT_LOCATION_PARAMETER.MEASUREMENT_DATE

Tables: DT_FACILITY, DT_FILE, DT_LOCATION_PARAMETER, RT_LOCATION_PARAM_TYPE

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: Data must be present in the DT_LOCATION_PARAMETER table to be generated in WQX.BIOLOGICALHABITATINDEX.

Output Type: Grid