WaDE [WaDE_Schema_0.25.xml]
Annual summary of water allocations within the reporting unit.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ORGANIZATION_ID | Integer | Name of the method used to irrigate (i.e. sprinkler, flood, microirrigation, etc.) |
|
|||
|
| REPORT_ID | Integer | A unique identifier assigned to the report by the reporting organization. |
|
|||
|
| REPORT_UNIT_ID | Integer |
|
||||
|
| SUMMARY_SEQ | Integer | |||||
| BENEFICIAL_USE_ID | Integer |
| |||||
| AMOUNT | VarChar(20) |
| Value reported, measured, calculated, or estimated. | ||||
| FRESH_SALINE_iND | VarChar(50) |
| Indicates whether the source is fresh water, saline water, or represents the total of both. | ||||
| SOURCE_TYPE | VarChar(50) |
| Water Source: Ground, Surface, Reuse, Total | ||||
| POWER_GENERATED | VarChar(50) |
| For thermoelectric energy uses, the amount of thermoelectric power generated (in megawatt/hours) during the reporting period. | ||||
| POPULATION_SERVED | VarChar(50) |
| For Municipal uses, the population served within this reporting unit. | ||||
| WFS_FEATURE_REF | VarChar(50) |
| Web Feature Service feature reference for the allocation estimate. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SUMMARY_ALLOCATION_REPORTING_UNIT | DataValues.REPORTING_UNIT | DataValues.SUMMARY_ALLOCATION | ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID | ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID |
(none)
| Diagram Name |
| WaDE_Schema |