WaDE2.0 [WaDE2.01.xml]
A term that describes a subcategorization of the site-specific variable. This allows the user to specify not only the general category of water data, but also a more specific categorization. For example, for a subcategorization of water withdrawal, the variable would be [SiteSpecificWithdrawal, Irrigation]. Other examples: [SiteSpecificConsumptiveUse, Irrigation], [SiteSpecificReturnFlow, Discharge], etc.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK | 
| 
 | Name | NVarChar(250) | Internal unique identifier string used for term name. Name / listing of the term as noted from the data provider from the source data. | ||||
| Term | NVarChar(250) | Unique string of the term. Name / listing of the term as noted from the data provider from the source data. | |||||
| Definition | NVarChar(4000) | 
 | Definition of the term as noted from the data provider from the source data. | ||||
| State | NVarChar(250) | 
 | Two digit state abbreviation where the term was provided from. If multiple, use comma separated list. | ||||
| SourceVocabularyURI | NVarChar(250) | 
 | Web link to source glossary / index of where the data provider provides the term and it's definition. | ||||
| WaDEName | NVarChar() | 
 | WaDE specific term used to group and categorize similar beneficial uses and facilitate data visualizations and queries across state boundaries. | 
(none)
(none)
(none)
| Diagram Name | 
| 5_ContreolledVocabulary |