ReportingUnits - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: ReportingUnits

The Area for which the Allocation or Estimate is being reported

Columns

PKNameData TypeNULLAutoDefaultCommentFK

ReportingAreaUUIDNVarChar(200) Foreign key unique identifier to ReportingUnits_dim table.
EPSGCodeCVNVarChar(50)

EPSG Code for projection used for WaDE (e.g., EPSG:4326).
GeometryGeometry

The GIS objects / shape written in Well-Known Text (WKT) format.
ReportingAreaNameNVarChar(250) Recognized name of the data reporting area by the data provider.
ReportingAreaNativeIDNVarChar(250) Unique identifier code / ID used by the data provider to distinguish the reporting area in the source data set.
ReportingAreaProductVersionNVarChar(100)

The product version of the reporting area (e.g., ver 1, 2, etc). Similar to ReportingUnitTypeCV.
ReportingAreaTypeCVNVarChar(20) The high level description of the reporting area type recognized by the data provider (e.g., HUC, County, Basin, etc.).
ReportingAreaUpdateDateDate

Date that the ReportingUnitProductVersion was released.
StateCVNVarChar(50)

Two digit state abbreviation where the data site is.

Indexes

(none)


Foreign Keys

(none)


Triggers

(none)


Used in Diagrams

Diagram Name
6_InputTables