WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| AggregatedAmountID | BigInt |
| Primary internal key unique identifier for aggregated amount records. | |||
| MethodID | BigInt | Primary internal key unique identifier for method records. |
|
||||
| OrganizationID | BigInt | Primary internal key unique identifier for organization records. |
|
||||
| ReportingUnitID | BigInt | Primary internal key unique identifier for reporting units 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 aggregated amount of water in the area. | |||||
| 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(100) |
| A unique digital object identifier into the original dataset. | ||||
| InterbasinTransferFromID | NVarChar(100) |
| 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(100) |
| 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(50) |
| Description of the type of power generated. | ||||
| PrimaryUseCategoryCV | NVarChar(250) |
| The primary stated purpose by the water allocation (if available). |
|
|||
| ReportYearCV | BigInt |
| 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 |
| Primary internal key unique identifier for end date when the water right no longer can legally access the assigned water. Format of MM/DD. |
|
|||
| TimeframeStartID | BigInt |
| Primary internal key unique identifier for start date when the water right can legally access the assigned water. Format of MM/DD. |
|
(none)
(none)
| Diagram Name |
| 3_AggregatedAmounts |