Selection of Columns for Expert Query

table_name:V_WO_AU_IMP_V2 TABLEOWNER:W305B

Selection of Columns

STEP 2: Select one or more column(s) for your output by clicking on the square box next to the column name. When you are finished selecting columns, click on the "STEP 3: Enter Search Criteria" button at the bottom of this page.

TABLE NAME: V_WO_AU_IMP_V2
	*	All data elements in the view or table are selected. If selected, all other data elements selections will be ignored!
	Count Function for *. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS! COUNT
	ID305B	Unique identifier for assessment unit (water segment) ID. State Defined.
	305B REPORT	A web link which when clicked will produce a detailed report for the associated 305(b) entity.
	305B MAP	A web link which when clicked will produce a map of the associated 305(b) entity.
	CYCLE	The even numbered year associated with the list or assessment (e.g., 1996, 1998, 2000). This field is included for all entries.
	WATER NAME	The name of the waterbody (e.g., Mississippi River).
	LOCATION	Text description of the location of the listed water. Information in the location field can include: city names, county names, reference to landmarks, etc. This field is optional and not included for all entries.
	STATE	The state abbreviation (US Postal) for the state. This field is included for all entries.
	TROPHIC STATUS	Since the early part of the 20th century, lakes have been classified according to their trophic state (i.e.', eutrophic, mesotrophic, and oligotrophic).
	WATER TYPE	A description of the type of water that the waterbody represents (e.g., river, stream, lake, estuary). This field is optional and not included for all entries.
	WATER SIZE	Size of the waterbody.
	Group Functions for WATER_SIZE. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	EPA WATER TYPE	An EPA defined water type of the assessment unit
	SIZE UNIT	The standard unit of measure to use for this water type (e.g., miles, acres, square miles).
	USE ID	EPA unique identifier assigned to a designated use.
	USE DESCRIPTION	State water quality standards specify which uses (such as recreation, aquatic life use support, or drinking water supply) individual waters should support.
	EPA USE DESCRIPTION	The name of the EPA or National Use Group that the individual reported state use belongs to.
	CAUSE ID	Unique id assigned to the cause of impairment.
	IMPAIRMENT NAME	The state reported name for a cause of impairment.
	EPA IMPAIRMENT NAME	The name of an EPA Grouping of state causes of impairments into a high-level classification. This classification is for reporting purposes only.
	IMPAIRMENT DESCRIPTION	Additional imformation concerning the impairment cause
	CAS NUMBER	Chemical abstract number for chemical impairment causes. This field is optional and is not included for all entries.
	EPA NUMBER	EPA chemical identifier for biological impairment causes. This field is optional and is not included for all entries.
	BIN	Biological identifier number for biological impairment causes. This field is optional and not included for all entries.
	STORET NUMBER	Storet system number. This field is optional and is not included for all entries.
	EXPECTED TO ATTAIN DATE	Date by which this Category 4b assessment unit and cause of impairment combination is expected to attain water quality standards. This field is required for Category 4b entries.
	MONITORING SCHEDULED DATE	Date by which additional monitoring for use attainment status will be completed. This field is optional and not included for all entries.
	MILES 305B	The length in miles, calculated from the spatial extent, of the 305(b) assessed water segment.
	Group Functions for MILES_305B. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	ACRES 305B	The area in acres, calculated from the spatial extent, of the 305(b) assessed water segment. Segments on streams and rivers may not have an area component.
	Group Functions for ACRES_305B. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE

Jump to main content.