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. | |||||
| SiteUUID | NVarChar(250) | Foreign key unique identifier to Sites_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 amount of water at this data site at the time. | ||||
| AssociatedNativeAllocationIDs | NVarChar(500) |
| Associated unique identifier for the water right at this data site used by the data provider's in the source data. | ||||
| 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). | ||||
| DataPublicationDate | 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. | ||||
| Geometry | Geometry |
| The GIS objects / shape written in Well-Known Text (WKT) format. | ||||
| 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(50) |
| Description of the type of power generated. | ||||
| PrimaryUseCategoryCV | NVarChar(250) |
| 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 |