WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| VariableAmountID | BigInt |
| Primary internal key unique identifier for site amount records. | |||
| MethodID | BigInt | Primary internal key unique identifier for method records. |
|
||||
| OrganizationID | BigInt | Primary internal key unique identifier for organization records. |
|
||||
| SiteID | BigInt | Primary internal key unique identifier for site records. |
|
||||
| VariableSpecificID | BigInt | Primary internal key unique identifier for variable records. |
|
||||
| WaterSourceID | BigInt | Primary internal key unique identifier for water source records. | |||||
| 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. | ||||
| 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 | Unique key identifier for 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. | ||||
| Geometry | Geometry |
| The GIS objects / shape written in Well-Known Text (WKT) format. | ||||
| IrrigationMethodCV | NVarChar(100) |
| A term to describe the method used for the place of use (if available) (applies mostly to irrigation beneficial uses). |
|
|||
| IrrigatedAcreage | Float |
| Number of acres irrigated by the water right (if available). | ||||
| 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. |
|
|||
| TimeframeEndID | BigInt | End date when the water right no longer can legally access the assigned water. Format of MM/DD. |
|
||||
| TimeframeStartID | BigInt | Start date when the water right can legally access the assigned water. Format of MM/DD. |
|
(none)
(none)
| Diagram Name |
| 2_SiteSpecificAmounts |