Selection of Columns for Expert Query

table_name:V_WO_ASSESSMENT_UNITS_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_ASSESSMENT_UNITS_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
	STATE	The state abbreviation (US Postal) for the state. This field is included for all entries.
	REGION	EPA Region (1-10). This field is included for all entries.
	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 STATUS	The state-reported attainment status of the water. The Water Status is calculated based on a review of all assessed water uses. If all water uses are fully supporting then the Water Status is "Good". If one water use is not supporting, not attainable, or is partially supporting, then the Water Status is "Impaired". If the water is neither "Good" nor "Impaired" and at least one water use is threatened, then the Water Status is "Threatened". For waters where no water uses were assessed then the Water Status is "Not Assessed".
	WATER NAME	The name of the waterbody (e.g., Mississippi River).
	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
	SIZE UNIT	The standard unit of measure to use for this water type (e.g., miles, acres, square miles).
	EPA WATER TYPE	An EPA defined water type of the assessment unit
	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.
	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.