BeneficialUse - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: BeneficialUse

Beneficial uses associated with the site (e.g. irrigation, municipal, commercial, thermoelectric, industrial, stockwater, fire suppression, snow-making, etc.). Can be one or more uses assigned per site. Preference is to list the uses without abbrieviations, separated by commas.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

NameNVarChar(250) Internal unique identifier string used for beneficial use. Name / listing of the beneficial use as noted from the data provider from the source data.

DefinitionNVarChar(5000)

Definition of beneficial use as noted from the data provider from the source data.
NAICSCodeCVNVarChar(250)

Six-digit NAICs Code associated with the beneficial use category.
SourceVocabularyURINVarChar(250)

Web link to source glossary / index of where the data provider provides the beneficial use and it's definition.
StateNVarChar(250)

Two digit state abbreviation where the beneficial use was provided from. If multiple, use comma separated list.
TermNVarChar(250)

Unique string of the term. Name / listing of the term as noted from the data provider from the source data.
USGSCategoryCVNVarChar(250)

Assign a USGS water use category from the USGS controlled vocabulary (e.g. irrigation, groundwater, fresh)
WaDENameNVarChar(250)

WaDE specific term used to group and categorize similar beneficial uses and facilitate data visualizations and queries across state boundaries.

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_BeneficialUse_AggBridge_BeneficialUses_factCore.AggBridge_BeneficialUses_factCVs.BeneficialUseBeneficialUseCategoryCVName

Triggers

(none)


Used in Diagrams

Diagram Name
1_WaterAllocations
2_SiteSpecificAmounts
3_AggregatedAmounts
5_ContreolledVocabulary