WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
| MethodUUID | NVarChar(250) | Foreign key unique identifier to Methods_dim table. | |||||
| OrganizationUUID | NVarChar(250) | Foreign key unique identifier to Organization_dim table. | |||||
| SiteUUIDs | NVarChar(250) | Foreign key unique identifier to Sites_dim table. | |||||
| VariableSpecificUUID | NVarChar(250) | Foreign key unique identifier to Variables_dim table. | |||||
| AllocationApplicationDateID | BigInt |
| Foreign key unique identifier to Dates_dim table. Date of the original filing on the water right record. | ||||
| AllocationAssociatedConsumptiveUseSiteIDs | NVarChar(500) |
| List of other sites if this water right has one or more associate consumptive use sites. Add the consumptive use UUIDs as comma separated list here. | ||||
| AllocationAssociatedWithdrawalSiteIDs | NVarChar(500) |
| List of other sites if this water right has one or more associate diversion sites. Add the diversion UUIDs as comma separated list. | ||||
| AllocationBasisCV | NVarChar(250) |
| Description of whether this water right is based on water withdrawals/diversion or consumptive use/depletion amount. | ||||
| AllocationChangeApplicationIndicator | NVarChar(250) |
| Indicator if this water right was the result of a change application. | ||||
| AllocationCommunityWaterSupplySystem | NVarChar(250) |
| If the use is municipal, the data provider can add the SDWIS identifier for the CWS. Only for site specific data. Leave it null for aggregate data. | ||||
| AllocationCropDutyAmount | Float |
| Crop Duty amount. The number of acres of land that is irrigated for the complete growth of a crop by supplying 1-meter cubes per second of water continuously throughout the crop. | ||||
| AllocationExpirationDate | Date |
| Expiration date the water right expires (only really applies if the right is a temporary one). | ||||
| AllocationFlow_CFS | Float |
| The state recognized water right water amount in terms of flow (CFS). | ||||
| AllocationLegalStatusCV | NVarChar(250) | The state recognized legal status of the water right (e.g., proven, approved, perfected, adjudicated, etc.) | |||||
| AllocationNativeID | NVarChar(250) | The state's unique identifier for the water right and it's record. | |||||
| AllocationOwner | NVarChar(250) | Name of the owner / entity with possession of the water right. | |||||
| AllocationPriorityDate | Date | Date given to the water right by the state. Date the water right become legal. Format of MM/DD/YYYY. | |||||
| AllocationTimeframeEnd | Date | End date when the water right no longer can legaly access the assinged water. Format of MM/DD. | |||||
| AllocationTimeframeStart | Date | Start date when the water right can legaly access the assinged water. Format of MM/DD. | |||||
| AllocationTypeCV | NVarChar(250) |
| Description of the type of water right (e.g., Underground Water Claim, Federal Reserved Water Right, etc). | ||||
| AllocationVolume_AF | Float |
| The state recognized water right water amount in terms of volume (AF). | ||||
| BeneficialUseCategoryCV | NVarChar(250) | The data provider's recognized stated purpose for the water right (e.g., irrigation, power, etc) (if multiple, provide as a comma separated list). | |||||
| CommunityWaterSupplySystem | NVarChar(250) |
| Name of the community water system the water right serves (if available). | ||||
| CropTypeCV | NVarChar(100) |
| The type of crop watered by the water right (if available) (e.g., wheat, alfalfa, corn, hay, etc.) (applies mostly to irrigation uses). | ||||
| CustomerTypeCV | NVarChar(100) |
| Description of the type of customer the water right services (e.g., Residential, Commercial, Industrial, Institutional, Combined, Unspecified, etc). | ||||
| DataPublicationDateID | BigInt | Date that this data was published by the data provider to the public. | |||||
| DataPublicationDOI | NVarChar(250) |
| A unique digital object identifier into the original dataset. | ||||
| ExemptOfVolumeFlowPriority | Bit(1) |
| Database indicator for special records. if yes (1), then amount flow, volume, and priority dates can be null (e.g., this case represents groundwater rights in Arizona outside the AMA and INA areas). | ||||
| GeneratedPowerCapacityMW | Float |
| The power (GWh) to be generated by the water right record (if available) (mostly applies to power generating beneficial uses). | ||||
| IrrigatedAcreage | Float |
| Number of acres irrigated by the water right (if available). | ||||
| IrrigationMethodCV | NVarChar(100) |
| A term to describe the method used for the place of use (if available) (applies mostly to irrigation beneficial uses). | ||||
| LegacyAllocationIDs | NVarChar(250) |
| If this water right was the result of a change application, add the legacy right IDs as a comma separated list here. | ||||
| OwnerClassificationCV | NVarChar(250) |
| A term that categorizes the water right owner to a predetermined WaDE defined group. Used for data query and filtering purposes. | ||||
| PopulationServed | Float |
| The amount of population served by the water right (if available). | ||||
| PowerType | NVarChar(50) |
| Description of the type of power generated. | ||||
| PrimaryUseCategoryCV | NVarChar(250) |
| The primary stated purpose by the water right (if available). | ||||
| SDWISIdentifierCV | NVarChar(250) |
| If the use is municipal, the data provider can add the SDWIS identifier for the CWS. | ||||
| WaterAllcationNativeURL | NVarChar(250) |
| Refers back to the state URL that describes the water right (e.g., https://www.waterrights.utah.gov/asp_apps/wrprint/wrprint.asp?wrnum=55-12888). |
(none)
(none)
(none)
| Diagram Name |
| 6_InputTables |