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. | |||||
| ReportingUnitUUID | NVarChar(250) | Foreign key unique identifier to ReportingUnits_dim table. | |||||
| VariableSpecificUUID | NVarChar(250) | Foreign key unique identifier to Variables_dim table. | |||||
| WaterSourceUUID | NVarChar(250) | Foreign key unique identifier to WaterSource_dim table. | |||||
| 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. | ||||
| Amount | Float | The aggregated amount of water in the area. | |||||
| BeneficialUseCategoryCV | NVarChar(500) |
| 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. | ||||
| InterbasinTransferFromID | NVarChar(250) |
| Identifier name / ID of the basin if the water supply type for the reporting unit is designated as an interbasin transfer and from another basin. | ||||
| InterbasinTransferToID | NVarChar(250) |
| Identifier name / ID of the basin if the water supply type for the reporting unit is designated as an interbasin transfer and used in another basin. | ||||
| 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). | ||||
| PopulationServed | Float |
| The amount of population served by the water right (if available). | ||||
| PowerGeneratedGWh | Float |
| The power (GWh) to be generated by the water right record (if available) (mostly applies to power generating beneficial uses). | ||||
| PowerType | NVarChar(25) |
| Description of the type of power generated. | ||||
| PrimaryUseCategory | NVarChar(100) |
| The primary stated purpose by the water allocation (if available). | ||||
| ReportYearCV | NVarChar(4) |
| Year corresponding to the annual reporting period for the aggregated data in the reporting unit. | ||||
| SDWISIdentifierCV | NVarChar(250) |
| If the use is municipal, the data provider can add the SDWIS identifier for the CWS. | ||||
| TimeframeEnd | Date |
| End date when the water right no longer can legally access the assigned water. Format of MM/DD. | ||||
| TimeframeStart | Date |
| Start date when the water right can legally access the assigned water. Format of MM/DD. |
(none)
(none)
(none)
| Diagram Name |
| 6_InputTables |