WaDE2.0 [WaDE2.01.xml]
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.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| Name | NVarChar(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. |
|
|||
| Definition | NVarChar(5000) |
| Definition of beneficial use as noted from the data provider from the source data. | ||||
| NAICSCodeCV | NVarChar(250) |
| Six-digit NAICs Code associated with the beneficial use category. | ||||
| SourceVocabularyURI | NVarChar(250) |
| Web link to source glossary / index of where the data provider provides the beneficial use and it's definition. | ||||
| State | NVarChar(250) |
| Two digit state abbreviation where the beneficial use was provided from. If multiple, use comma separated list. | ||||
| Term | NVarChar(250) |
| Unique string of the term. Name / listing of the term as noted from the data provider from the source data. | ||||
| USGSCategoryCV | NVarChar(250) |
| Assign a USGS water use category from the USGS controlled vocabulary (e.g. irrigation, groundwater, fresh) | ||||
| WaDEName | NVarChar(250) |
| WaDE specific term used to group and categorize similar beneficial uses and facilitate data visualizations and queries across state boundaries. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_BeneficialUse_AggBridge_BeneficialUses_fact | Core.AggBridge_BeneficialUses_fact | CVs.BeneficialUse | BeneficialUseCategoryCV | Name |
(none)
| Diagram Name |
| 1_WaterAllocations |
| 2_SiteSpecificAmounts |
| 3_AggregatedAmounts |
| 5_ContreolledVocabulary |