View – WQX.PROJMONLOC

View Name: WQX.PROJMONLOC

View Type: WQX

Description: WQX.PROJMONLOC returns details of the project monitoring location.

Language: English

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

MONLOCID = AT_SUBFACILITY_LOCATION.SYS_LOC_CODE

LOCWEIGHTINGFACMEASURE = AT_SUBFACILITY_LOCATION.WEIGHTING_FACTOR

LOCWEIGHTINGFACMEASUREUNIT = AT_SUBFACILITY_LOCATION.WEIGHTING_FACTOR_UNIT

STATISTICALSTRATUM = AT_SUBFACILITY_LOCATION.STATISTICAL_STRATUM

LOCATIONCATEGORY = AT_SUBFACILITY_LOCATION.STATISTICAL_STRATUM

LOCATIONSTATUS = AT_SUBFACILITY_LOCATION.STATUS

REFLOCATIONTYPECODE = AT_SUBFACILITY_LOCATION.SUBFACILITY_LOC_TYPE_CODE

REFLOCATIONSTARTDATE = AT_SUBFACILITY_LOCATION.START_DATE

REFLOCATIONENDDATE = AT_SUBFACILITY_LOCATION.END_DATE

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

PROJMONLOCCOMMENT = AT_SUBFACILITY_LOCATION.REMARK

Tables: AT_SUBFACILITY_LOCATION, DT_FACILITY, DT_FILE

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: The SYS_LOC_CODE must be associated with a SUBFACILITY_CODE in the AT_SUBFACILITY_LOCATION table for data to be generated in WQX.PROJMONLOC. The DT_COORDINATE table must also be populated with a corresponding COORD_TYPE_CODE and identifier in the DT_FACILITY table.

Example: DT_COORDINATE.COORD_TYPE_CODE and DT_FACILITY.COORD_TYPE_CODE = LAT LONG, DT_COORDINATE.IDENTIFIER and DT_FACILITY.IDENTIFIER = PRIMARY.

Note: There must be values populated for DT_COORDINATE.X_COORD and DT_COORDINATE.Y_COORD.

Output Type: Grid