Selection of Columns for Expert Query

table_name:V_CWNS_T_POPULATION 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_T_POPULATION
	*	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.
	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)"
	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
	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
	R POP PTOTAL	Population, Present Resident (Not Receiving Collection Population + Receiving Collection Population + Individual Sewage Disposal System Population)
	Group Functions for R_POP_PTOTAL. 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
	R POP FTOTAL	Population, Future Resident (Not Receiving Collection Population + Receiving Collection Population + Individual Sewage Disposal System Population)
	Group Functions for R_POP_FTOTAL. 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
	RP NRCOLLECTION	Population, Present Resident Not Receiving Collection
	Group Functions for RP_NRCOLLECTION. 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
	RF NRCOLLECTION	Population, Future Resident Not Receiving Collection
	Group Functions for RF_NRCOLLECTION. 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
	RP RCOLLECTION	Population, Present Resident Receiving Collection
	Group Functions for RP_RCOLLECTION. 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
	RF RCOLLECTION	Population, Future Resident Receiving Collection
	Group Functions for RF_RCOLLECTION. 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
	RP ISDS	Population, Present Resident Individual Sewage Disposal System
	Group Functions for RP_ISDS. 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
	RF ISDS	Population, Future Resident Individual Sewage Disposal System
	Group Functions for RF_ISDS. 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
	RP RCOLL UPSTREAM	Population, Sum of All Upstream Present Resident Receiving Collection
	Group Functions for RP_RCOLL_UPSTREAM. 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
	RF RCOLL UPSTREAM	Population, Sum of All Upstream Future Resident Receiving Collection
	Group Functions for RF_RCOLL_UPSTREAM. 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
	RP RTREATMENT	Population, Present Resident Receiving Treatment (Receiving Collection Population + Upstream Receiving Collection Population)
	Group Functions for RP_RTREATMENT. 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
	RF RTREATMENT	Population, Future Resident Receiving Treatment (Receiving Collection Population + Upstream Receiving Collection Population)
	Group Functions for RF_RTREATMENT. 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
	NRP NRCOLLECTION	Population, Present Resident Not Receiving Collection
	Group Functions for NRP_NRCOLLECTION. 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
	NRF NRCOLLECTION	Population, Future Resident Not Receiving Collection
	Group Functions for NRF_NRCOLLECTION. 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
	NRP RCOLLECTION	Population, Present Resident Receiving Collection
	Group Functions for NRP_RCOLLECTION. 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
	NRF RCOLLECTION	Population, Future Resident Receiving Collection
	Group Functions for NRF_RCOLLECTION. 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
	NRP ISDS	Population, Present Resident Individual Sewage Disposal System
	Group Functions for NRP_ISDS. 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
	NRF ISDS	Population, Future Resident Individual Sewage Disposal System
	Group Functions for NRF_ISDS. 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
	NRP RCOLL UPSTREAM	Population, Sum of All Upstream Present Resident Receiving Collection
	Group Functions for NRP_RCOLL_UPSTREAM. 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
	NRF RCOLL UPSTREAM	Population, Sum of All Upstream Future Resident Receiving Collection
	Group Functions for NRF_RCOLL_UPSTREAM. 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
	NRP RTREATMENT	Population, Present Resident Receiving Treatment (Receiving Collection Population + Upstream Receiving Collection Population)
	Group Functions for NRP_RTREATMENT. 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
	NRF RTREATMENT	Population, Future Resident Receiving Treatment (Receiving Collection Population + Upstream Receiving Collection Population)
	Group Functions for NRF_RTREATMENT. 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.

Jump to main content.