WaDE2.0 [WaDE2.01.xml]
specific granular variables
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| MethodID | BigInt |
| Primary internal key unique identifier for method records. | |||
| MethodUUID | NVarChar(100) | Foreign key unique identifier to Methods_dim table. | |||||
| ApplicableResourceTypeCV | NVarChar(100) | A description of the types of water supply or water use for which the method is used (e.g. surface water, groundwater, storage, consumptive use, withdrawal) |
|
||||
| DataConfidenceValue | NVarChar(50) |
| An indicator of data confidence, should be a confidence interval (e.g. 90%, 50%, etc.) | ||||
| DataCoverageValue | NVarChar(100) |
| An indicator of data coverage (e.g., full, partial, etc.). | ||||
| DataQualityValueCV | NVarChar(50) |
| An indicator of the quality of data or grading (e.g. fair, good, best, unreported), or using the NEMS data quality grading system. |
|
|||
| MethodDescription | Text | A high level / general description of the data provided. | |||||
| MethodName | NVarChar(50) | The name of the method used by the data provider. | |||||
| MethodNEMILink | NVarChar(100) |
| A link back to the data provider's website or other webpage for more information about the method (e.g., https://www.nemi.gov/home/). | ||||
| MethodTypeCV | NVarChar(50) | Indicator of how the actual amount value within the data was determined (i.e. calculated, measured, estimated, reported, modeled, etc). |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Methods_dim_ApplicableResourceTypeCV | CVs.ApplicableResourceType | Core.Methods_dim | Name | ApplicableResourceTypeCV |
| fk_Methods_dim_DataQualityValue | CVs.DataQualityValue | Core.Methods_dim | Name | DataQualityValueCV |
| fk_Methods_dim_MethodType | CVs.MethodType | Core.Methods_dim | Name | MethodTypeCV |
(none)
| Diagram Name |
| 1_WaterAllocations |
| 2_SiteSpecificAmounts |
| 3_AggregatedAmounts |