WaDE2.0 [WaDE2.01.xml]
Site specific
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| SiteUUID | NVarChar(200) | Foreign key unique identifier to Sites_dim table. | ||||
| RegulatoryOverlayUUIDs | NVarChar(200) |
| Foreign key unique identifier to RegulaotryOverlay_dim table. | ||||
| WaterSourceUUID | NVarChar(200) |
| Foreign key unique identifier to WaterSource_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(10) |
| 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 | Float | Latitude coordinate of the data site. Up to six significant digits in WGS 84. | |||||
| Longitude | Float | 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(50) |
| 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 | NVarChar(5) |
| 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)
(none)
(none)
| Diagram Name |
| 6_InputTables |