WaDE [WaDE_Schema_0.25.xml]
The Location of the detailed allocation, diversion, use, or return flow.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ALLOCATION_ID | Integer | Unique identifier for the allocation | ||||
|
| ORGANIZATION_ID | Integer | A unique identifier assigned to the organization. Identifiers would be managed centrally by ???? | ||||
|
| REPORT_ID | Integer | A unique identifier assigned to the report by the reporting organization. | ||||
|
| LOCATION_SEQ | VarChar(20) | |||||
| STATE | VarChar(20) |
| Code representing the two-digit abbreviation for the state. | ||||
| REPORTING_UNIT_ID | Integer |
| A unique identifier assigned to the reporting unit by the reporting organization. | ||||
| COUNTY_FIPS | VarChar(20) |
| County FIPS code (including the state FIPS code) representing the county. | ||||
| HUC | VarChar(20) |
| Code representing the USGS Hydrologic Unit (or HUC) at the most detailed level that the assignment can be made (6-digit being the lowest level of resolution allowed). Leading 0's should be included. | ||||
| WFS_FEATURE_REF | VarChar(20) |
| Web Feature Service feature reference for the point of diversion |
(none)
(none)
(none)
| Diagram Name |
| WaDE_Schema |