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 |
|
| ReportingAreaUUID | NVarChar(200) | 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. | ||||
| ReportingAreaName | NVarChar(250) | Recognized name of the data reporting area by the data provider. | |||||
| ReportingAreaNativeID | NVarChar(250) | Unique identifier code / ID used by the data provider to distinguish the reporting area in the source data set. | |||||
| ReportingAreaProductVersion | NVarChar(100) |
| The product version of the reporting area (e.g., ver 1, 2, etc). Similar to ReportingUnitTypeCV. | ||||
| ReportingAreaTypeCV | NVarChar(20) | The high level description of the reporting area type recognized by the data provider (e.g., HUC, County, Basin, etc.). | |||||
| ReportingAreaUpdateDate | Date |
| Date that the ReportingUnitProductVersion was released. | ||||
| StateCV | NVarChar(50) |
| Two digit state abbreviation where the data site is. |
(none)
(none)
(none)
| Diagram Name |
| 6_InputTables |