WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| AllocationAmountID | BigInt |
| Primary key unique identifier for allocation records. | |||
| MethodID | BigInt | Primary internal key unique identifier for method records. |
|
||||
| OrganizationID | BigInt | Primary internal key unique identifier for organization records. |
|
||||
| VariableSpecificID | BigInt | Primary internal key unique identifier for variable records. |
|
||||
| AllocationApplicationDateID | BigInt |
| Foreign key unique identifier to Dates_dim table. Date of the original filing on the water allocation recrod. |
|
|||
| 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(100) |
| Indicate 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. | ||||
| AllocationExpirationDateID | BigInt |
| 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(500) |
| Name of the owner / entity with possesion of the water right. | ||||
| AllocationPriorityDateID | BigInt |
| Date given to the water right by the state. Date the water right become legal. |
|
|||
| AllocationTimeframeEnd | NVarChar(5) |
| End month/day for the water right each year in MM/DD | ||||
| AllocationTimeframeStart | NVarChar(5) |
| Start month/day for the water right each year in 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). | ||||
| 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 servies (e.g., Residential, Commercial, Industrial, Institutional, Combined, Unspecified, etc). |
|
|||
| CommunityWaterSupplySystem | VarChar(250) |
| Name of the community water system the water right serves (if available). | ||||
| DataPublicationDateID | BigInt | Date that this data was published by the data provider to the public. |
|
||||
| DataPublicationDOI | NVarChar(100) |
| A unique digital object identifier into the original dataset. | ||||
| ExemptOfVolumeFlowPriority | Boolean | 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(500) |
| A term that catagorizes the water right owner to a predetermined WaDE defined group. Used for data query and filtering purposes. | ||||
| PopulationServed | Float |
| The amount of population servied by the water right (if available). | ||||
| PowerType | BigInt |
| Description of the type of power generated. | ||||
| PrimaryUseCategoryCV | NVarChar(250) |
| The primary benefical used by the water right (if available). |
|
|||
| SDWISIdentifierCV | BigInt |
| 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)
| Diagram Name |
| 1_WaterAllocations |