Selection of Columns for Expert Query

table_name:V_CWNS_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_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.
	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.
	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 PRESENT RES POP	The sum of the No Collection, Receiving Collection, and ISDS populations currently living within the service area of the selected facility.
	Group Functions for TOTAL_P_RESIDENT_POP. 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
	TOTAL FUTURE RES POP	The sum of the No Collection, Receiving Collection, and ISDS populations who will live within the service area of the selected facility in the design year.
	Group Functions for TOTAL_F_RESIDENT_POP. 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 RESIDENT POPULATION NOT RECEIVING COLLECTION	The total population currently living within the service area of the facility who are not connected to a sewer system nor served by acceptable ISDSs (e.g., septic tanks). This includes a population connected to sewers that do not discharge to a WWTP (i.e., a raw discharge) and does not include populations served by acceptable ISDSs.
	Group Functions for P_RES_NO_COLLECTION_POP. 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 RESIDENT POPULATION NOT RECEIVING COLLECTION	The total population who will live within the service area of the facility during the design year who are not connected to a sewer system nor served by acceptable ISDSs (e.g., septic tanks). This includes a population connected to sewers that do not discharge to a WWTP (i.e., a raw discharge) and does not include populations served by acceptable ISDSs.
	TOTAL PRESENT REC COLLECTION POP	The total population currently living within the service area of the selected facility or currently utilizing or being served by the associated sewers treatment plants, or ISDSs.
	Group Functions for TOTAL_P_REC_COLLECTION_POP. 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
	TOTAL FUTURE REC COLLECTION POP	The total population who will live within the service area of the selected facility or who will utilize or be served by the associated sewers treatment plants, or ISDSs during the design year.
	Group Functions for TOTAL_F_REC_COLLECTION_POP. 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 RESIDENT INDIVIDUAL SEWAGE DISPOSAL SYSTEM	The total population currently living within the service area of the facility not connected to a sewer system but served by acceptable Individual On-site Systems (e.g., septic tanks).
	Group Functions for P_RES_INDIV_SEWAGE_POP. 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 RESIDENT INDIVIDUAL SEWAGE DISPOSAL SYSTEM	The total population who will live within the service area of the facility not connected to a sewer system but served by acceptable Individual On-site Systems (e.g., septic tanks).
	PRESENT UPSTREAM RESIDENT POPULATION RECEIVING COLLECTION	The total population currently living within the service area of the facility whose wastewater is discharged to this facility from other facilities upstream in the sewershed.
	Group Functions for P_UP_RES_COLLECTION_POP. 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 UPSTREAM RESIDENT POPULATION RECEIVING COLLECTION	The total population who will live within the service area of the facility during the design year whose wastewater is discharged to this facility from other facilities upstream in the sewershed.
	TOTAL PRESENT RESIDENT POPULATION RECEIVING TREATMENT	The total population (in this facility and upstream) receiving wastewater treatment at this facility
	Group Functions for TOTAL_P_RES_COLLECTION_POP. 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
	TOTAL FUTURE RESIDENT POPULATION RECEIVING TREATMENT	The projected future total population (in this facility and upstream) that is forecasted to receive wastewater treatment at this facility during the design year.
	Group Functions for TOTAL_F_RES_COLLECTION_POP. 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 NON-RESIDENT POPULATION NOT RECEIVING COLLECTION	The total population who do not live within the service area of the selected facility, but that still utilize or are served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) and who are not connected to a sewer system nor served by acceptable ISDSs (e.g., septic tanks). This includes a population connected to sewers that do not discharge to a WWTP (i.e., a raw discharge) and does not include populations served by acceptable ISDSs.
	Group Functions for P_NONRES_NO_COLLECTION_POP. 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 NON-RESIDENT POPULATION NOT RECEIVING COLLECTION	The total population who do not live within the service area of the selected facility, but that will still utilize or be served by the associated sewers treatment plants, or ISDSs during the design year (such as transient, seasonal, commuter workers, and tourist populations) and who are not connected to a sewer system nor served by acceptable ISDSs (e.g., septic tanks). This includes a population connected to sewers that do not discharge to a WWTP (i.e., a raw discharge) and does not include populations served by acceptable ISDSs.
	PRESENT NON-RESIDENT POPULATION RECEIVING COLLECTION	The total population who do not live within the service area of the selected facility, but that still utilize or are served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) and who are connected to a sewer system which empties into a WWTP.
	Group Functions for P_NONRES_COLLECTION_POP. 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 NON-RESIDENT POPULATION RECEIVING COLLECTION	The total population who do not live within the service area of the selected facility, but that will still utilize or be served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) during the design year and who are connected to a sewer system which empties into a WWTP.
	PRESENT NON-RESIDENT INDIVIDUAL SEWAGE DISPOSAL SYSTEM	The total population who do not live within the service area of the selected facility, but that still utilize or are served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) and who are not connected to a sewer system but served by acceptable Individual On-site Systems (e.g., septic tanks).
	Group Functions for P_NONRES_INDIV_SEWAGE_POP. 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 NON-RESIDENT INDIVIDUAL SEWAGE DISPOSAL SYSTEM	The total population who do not live within the service area of the selected facility, but that will still utilize or be served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) during the design year and who are not connected to a sewer system but served by acceptable Individual On-site Systems (e.g., septic tanks).
	PRESENT UPSTREAM NON-RESIDENT POPULATION RECEIVING COLLECTION	The total population who do not live within the service area of the selected facility, but that still utilize or are served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) and whose wastewater is discharged to this facility from other facilities upstream in the sewershed.
	Group Functions for P_UP_NONRES_COLLECTION_POP. 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 UPSTREAM NON-RESIDENT POPULATION RECEIVING COLLECTION	The total population who do not live within the service area of the selected facility, but that will still utilize or be served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) during the design year and whose wastewater is discharged to this facility from other facilities upstream in the sewershed.
	TOTAL PRESENT NON-RESIDENT POPULATION RECEIVING TREATMENT	The total population who do not live within the service area of the selected facility, but that still utilize or are served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) and upstream receiving wastewater treatment at this facility.
	Group Functions for TOTAL_P_NONRES_COLLECTION_POP. 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
	TOTAL FUTURE NON-RESIDENT POPULATION RECEIVING TREATMENT	The total population who do not live within the service area of the selected facility, but that will still utilize or be served by the associated sewers treatment plants, or ISDSs (such as transient, seasonal, commuter workers, and tourist populations) and upstream during the design year receiving wastewater treatment at this facility.
	Group Functions for TOTAL_F_NONRES_COLLECTION_POP. 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
	NO POP DATA	A flag indicating that no population data is available for this facility.