Selection of Columns for Expert Query

table_name:WATERS.T_DISCHARGE_2K4 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: T_DISCHARGE_2K4
	*	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 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
	TCWFCLTY IS NBR	The internal systems identifier number.
	FACILITY NAME	Name of water quality management project. A facility can be a wastewater treatment plant, municipal storm sewer system, or a nonpoint source (NPS) pollution control project. The Facility Name must be unique within each state.
	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.
	COUNTY_FIPS	Point of record county FIPS code
	COUNTY NAME	The name of the county in which the facility is located.
	AUTHORITY NAME	Non-Federal unit of government responsible for managing the facility.
	SYSTEM NAME	The System Name that this facility belongs to.
	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.
	INTERIM USE FLAG	The flag indicates that the facility is an interim facility. The facility is planned for replacement.
	PRIVATE OWNER FLAG	The owner or responsible is a private entity and is not a public legal entity.
	SMALL COMMUNITY EXCEPTION FLAG	The flag indicates whether a community is identified as a small community (population less than 10,000 and flow less than 1 mgd) but whose facility is an extension of one serving a larger community.
	SMSA FLAG	The flag indicates whether the Facility is located within a Standard Metropolitan Statistical Area.
	WATERSHED HUC	8-digit USGS hydrologic Unit Code (HUC) (text format).
	WATERSHED NAME	The name for the watershed according to the US Geological Survey's 8-digit Hydrological Unit Code (HUC) system, in which the facility is located.
	CONGRESSIONAL DISTRICT	The number of the Congressional District in which the facility is located.
	TOTAL NEEDS	Total current year amount of Federal Needs for a facility or project.
	Group Functions for 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
	STATE NEEDS	Total current year amount of State Needs.
	Group Functions for S_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
	PRESENT EFFLUENT QUALITY	The present effluent design quality of the facility.
	FUTURE EFFLUENT QUALITY	The future effluent design quality of the facility.
	IN RAD	A yes (Y) or no (N) indicator depicting whether the entity has been reach indexed to the National Hydrograph Database.
	TRIBE FLAG	Indicator that this Waterbody segment is maintained by a Tribe, 0=not tribe (default), 1=tribe.
	NEED_STATUS
	CWNS FACILITY FACT SHEET	A hypertext link for a detailed CWNS report.
	CWNS MAP	A hypertext link for a map of a CWNS facility location.
	TREATMENT	Present and/or Future for Facility Nature: "Treatment Plant"
	CSEWERS	Present and/or Future for Facility Nature: "Collection: Combined Sewers"
	SSEWERS	Present and/or Future for Facility Nature: "Collection: Separate Sewers"
	BIOSOLIDS	Present and/or Future for Facility Nature: "Biosolids Handling Facility"
	ONSITE	Present and/or Future for Facility Nature: "Individual On-Site System Area"
	DECENTRALIZED	Present and/or Future for Facility Nature: "Decentralized System"
	OTHER	Present and/or Future for Facility Nature: "Facility Classified As 'Other'"
	ANIMALS	Present and/or Future for Facility Nature: "Agriculture - Animals"
	MINING	Present and/or Future for Facility Nature: "Mining (Point Source)"
	PMT NPDES FLAG	Flag Y/N for association with NPDES permit
	PERMIT NAME	Permit Type
	PERMIT NUMBER	The number for the environmental permits that the facility holds.
	P EFFLUENT	Present Effluent Level
	F EFFLUENT	Future Effluent Level
	E MUNICIPAL	Existing Municipal Flow (million gallons per day)
	Group Functions for E_MUNICIPAL. 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
	P MUNICIPAL	Present Design Municipal Flow (million gallons per day)
	Group Functions for P_MUNICIPAL. 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
	F MUNICIPAL	Future Design Municipal Flow (million gallons per day)
	Group Functions for F_MUNICIPAL. 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
	E INDUSTRIAL	Existing Industrial Flow (million gallons per day)
	Group Functions for E_INDUSTRIAL. 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
	P INDUSTRIAL	Present Design Industrial Flow (million gallons per day)
	Group Functions for P_INDUSTRIAL. 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
	F INDUSTRIAL	Future Design Industrial Flow (million gallons per day)
	Group Functions for F_INDUSTRIAL. 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
	E INFILTRATION	Existing Infiltration Flow (million gallons per day)
	Group Functions for E_INFILTRATION. 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
	P INFILTRATION	Present Design Infiltration Flow (million gallons per day)
	Group Functions for P_INFILTRATION. 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
	F INFILTRATION	Future Design Infiltration Flow (million gallons per day)
	Group Functions for F_INFILTRATION. 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
	E WWEATHER	Existing Wet Weather Peak Flow (million gallons per day)
	Group Functions for E_WWEATHER. 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
	P WWEATHER	Present Design Wet Weather Peak Flow (million gallons per day)
	Group Functions for P_WWEATHER. 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
	F WWEATHER	Future Design Wet Weather Peak Flow (million gallons per day)
	Group Functions for F_WWEATHER. 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
	GPDTM NAME	Geodetic Datum associated with Primary Discharge Method latitude and longitude
	P DSMTH	Primary Discharge Method
	DS AF NBR	For Primary Discharge Method of 'Discharge To Another Facility', the AF_NBR of the downstream facility
	DS FACILITY NAME	For Primary Discharge Method of 'Discharge To Another Facility', the downstream facility name
	P DSRVRCH NBR	For Primary Discharge Method of 'Outfall to Surface Water', the Discharge River Reach number (RF1, 11-digit code)
	P DSRVRCH NAME	For Primary Discharge Method of 'Outfall to Surface Water', the Discharge River Reach waterbody name
	P DSWSHED NBR	For other Primary Discharge Methods the 8-digit USGS Hydrologic Unit Code
	P DSWSHED NAME	For other Primary Discharge Methods the watershed name (corresponding to 8-digit USGS Hydrologic Unit Code)
	P DSLATITUDE	Discharge Latitude (decimal degree)
	P DSLONGITUDE	Discharge Longitude (decimal degree)
	P DSLATITUDE POLYGON	Indicator of discharge polygon
	P DSLONGITUDE POLYGON	Indicator of discharge polygon
	E_TOTAL	Existing Total Flow (million gallons per day)
	Group Functions for E_TOTAL. 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
	P_TOTAL	Present Design Total Flow (million gallons per day)
	Group Functions for P_TOTAL. 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
	F_TOTAL	Future Design Total Flow (million gallons per day)
	Group Functions for F_TOTAL. 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.