Readme
Updated 7 months ago
‧ Indexed 2 hours ago
Watershed Health Monitoring: Excess Sediment in Salmon/Trout Streams
This file lists random sites sampled by the Department of Ecology's Watershed Health Monitoring program during 2009-2016. The list is limited to those sites known to be occupied by salmon or trout at some time during the year. It also shows percentage of the stream network represented by the site and whether the observed sediment on the surface of the stream bottom exceeded levels estimated to be optimum for sediment-sensitive salmonids.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| SURVEY | survey | survey | Text | Designates which monitoring pass through the state. 1 = 2009 to 2012; 2 = 2013 to 2019 |
| abv 18.5 | abv_18_5 | abv_18_5 | Number | This value was calculated as follows: PCT SandFines minus 18.5. Calculation of PCT_SandFines is described in the Habitat Data Dictionary: https://fortress.wa.gov/ecy/publications/SummaryPages/1303033.html |
| SITE_ID | site_id | site_id | Text | Unique site identifier from the Washington Master Sample: https://fortress.wa.gov/ecy/gispublic/DataDownload/EAP_ENV_MasterSample.htm |
| SalmonOPT | salmonopt | salmonopt | Text | This field designates whether the observed percentage of sand and fines exceeds the optimum (18.5%) for sediment-sensitive salmonids. See Table 2 of Bryce et al: https://www.pnamp.org/sites/default/files/BryceSAFN-JNABS-4-12-2010.pdf . We have added 5.5 % to Bryce's 13% optimum becuase Watershed Health measures the bankfull channel rather than the wetted channel that the Bryce values describe. Watershed Health data from the bankfull channel show (in a linear, 1:1 fashion) 5.5 % more sand and fines when compared to wetted stations from the same dataset. |
| ASW | asw | asw | Number | Adjusted spatial weights calculated using the US EPA algorithm spsurvey. Weights indicate how many kiometers of stream that the random sample site respresents within the given survey. Weights were calculated for all radnom sites in the Watershed Health Monitoring surveys, regardless of whether salmonid habitat or not. |
| X_PCT SandFines | x_pct_sandfines | x_pct_sandfines | Number | This is the average (for 1 or 2 values) of PCT SandFines as reported by the Watershed Health Monitoring Database: https://ecology.wa.gov/Research-Data/Monitoring-assessment/River-stream-monitoring/Habitat-monitoring/Watershed-health . PCT_SandFines is described in the Habitat Data Dictionary: https://fortress.wa.gov/ecy/publications/SummaryPages/1303033.html |
| Col | col | col | Text | Color = suggested color for charts |
| SALMON_RR | salmon_rr | salmon_rr | Text | Salmon Revovery Region from the Washington Master Sample: https://fortress.wa.gov/ecy/gispublic/DataDownload/EAP_ENV_MasterSample.htm |
| salmonid habitat | salmonid_habitat | salmonid_habitat | Number | 1 indicates that the stream site is occupied by salmon or trout at some time during the year. This is based on Watershed Health Moniroring sampling results or Washington Department of Fish and Wildlife maps: see http://apps.wdfw.wa.gov/phsontheweb/ |
| Year | year | year | Number | Year of sampling |
| ppn_km_salmsed | ppn_km_salmsed | ppn_km_salmsed | Number | Proportion of all salmonid km in the survey (excluding those without sediment data) |
Upstream Metadata