Selection of Columns for Expert Query

table_name:WATERS.V_CBR_PROJECTINF_WATERUSES 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_CBR_PROJECTINF_WATERUSES
	*	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
	PROJECTKEY	"Concatenated primary key of the combined ProjectKey, LoanKey, UseType, and UseCode fields. ProjectKey is the primary key from the ProjectInformation table."
	PROJECTRECORDNUMBER	Project specific key value.
	LOANKEY	Primary key from the Loan Information table.
	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.
	MAP_CBR_PROJECT	A web link which when clicked will produce a map of the associated CBR Project.
	NPSPROJECTCOUNT	The number of nonpoint source projects in the group for this project record, usually those that not only share the same activity but also that occur in the same watershed.
	CWNSNUMBER	Clean Watershed Needs Survey number for the facility.
	CWNS I	Secondary Treatment Need Category Amount
	Group Functions for CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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 CWNS_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_VII_L	NPS-Individual/Decentralized Systems Need Category Amount
	CWNS VIII	Confined Animals (Point Source) Need Category Amount
	Group Functions for CWNS_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 CWNS_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
	CWNS_X	Recycled Water Distribution Need Category Amount
	CBR_DESCRIPTION	Description of the project.
	FACILITYNAME	Name of the treatment facility(ies) associated with the project.
	PROJECTPOPULATIONSERVED	The current population that the project serves.
	FACILITYPOPULATIONSERVED	Current population connected to the facility or system that the project improves.
	PROJECTWASTEWATERVOLUME	The design flow that the project directly affects.
	PROJECTVOLUMEELIMINATEDCONSERV	The flow reduced/removed/eliminated due to a CSO, SSO, reuse, or conservation project.
	FACILITYWASTEWATERVOLUME	The design flow for the facility or system that the project improves.
	PROJECTINCLUDESPLANNINGDESIGN
	OCEANOUTFALL	Indicates whether the project affects the discharge to an Ocean Outfall.
	ESTUARYCOASTALBAY	Indicates whether the project affects the discharge to an Estuary or Coastal Bay.
	WETLAND	Indicates whether the project affects the discharge to a Wetland.
	SURFACEWATER	Indicates whether the project affects the discharge to a Surface Water (Stream, River, Lake).
	GROUNDWATER	Indicates whether the project affects a discharge to Groundwater.
	LANDAPPLICATION	Indicates whether the project affects the discharge to land application.
	OTHERREUSE	Indicates whether the project affects the discharge to an effluent reuse/recycling project or something other than this list of discharge options.
	ELIMINATESDISCHARGE	Indicates whether the project eliminates a discharge to a waterbody.
	NOCHANGENODISCHARGE	The project does not affect the discharge/there is No Discharge.
	NEPSTUDY	Indicates whether the project is located within a National Estuary Program (NEP) Study Area.
	CBR_SEASONAL	Indicates whether the discharge is seasonal.
	NPDESPERMITNUMBER	A National Pollutant Discharge Elimination System (NPDES) code used to uniquely identify a permitted NPDES facility.
	MANUALNPDESENTRY	Indicates whether the NPDES permit number is or is not in the PCS database for this Project.
	NONPDESPERMIT	There is no NPDES permit for this Project.
	PERMITTYPE	Any type of permit (other than NPDES) that applies to this project.
	PERMITNUMBER	Permit numbers (other than NPDES) that apply to this project.
	NOVALIDREACHCODE	There is no 14 digit reach code for this waterbody.
	PRIMARYIMPACTEDWATERBODYID	The NHD Reach Code (or HUC code for NPS project groups) for the waterbody first and foremost affected by the project.
	PRIMARYIMPACTEDWATERBODYNAME	The name of the waterbody first and foremost affected by the project.
	RECEIVINGWATERBODYPRIMARY	Indicates whether the Primary Impacted Waterbody is the receiving waterbody.
	PRIMARYIMPACTEDSTATEWATERBODYI	The state waterbody ID number/code for the waterbody first and foremost affected by the project.
	OTHERIMPACTEDWATERBODYID	The NHD Reach Code (or HUC code for NPS project groups) for the secondary impacted waterbody.
	OTHERIMPACTEDWATERBODYNAME	Name of the secondary impacted waterbody.
	RECEIVINGWATERBODYOTHER	Indicates whether the Other Impacted Waterbody is the receiving waterbody.
	OTHERIMPACTEDSTATEWATERBODYID	The state waterbody ID for the secondary impacted waterbody.
	WATERQUALITY	Indicates whether the project is aimed at the 'Improvement' or 'Maintenance' of the impacted waterbody.
	COMPLIANCEOBJECTIVE	Compliance objective of the project (Achieve Compliance, Maintain Compliance, Not Applicable).
	AFFECTEDWATERBODYSTATUS	Status of the affected waterbody (Meeting Standards, Impaired, Threatened, Not Assessed, Not Applicable).
	ADDRESSESEXISTINGTMDL	Indicates whether the project helps address an existing TMDL.
	ADDRESSESPROJECTEDTMDL	Indicates whether the project helps address a projected TMDL.
	ADDRESSESWATERSHEDMANAGEMENTPL	Indicates whether the project helps address a watershed management plan.
	CBR_COMMENTS	Comments on the project.
	PROJINF_LASTMODIFIEDDATE	Date and time Project record was last modified.
	PROJINF_LASTMODIFIEDUSER	User who last modified the Project record.
	PROJECTWATERUSESID	Primary key of PROJECTWATERUSES table
	USETYPE	Indicates whether a project impacts a state Designated Surface Water Use (Designated) or one of the other uses and outcomes (Other).
	USECODE	Use code that corresponds to the Designated Surface Water Use or Other Use or Outcome impacted by the project.
	USETEXT	Name of the Designated Surface Water Use or Other Use or Outcome impacted by the project.
	USEPROTECT	Indicates whether the protection of the use of the affected waterbody, is the primary or secondary driver for project financing.
	USERESTORE	Indicates whether the restoration of the use of the affected waterbody, is the primary or secondary driver for project financing.
	USEORDER	The order in which the use appears in the list.
	WATERUSES_LASTMODIFIEDDATE	Date and time Project Wateruses record was last modified.
	WATERUSES_LASTMODIFIEDUSER	User who last modified the Project Wateruses record.

Jump to main content.