Selection of Columns for Expert Query

table_name:V_CWNS_ALP 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_ALP
	*	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.
	DSMTH NAME	Discharge Method
	SEQUENCE NBR	The number which represents the order a particular point is in a series of boundary points.
	LAT DGR MSR	The measure of the degree portion of a latitude measurement (0 to 90 degrees), indicating angular distance North or South of the equator. One degree of latitude equals 111.1 Kilometers or approximately 60 Nautical Miles.
	LAT MIN MSR	The measure of the minutes portion of latitude (00 to 59 minutes), indicating angular distance North or South of the equator.
	LAT SEC MSR	The measure of the seconds portion of a latitude measurement (0 to 59 seconds), indicating angulardistances North and South of the equator.
	LAT DIRECTION CD	The direction of the latitude measurement. North (N) denotes a positive value of the latitude. South (S) denotes a negative value.
	LONG DGR MSR	The measure of the degree portion of longitude (000 to 180 degrees), indicating angular distance West or East of the prime meridian drawn from pole to pole around the Earth and passing through Greenwich, England. NOTE: This is always expressed as three The measure of the minutes portion of longitude (00 to 59 minutes), indicating angular distance West or East of the prime meridian.
	LONG MIN MSR	The measure of the minutes portion of longitude (00 to 59 minutes), indicating angular distance West or East of the prime meridian.
	LONG SEC MSR	The measure of the seconds portion of longitude (00 to 59 seconds), indicating angular distance west or east of the prime meridian.
	GPS LAT DGR MSR	The measure of the degree portion of a latitude measurement (0 to 90 degrees), indicating angular distance North or South of the equator. One degree of latitude equals 111.1 Kilometers or approximately 60 Nautical Miles.
	GPS LAT MIN MSR	The measure of the minutes portion of latitude (00 to 59 minutes), indicating angular distance North or South of the equator.
	GPS LONG DGR MSR	The measure of the degree portion of longitude (000 to180 degrees), indicating angular distance West or East of the prime meridian drawn from pole to pole around the Earth and passing through Greenwich, England. Note: This is always expressed as three digits including the leading zero.
	GPS LONG MIN MSR	The measure of the minutes portion of longitude (00 to 59 minutes), indicating angular distance West or East of the prime meridian.
	LAST POINT FLAG	This flag designates whether this is the last absolute location point.
	TCWGAT IS NBR	An identifying number for geographic types.
	GPDTM NAME	Geodetic Datum associated with Primary Discharge Method latitude and longitude
	PRMRY METHOD FLAG	This flag indicates that this is the primary discharge method for this facility. Note: The primary discharge must have an assigned discharge point.
	IN USE FLAG	The discharge method is in current use at the specific facility. Values - Y - Yes, this method is in use. - N - No, this method is proposed.

Jump to main content.