Selection of Columns for Expert Query

table_name:V_WO_CURRENT_LISTS_WATER_BODY TABLEOWNER:TMDL

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_CURRENT_LISTS_WATER_BODY
	*	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
	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. This field is included for all entries.
	Count Function for 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
	STATE LIST ID	List ID assigned by State. This field is included for all entries.
	303D MAP	A web link which when clicked will produce a map of the associated 303(d) entity. This field is included for all entries.
	303D REPORT	A web link which when clicked will produce a detailed report for the associated 303(d) entity. This field is included for all entries.
	STATE	The state abbreviation (US Postal) for the state. This field is included for all entries.
	WATER BODY NAME	The name of the waterbody (e.g., Mississippi River). This field is included for all entries.
	STATE BASIN NAME	Basin name used by the state. This field is included for all entries.
	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.
	303D COMMENT	Comments on the listed waterbody. This field is optional and not included for all entries.
	ENDANGERED SPECIES	Code indicating if the TMDL pertains to an endangered species; 1 is 'Yes', 0 is 'No'.
	UNLISTED WATERS FLAG	A value of "Y" indicates that the associated water is not on the approved 303(d) list of impaired waters. The state or EPA has determined that this water is impaired since the approval of the previous 303(d) list. This field is included for all relevant entries.
	CYCLE	The even numbered year associated with the list or assessment (e.g., 1996, 1998, 2000). This field is included for all entries.
	EPA WBTYPE	Categories of waterbody types used by EPA (e.g., BAY/ESTUARY).
	REGION	EPA Region (1-10). This field is included for all entries.
	STATE FIPS CODE	The Federal Information Processing Standard (FIPS) Code is a numeric identifier for the state. This field is included for all entries.
	STATE NAME	Name of the state, longhand (as opposed to state abbreviation). This field is included for all entries.
	MILES 303D	The length in miles, calculated from the spatial extent, of the 303(d) listed impaired water segment. This field is included for all entries where the information is available.
	Group Functions for MILES_303D. 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 303D	The area in acres, calculated from the spatial extent, of the 303(d) listed impaired water segment. Segments on streams and rivers may not have an area component. This field is included for all entries where the information is available.
	Group Functions for ACRES_303D. 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
	CURRENT TMDL ID	Current TMDL ID document that addresses the waterbody impairment.
	TMDL REPORT	A web link which when clicked will produce a detailed report for the associated TMDL This field is included for all entries.
	WATER_TMDL_STATUS

Jump to main content.