View – WQX.MONITORINGLOCATION

View Name: WQX.MONITORINGLOCATION

View Type: WQX

Description: WQX.MONITORINGLOCATION returns data that details the monitoring location referenced in sampling activities and observations.

Language: English

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

MONITORINGLOCATIONID = VW_LOCATION.SYS_LOC_CODE

MONLOCNAME = VW_LOCATION.LOC_NAME

MONLOCTYPE = VW_LOCATION.LOC_TYPE_2

MONLOCDESC = VW_LOCATION.LOC_DESC

HUCEIGHTDIGITCODE = VW_LOCATION.LOC_MAJOR_BASIN

HUCTWELVEDIGITCODE = VW_LOCATION.LOC_MINOR_BASIN

TRIBALLANDIND = DT_LOCATION.TRIBAL_LAND_YN

TRIBALLANDNAME = DT_LOCATION.TRIBAL_LAND_NAME

ALTMONLOCID = DT_LOCATION_VAR.SYS_LOC_CODE_VAR

ALTMONLOCIDCONTEXT = DT_LOCATION_VAR.CONTEXT

LATITUDEMEASURE = VW_LOCATION.LATITUDE

LONGITUDEMEASURE = VW_LOCATION.LONGITUDE

SOURCEMAPSCALE = DT_COORDINATE.SOURCE_SCALE

HORIZACCURACYMEASURE = DT_COORDINATE.HORZ_ACCURACY_VALUE

HORIZACCURACYMEASUREUNIT = DT_COORDINATE.HORZ_ACCURACY_UNIT

HORIZCOLLMETHOD = DT_COORDINATE.HORZ_COLLECT_METHOD_CODE

HORIZCOORDREFSYSDATUM = DT_COORDINATE.HORZ_DATUM_CODE

VERTICALMEASURE = DT_COORDINATE.ELEV_ACCURACY_VALUE

VERTICALMEASUREUNIT = DT_COORDINATE.ELEV_ACCURACY_UNIT

VERTICALCOLLMETHOD = DT_COORDINATE.ELEV_COLLECT_METHOD_CODE

VERTICALCOORDREFSYSDATUM = DT_COORDINATE.ELEV_DATUM_CODE

COUNTRYCODE = DT_LOCATION.LOC_COUNTRY

STATECODE = VW_LOCATION.LOC_STATE_CODE

COUNTYCODE = VW_LOCATION.LOC_COUNTY_CODE

WELLTYPE = VW_LOCATION.LOC_TYPE

AQUIFERNAME = DT_WELL.GEOLOGIC_UNIT_CODE

FORMATIONTYPE = DT_WELL.GEOLOGIC_UNIT_TYPE

WELLHOLEDEPTHMEASURE = VW_LOCATION.TOTAL_DEPTH

WELLHOLEDEPTHMEASUREUNIT = VW_LOCATION.UNITS

Tables: DT_COORDINATE, DT_FACILITY, DT_LOCATION, DT_LOCATION_VAR, DT_WELL

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: Data must be present in the VW_LOCATION view to generate in WQX.MONITORINGLOCATION.

Output Type: Grid