WaDE2.0 [WaDE2.01.xml]
The area for which the Allocation or Estimate is being reported
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ReportingUnitID | BigInt |
| Primary internal key unique identifier for reporting units records. | |||
| ReportingUnitUUID | NVarChar(250) | Foreign key unique identifier to ReportingUnits_dim table. | |||||
| EPSGCodeCV | NVarChar(50) | EPSG Code for projection used for WaDE (e.g., EPSG:4326). |
|
||||
| Geometry | Geometry |
| The GIS objects / shape written in Well-Known Text (WKT) format. | ||||
| ReportingUnitName | NVarChar(250) |
| Recognized name of the data reporting area by the data provider. | ||||
| ReportingUnitNativeID | NVarChar(250) | Unique identifier code / ID used by the data provider to distinguish the reporting area in the source data set. | |||||
| ReportingUnitProductVersion | NVarChar(100) |
| The product version of the reporting area (e.g., ver 1, 2, etc). Similar to ReportingUnitTypeCV. | ||||
| ReportingUnitTypeCV | NVarChar(50) | The high level description of the reporting area type recognized by the data provider (e.g., HUC, County, Basin, etc.). |
|
||||
| ReportingUnitUpdateDate | Date |
| Date that the ReportingUnitProductVersion was released. | ||||
| StateCV | BigInt | Two digit state abbreviation where the data site is. |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ReportingUnits_dim_EPSGCode | CVs.EPSGCode | Core.ReportingUnits_dim | Name | EPSGCodeCV |
| fk_ReportingUnits_dim_ReportingUnitType | CVs.ReportingUnitType | Core.ReportingUnits_dim | Name | ReportingUnitTypeCV |
| fk_ReportingUnits_dim_State | CVs.States | Core.ReportingUnits_dim | Name | StateCV |
(none)
| Diagram Name |
| 3_AggregatedAmounts |
| 4_RegulatoryInfo |