Selection of Columns for Expert Query

table_name:V_CWNS_F_TOTALNEEDS_FLOW 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_F_TOTALNEEDS_FLOW
	*	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
	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 NAME	The name of the county in which the facility is located.
	SYSTEM NAME	The System Name that this facility belongs to.
	AUTHORITY NAME	Non-Federal unit of government responsible for managing the facility.
	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.
	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 FACILITY FACT SHEET	A hypertext link for a detailed CWNS report.
	CWNS MAP	A hypertext link for a map of a CWNS facility location.
	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
	CWNS I	Secondary Treatment Need Category Amount
	Group Functions for 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
	LAST UPDATE	Date the database row was last updated.
	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.
	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.
	EXISTING MUNICIPAL FLOW (MGD)	The calculated average flow for a recent 12-month period of the portion of the wastewater flows generated by residential, commercial and/or institutional sources within the service area of the facility. Depicted in millions of gallons per day (MGD).
	EXISTING INDUSTRIAL FLOW (MGD)	The calculated average flow for a recent 12-month period of the portion of the wastewater flows generated by industrial sources within the service area of the facility. Depicted in millions of gallons per day (MGD).
	EXISTING INFILTRATION FLOW (MGD)	The calculated average flow for a recent 12-month period of the estimated portion of the wastewater flow that is entering the collection system via defective joints, connections, or manhole walls (as a result of infiltration and inflow, or I). Depicted in millions of gallons per day (MGD).
	TOTAL EXISTING FLOW (MGD)	The sum of the existing municipal, industrial, and infiltration flows. Depicted in millions of gallons per day (MGD).
	EXISTING WET WEATHER FLOW (MGD)	The calculated average flow for a recent 12-month period of the peak flow that the treatment plant either can or does treat. Depicted in millions of gallons per day (MGD).
	PRESENT MUNICIPAL FLOW (MGD)	The current designed hydraulic capacity of the existing treatment plant for the portion of the wastewater flows generated by residential, commercial and/or institutional sources within the service area of the facility. Depicted in millions of gallons per day (MGD).
	Group Functions for PRESENT_MUNICIPAL_FLOW. 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 INDUSTRIAL FLOW (MGD)	The current designed hydraulic capacity of the existing treatment plant for the portion of the wastewater flows generated by industrial sources within the service area of the facility. Depicted in millions of gallons per day (MGD).
	Group Functions for PRESENT_INDUSTRIAL_FLOW. 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 INFILTRATION FLOW (MGD)	The current designed hydraulic capacity of the existing treatment plant for the estimated portion of the wastewater flow that is entering the collection system via defective joints, connections, or manhole walls (as a result of infiltration and inflow, or I). Depicted in millions of gallons per day (MGD).
	Group Functions for PRESENT_INFILTRATION_FLOW. 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 DESIGN FLOW (MGD)	The current designed hydraulic capacity of the existing treatment plant. The unit is Millions of Gallons per Day (MGD).
	PRESENT WET WEATHER FLOW (MGD)	The current designed hydraulic capacity of the existing treatment plant for the peak flow that the treatment plant either can or does treat. Depicted in millions of gallons per day (MGD).
	Group Functions for PRESENT_WET_WEATHER_FLOW. 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
	FUTURE MUNICIPAL FLOW (MGD)	The planned hydraulic capacity of the plant in the design year for the portion of the wastewater flows generated by residential, commercial and/or institutional sources within the service area of the facility. Depicted in millions of gallons per day (MGD).
	FUTURE INDUSTRIAL FLOW (MGD)	The planned hydraulic capacity of the plant in the design year for the portion of the wastewater flows generated by industrial sources within the service area of the facility. Depicted in millions of gallons per day (MGD).
	FUTURE INFILTRATION FLOW (MGD)	The planned hydraulic capacity of the plant in the design year for the estimated portion of the wastewater flow that is entering the collection system via defective joints, connections, or manhole walls (as a result of infiltration and inflow, or I). Depicted in millions of gallons per day (MGD).
	FUTURE DESIGN FLOW (MGD)	The planned hydraulic capacity of the plant in the design year. The unit is Millions of Gallons per Day (MGD).
	FUTURE WET WEATHER FLOW (MGD)	The planned hydraulic capacity of the plant in the design year for the peak flow that the treatment plant either can or does treat. Depicted in millions of gallons per day (MGD).
	NO FLOW DATA	A flag indicating that no flow data is available for this facility.