Selection of Columns for Expert Query

table_name:V_CWNS_303D_IMP_TMDL_OV TABLEOWNER:WATERS

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_CWNS_303D_IMP_TMDL_OV
	*	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
	CWNS NUMBER	Authority/Facility Identification Number (A/F). This is unique for a facility. The first two numbers correspond to a State's FIPS code, e.g., Alabama = 01, Alaska = 02, etc. The next four characters correspond to the authority and the last three characters correspond to the facility.
	Count Function for CWNS_AF_NBR. 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
	CWNS FACILITY NAME	Name of water quality management project. A CWNS facility can be a wastewater treatment plant, municipal storm sewer system, or a nonpoint source (NPS) pollution control project. The CWNS Facility Name must be unique within each state.
	CWNS REVIEW STATUS	Indicates whether the list has been reviewed and approved/disapproved by EPA.
	CWNS REVIEW STATUS DESCRIPTION	A description of the report status that indicates whether the list has been reviewed and approved/disapproved by EPA.
	CWNS_STATE	The state abbreviation (US Postal) for the state.
	CWNS_REGION	EPA Region (1-10).
	CWNS COUNTY NAME	County in which the facility is located. (Normally populated if the facility is at a different location than the responsible entity.)
	CWNS AUTHORITY NAME	Non-Federal unit of government responsible for managing the facility.
	CWNS WATERSHED NAME	Name for the Watershed that is part of this Reach.
	CWNS REPORT	A hypertext link for a detailed CWNS report.
	CWNS MAP	A hypertext link for a map of a CWNS facility location.
	CWNS NEEDS	Total current year amount of Federal Needs.
	Group Functions for CWNS_F_NEED. 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
	CWNS I	Secondary Treatment Need Category Amount
	Group Functions for CWNS_I. 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
	CWNS II	Advanced Treatment Need Category Amount
	Group Functions for CWNS_II. 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
	CWNS III_A	Infiltrate/Inflow Correction Need Category Amount
	Group Functions for CWNS_III_A. 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
	CWNS III_B	Replace/Rehab of Sewers Need Category Amount
	Group Functions for CWNS_III_B. 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
	CWNS IV_A	New Collector Sewers Need Category Amount
	Group Functions for CWNS_IV_A. 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
	CWNS IV_B	New Interceptor Sewers Need Category Amount
	Group Functions for CWNS_IV_B. 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
	CWNS V	Combined Sewer Overflow Need Category Amount
	Group Functions for CWNS_V. 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
	CWNS VI	Separate Storm Sewer System Need Category Amount
	Group Functions for CWNS_VI. 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
	CWNS VII_A	NPS-Agriculture (cropland) Need Category Amount
	Group Functions for CWNS_VII_A. 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
	CWNS VII_B	NPS-Agriculture (animals) Need Category Amount
	Group Functions for CWNS_VII_B. 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
	CWNS VII_C	NPS-Silviculture Need Category Amount
	Group Functions for CWNS_VII_C. 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
	CWNS VII_D	NPS-Urban Need Category Amount
	Group Functions for CWNS_VII_D. 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
	CWNS VII_E	NPS-Ground Water - Unknown Source Need Category Amount
	Group Functions for CWNS_VII_E. 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
	CWNS VII_F	NPS-Marinas Need Category Amount
	Group Functions for CWNS_VII_F. 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
	CWNS VII_G	NPS-Resource Extraction Need Category Amount
	Group Functions for CWNS_VII_G. 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
	CWNS VII_H	NPS-Brownfields Need Category Amount
	Group Functions for CWNS_VII_H. 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
	CWNS VII_I	NPS-Storage Tanks Need Category Amount
	Group Functions for CWNS_VII_I. 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
	CWNS VII_J	NPS-Sanitary Landfills Need Category Amount
	Group Functions for CWNS_VII_J. 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
	CWNS VII_K	NPS-Hydromodification Need Category Amount
	Group Functions for CWNS_VII_K. 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
	CWNS VIII	Confined Animals (Point Source) Need Category Amount
	Group Functions for CWNS_VIII. 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
	CWNS IX	Mining (Point Source) Need Category Amount
	Group Functions for CWNS_IX. 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
	IW303D LIST ID	Unique ID assigned to each state listing. The first two characters are the state abbreviation. The middle characters are the water's Waterbody System ID, another state-derived ID, or an arbitrary ID assigned by the state.
	Count Function for IW303D_LIST_ID. 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
	IW303D MAP	A web link which when clicked will produce a map of the associated 303(d) entity.
	IW303D REPORT	URL or file location for full consent decree or settlement agreement.
	IW303D STATE	The state abbreviation (US Postal) for the state.
	IW303D_REGION	EPA Region (1-10).
	IW303D WATER BODY NAME	The name of the waterbody (e.g., Mississippi River).
	IW303D_STATE_BASIN_NAME	Basin name used by the state.
	IW303D_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.
	303D COMMENT	Comments on the listed waterbody. This field is optional and not included for all entries.
	IW303D_CYCLE	The year associated with the list or assessment (e.g., 1996, 1998, 2000).
	IW303D MILES	The miles of water in each category of attainment (good, threatened, or impaired).
	Group Functions for IW303D_MILES. 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
	IW303D ACRES	The acres of water in each category of attainment (good, threatened, or impaired).
	Group Functions for IW303D_ACRES. 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
	CAUSE ID	Unique id assigned to the cause of impairment.
	CAUSE DESCRIPTION	Description of the cause of impairment (or TMDL pollutant). This value is reported by the state.
	STATE_NAME_303D	The state name from the 303(d)/Impaired Waters data.
	ASSESSMENT METHOD	Assessment method used to assess the condition of the waterbody. This field is optional and not included for all entries.
	PRIORITY	Priority for TMDL development assigned by the state (High, Medium, Low). This field is optional and not included for all entries.
	RANKING	Numeric ranking assigned by the state (i.e. 1,2, 3) of each listed water. This field is optional and not included for all entries.
	TARGETED FLAG	Yes/No field indicating if the state intends to develop a TMDL for the listed water within the next 2 years. This field is optional and not included for all entries.
	ANTICIPATED TMDL SUBMITTAL DATE	Anticipated date of TMDL submittal. This field is optional and not included for all entries.
	LISTING CRITERIA	Text description of criteria used to make listing decision. This field is optional and not included for all entries.
	EPA DELISTED COMMENTS	Additional information about the de-listed water. This field is optional and not included for all relevant entries.
	EPA DELISTED DATE	Indicates the date the water was de-listed. This field is optional and not included for all relevant entries.
	DELISTED REASON	Other than a TMDL being approved, 303(d) listed waters may be removed for a number of reasons which show a water is supporting water quality standards. These include but are not limited to more recent and accurate data, more sophisticated water quality modeling, flaws in the original analysis that led to the original listing, or changes in conditions such as the elimination of discharges. This field is optional and not included for all relevant entries.
	YEAR FIRST LISTED	A field used to denote when the impairment was first identified. Used primarily for impaired waters that have been re-segmented. This field is optional and not included for all relevant entries.
	EPA ADDED	Flag indicating whether EPA added a water to the 303(d) list during a partial approval/partial disapproval of a 303(d) list. This field is optional and not included for all relevant entries.
	PARENT CAUSE ID	ID associated with the "parent" cause of impairment. The parent cause of impairment represents an EPA assigned, general categorization for the specific, state reported impairment cause.
	PARENT CAUSE DESCRIPTION	Cause of impairment group name such as 'Pathogens' or 'Sediment.' Please note this is a derived field.
	TMDL REPORT	A web link which when clicked will produce a detailed report for the associated TMDL This field is included for all entries.