WaDE2.0 [WaDE2.01.xml]
Site specific
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| SiteID | BigInt |
| Primary internal key unique identifier for site records. | |||
| SiteUUID | NVarChar(200) | Foreign key unique identifier to Sites_dim table. | |||||
| CoordinateAccuracy | NVarChar(255) |
| Description of the data accuracy. The data are accurate to +/- x of a second of a degree (using a differentially corrected GPS). | ||||
| CoordinateMethodCV | NVarChar(100) | Description of the coordinate method used to generate the GIS location portion of the data. |
|
||||
| County | NVarChar(20) |
| Name of the county the data site is located in. | ||||
| 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. | ||||
| GNISCodeCV | NVarChar(50) |
| The most appropriate Geographic Names Information System (GNIS) identifier for the source location. |
|
|||
| HUC12 | NVarChar(20) |
| The Hydrologic Unit Identifier Code at level 12 of where the data site is located in. | ||||
| HUC8 | NVarChar(20) |
| The Hydrologic Unit Identifier Code at level 8 of where the data site is located in. | ||||
| Latitude | Double | Latitude coordinate of the data site. Up to six significant digits in WGS 84. | |||||
| Longitude | Double | Longitude coordinate of the data site. Up to six significant digits in WGS 84. | |||||
| NHDNetworkStatusCV | NVarChar(50) |
| USGS NHD network status identifier term (if available). |
|
|||
| NHDProductCV | NVarChar(50) |
| NHD product used for indexing (if available) (e.g., NHDPlus V1, NHDPlus V2, NHD Med Res, NHD High Res, etc). |
|
|||
| PODorPOUSite | NVarChar(20) |
| WaDe identifier term if the data site is a point of diversion (POD), place of use (POU), or a gage station. Used for linking sites under similar records. | ||||
| SiteName | NVarChar(500) | Recognized name of the data site by the data provider. | |||||
| SiteNativeID | NVarChar(50) |
| Unique identifier code / ID used by the data provider to distinguish the data site in the source data set. | ||||
| SitePoint | Geometry |
| The GIS data point / center of area written in Well-Known Text (WKT) format. Similar to Geometry field. | ||||
| SiteTypeCV | NVarChar(100) |
| The high level description of the site type recognized by the data provider (e.g., well, spring, reservoir, river, ditch, etc.). |
|
|||
| StateCV | BigInt |
| Two digit state abbreviation where the data site is. |
|
|||
| USGSSiteID | NVarChar(250) |
| Unique identifier code / ID used by the USGS to distinguish the data site in the source data set. Typically separate from SiteNativeID. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Sites_dim_CoordinateMethod | CVs.CoordinateMethod | Core.Sites_dim | Name | CoordinateMethodCV |
| fk_Sites_dim_EPSGCode | CVs.EPSGCode | Core.Sites_dim | Name | EPSGCodeCV |
| fk_Sites_dim_GNISFeatureName | CVs.GNISFeatureName | Core.Sites_dim | Name | GNISCodeCV |
| fk_Sites_dim_NHDNetworkStatus | CVs.NHDNetworkStatus | Core.Sites_dim | Name | NHDNetworkStatusCV |
| fk_Sites_dim_NHDProduct | CVs.NHDProduct | Core.Sites_dim | Name | NHDProductCV |
| fk_Sites_dim_SiteType | CVs.SiteType | Core.Sites_dim | Name | SiteTypeCV |
| fk_Sites_dim_States | CVs.States | Core.Sites_dim | Name | StateCV |
(none)
| Diagram Name |
| 1_WaterAllocations |
| 2_SiteSpecificAmounts |