WaDE2.0 [WaDE2.01.xml]
WaterSources including the source type (groundwater or surface water) and its quality
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| WaterSourceID | BigInt |
| Primary internal key unique identifier for water source records. | |||
| WaterSourceUUID | NVarChar(250) | Foreign key unique identifier to WaterSource_dim table. | |||||
| Geometry | Geometry |
| The GIS objects / shape written in Well-Known Text (WKT) format. | ||||
| GNISFeatureNameCV | NVarChar(250) |
| The water source name as recognized by the data provider. |
|
|||
| WaterQualityIndicatorCV | NVarChar(100) | Description of the water quality (e.g., fresh, saline, mixed quality, etc.). |
|
||||
| WaterSourceName | NVarChar(250) |
| The water source name as in the data provider record | ||||
| WaterSourceNativeID | NVarChar(250) |
| The water source native ID used by the data provider. | ||||
| WaterSourceTypeCV | NVarChar(100) | The high level description of the water source type (e.g., surface water, groundwater, mixed, reuse, etc.) |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_WaterSources_dim_GNISFeatureName | CVs.GNISFeatureName | Core.WaterSources_dim | Name | GNISFeatureNameCV |
| fk_WaterSources_dim_WaterQualityIndicator | CVs.WaterQualityIndicator | Core.WaterSources_dim | Name | WaterQualityIndicatorCV |
| fk_WaterSources_dim_WaterSourceType | CVs.WaterSourceType | Core.WaterSources_dim | Name | WaterSourceTypeCV |
(none)
| Diagram Name |
| 1_WaterAllocations |
| 2_SiteSpecificAmounts |
| 3_AggregatedAmounts |