Description

more
Routine freshwater monitoring data collected by the The WA State Department of Ecology's River and Stream Monitoring Program are summarized by a technique called the "Water Quality Index" (WQI). The WQI ranges from 1 (poor quality) to 100 (good quality). The WQI summary does not include non-standard elements like metals. For temperature, pH, oxygen, and fecal coliform bacteria, the WQI is based on criteria in Washingtons Water Quality Standards, WAC 173-201A. For nutrient and sediment measures where standards are not specific, results are based on expected conditions in a given region. Multiple constituents are combined and results aggregated over time to produce a single score for each station and each year.https://data.wa.gov/d/k5fe-2e4sCreated: 2014-04-28Modified : 2014-10-28Update by syncSocrata script at: 2017-01-05 01:15:35.219000

Dataset Attributes

  • _2000
    Text
    {"value"=>"92", "count"=>3} (), {"value"=>"86", "count"=>3} (), {"value"=>"79", "count"=>3} (), {"value"=>"67", "count"=>3} (), {"value"=>"65", "count"=>3} (), {"value"=>"95", "count"=>2} (), {"value"=>"93", "count"=>2} (), {"value"=>"89", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"85", "count"=>2} ()
  • ssr
    Text
    {"value"=>"Puget Sound", "count"=>25} (), {"value"=>"Upper Columbia ", "count"=>7} (), {"value"=>"Lower Columbia", "count"=>6} (), {"value"=>"Coast", "count"=>6} (), {"value"=>"NorthEast ", "count"=>5} (), {"value"=>"Middle Columbia", "count"=>5} (), {"value"=>"Snake River", "count"=>4} (), {"value"=>"Hood Canal ", "count"=>2} ()
  • _2001
    Text
    {"value"=>"83", "count"=>4} (), {"value"=>"88", "count"=>3} (), {"value"=>"73", "count"=>3} (), {"value"=>"68", "count"=>3} (), {"value"=>"67", "count"=>3} (), {"value"=>"61", "count"=>3} (), {"value"=>"95", "count"=>2} (), {"value"=>"91", "count"=>2} (), {"value"=>"90", "count"=>2} (), {"value"=>"86", "count"=>2} ()
  • _2002
    Text
    {"value"=>"94", "count"=>3} (), {"value"=>"91", "count"=>3} (), {"value"=>"83", "count"=>3} (), {"value"=>"75", "count"=>3} (), {"value"=>"60", "count"=>3} (), {"value"=>"96", "count"=>2} (), {"value"=>"93", "count"=>2} (), {"value"=>"79", "count"=>2} (), {"value"=>"78", "count"=>2} (), {"value"=>"76", "count"=>2} ()
  • ave
    Text
    {"value"=>"77", "count"=>5} (), {"value"=>"86", "count"=>4} (), {"value"=>"81", "count"=>4} (), {"value"=>"76", "count"=>4} (), {"value"=>"78", "count"=>3} (), {"value"=>"72", "count"=>3} (), {"value"=>"66", "count"=>3} (), {"value"=>"90", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"83", "count"=>2} ()
  • station_name
    Text
    {"value"=>"Okanogan R @ Malott", "count"=>1} (), {"value"=>"Okanogan R @ Oroville", "count"=>1} (), {"value"=>"Wenatchee R nr Leavenworth", "count"=>1} (), {"value"=>"Similkameen R @ Oroville", "count"=>1} (), {"value"=>"Wenatchee R @ Wenatchee", "count"=>1} (), {"value"=>"Entiat R nr Entiat ", "count"=>1} (), {"value"=>"Methow R @ Twisp ", "count"=>1} (), {"value"=>"Walla Walla R nr Touchet", "count"=>1} (), {"value"=>"Tucannon R @ Powers", "count"=>1} (), {"value"=>"Snake R @ Interstate Br", "count"=>1} ()
  • station
    Text
    {"value"=>"49A070", "count"=>1} (), {"value"=>"49A190", "count"=>1} (), {"value"=>"45A110", "count"=>1} (), {"value"=>"49B070", "count"=>1} (), {"value"=>"45A070", "count"=>1} (), {"value"=>"46A070", "count"=>1} (), {"value"=>"48A140", "count"=>1} (), {"value"=>"32A070", "count"=>1} (), {"value"=>"35B060", "count"=>1} (), {"value"=>"35A150", "count"=>1} ()
  • _1996
    Text
    {"value"=>"75", "count"=>4} (), {"value"=>"47", "count"=>4} (), {"value"=>"66", "count"=>3} (), {"value"=>"87", "count"=>2} (), {"value"=>"81", "count"=>2} (), {"value"=>"72", "count"=>2} (), {"value"=>"71", "count"=>2} (), {"value"=>"63", "count"=>2} (), {"value"=>"62", "count"=>2} (), {"value"=>"60", "count"=>2} ()
  • _2006
    Text
    {"value"=>"86", "count"=>5} (), {"value"=>"89", "count"=>3} (), {"value"=>"84", "count"=>3} (), {"value"=>"81", "count"=>3} (), {"value"=>"77", "count"=>3} (), {"value"=>"72", "count"=>3} (), {"value"=>"91", "count"=>2} (), {"value"=>"88", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"82", "count"=>2} ()
  • _1997
    Text
    {"value"=>"76", "count"=>4} (), {"value"=>"71", "count"=>3} (), {"value"=>"65", "count"=>3} (), {"value"=>"54", "count"=>3} (), {"value"=>"47", "count"=>3} (), {"value"=>"89", "count"=>2} (), {"value"=>"79", "count"=>2} (), {"value"=>"78", "count"=>2} (), {"value"=>"73", "count"=>2} (), {"value"=>"68", "count"=>2} ()
  • _2005
    Text
    {"value"=>"84", "count"=>5} (), {"value"=>"83", "count"=>3} (), {"value"=>"81", "count"=>3} (), {"value"=>"77", "count"=>3} (), {"value"=>"73", "count"=>3} (), {"value"=>"68", "count"=>3} (), {"value"=>"90", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"85", "count"=>2} (), {"value"=>"80", "count"=>2} ()
  • _1998
    Text
    {"value"=>"77", "count"=>3} (), {"value"=>"74", "count"=>3} (), {"value"=>"71", "count"=>3} (), {"value"=>"66", "count"=>3} (), {"value"=>"61", "count"=>3} (), {"value"=>"89", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"84", "count"=>2} (), {"value"=>"82", "count"=>2} (), {"value"=>"78", "count"=>2} ()
  • _2004
    Text
    {"value"=>"86", "count"=>4} (), {"value"=>"61", "count"=>4} (), {"value"=>"74", "count"=>3} (), {"value"=>"69", "count"=>3} (), {"value"=>"81", "count"=>2} (), {"value"=>"78", "count"=>2} (), {"value"=>"75", "count"=>2} (), {"value"=>"73", "count"=>2} (), {"value"=>"70", "count"=>2} (), {"value"=>"68", "count"=>2} ()
  • _1999
    Text
    {"value"=>"70", "count"=>4} (), {"value"=>"83", "count"=>3} (), {"value"=>"77", "count"=>3} (), {"value"=>"71", "count"=>3} (), {"value"=>"88", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"82", "count"=>2} (), {"value"=>"76", "count"=>2} (), {"value"=>"74", "count"=>2} (), {"value"=>"62", "count"=>2} ()
  • _2003
    Text
    {"value"=>"72", "count"=>5} (), {"value"=>"81", "count"=>3} (), {"value"=>"80", "count"=>3} (), {"value"=>"79", "count"=>3} (), {"value"=>"76", "count"=>3} (), {"value"=>"67", "count"=>3} (), {"value"=>"64", "count"=>3} (), {"value"=>"55", "count"=>3} (), {"value"=>"88", "count"=>2} (), {"value"=>"86", "count"=>2} ()
  • _2009
    Text
    {"value"=>"76", "count"=>5} (), {"value"=>"85", "count"=>3} (), {"value"=>"83", "count"=>3} (), {"value"=>"81", "count"=>3} (), {"value"=>"71", "count"=>3} (), {"value"=>"70", "count"=>3} (), {"value"=>"96", "count"=>2} (), {"value"=>"94", "count"=>2} (), {"value"=>"90", "count"=>2} (), {"value"=>"87", "count"=>2} ()
  • _1994
    Text
    {"value"=>"83", "count"=>5} (), {"value"=>"90", "count"=>3} (), {"value"=>"77", "count"=>3} (), {"value"=>"76", "count"=>2} (), {"value"=>"71", "count"=>2} (), {"value"=>"95", "count"=>1} (), {"value"=>"94", "count"=>1} (), {"value"=>"88", "count"=>1} (), {"value"=>"84", "count"=>1} (), {"value"=>"82", "count"=>1} ()
  • _2008
    Text
    {"value"=>"91", "count"=>4} (), {"value"=>"79", "count"=>4} (), {"value"=>"75", "count"=>4} (), {"value"=>"88", "count"=>3} (), {"value"=>"85", "count"=>3} (), {"value"=>"60", "count"=>3} (), {"value"=>"59", "count"=>3} (), {"value"=>"90", "count"=>2} (), {"value"=>"89", "count"=>2} (), {"value"=>"86", "count"=>2} ()
  • _1995
    Text
    {"value"=>"88", "count"=>4} (), {"value"=>"73", "count"=>3} (), {"value"=>"84", "count"=>2} (), {"value"=>"83", "count"=>2} (), {"value"=>"77", "count"=>2} (), {"value"=>"76", "count"=>2} (), {"value"=>"70", "count"=>2} (), {"value"=>"67", "count"=>2} (), {"value"=>"66", "count"=>2} (), {"value"=>"65", "count"=>2} ()
  • _2007
    Text
    {"value"=>"74", "count"=>5} (), {"value"=>"85", "count"=>4} (), {"value"=>"75", "count"=>4} (), {"value"=>"58", "count"=>4} (), {"value"=>"88", "count"=>3} (), {"value"=>"69", "count"=>3} (), {"value"=>"90", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"81", "count"=>2} (), {"value"=>"80", "count"=>2} ()
  • _2012
    Text
    {"value"=>"88", "count"=>5} (), {"value"=>"83", "count"=>5} (), {"value"=>"76", "count"=>4} (), {"value"=>"70", "count"=>4} (), {"value"=>"84", "count"=>3} (), {"value"=>"81", "count"=>3} (), {"value"=>"91", "count"=>2} (), {"value"=>"86", "count"=>2} (), {"value"=>"85", "count"=>2} (), {"value"=>"79", "count"=>2} ()
  • _2013
    Text
    {"value"=>"79", "count"=>5} (), {"value"=>"86", "count"=>4} (), {"value"=>"68", "count"=>4} (), {"value"=>"88", "count"=>3} (), {"value"=>"75", "count"=>3} (), {"value"=>"69", "count"=>3} (), {"value"=>"90", "count"=>2} (), {"value"=>"89", "count"=>2} (), {"value"=>"87", "count"=>2} (), {"value"=>"85", "count"=>2} ()
  • _2010
    Text
    {"value"=>"78", "count"=>4} (), {"value"=>"63", "count"=>4} (), {"value"=>"86", "count"=>3} (), {"value"=>"81", "count"=>3} (), {"value"=>"77", "count"=>3} (), {"value"=>"74", "count"=>3} (), {"value"=>"89", "count"=>2} (), {"value"=>"88", "count"=>2} (), {"value"=>"83", "count"=>2} (), {"value"=>"79", "count"=>2} ()
  • _2011
    Text
    {"value"=>"63", "count"=>5} (), {"value"=>"77", "count"=>4} (), {"value"=>"70", "count"=>4} (), {"value"=>"89", "count"=>3} (), {"value"=>"85", "count"=>3} (), {"value"=>"68", "count"=>3} (), {"value"=>"79", "count"=>2} (), {"value"=>"76", "count"=>2} (), {"value"=>"75", "count"=>2} (), {"value"=>"73", "count"=>2} ()
  • comment
    Text
    {"value"=>"Annual temperature and sediment scores were almost always below 80. Oxygen, pH, and phosphorus scores were below 80 about half the time. Bacteria and nitrogen scores were always or almost always above 80. The Okanogan River is listed for temperature, oxygen, and pH. ", "count"=>1} (), {"value"=>"Annual temperature, oxygen, and pH scores were almost always below 80. Other scores were always or almost always above 80. The Okanogan River is listed for temperature, oxygen, and pH. This station is very near the lake outlet and temperature, especially, may be naturally high. ", "count"=>1} (), {"value"=>"Annual sediment scores were below 80 most of the time. Temperature, oxygen and pH scores were below 80 about half the time--these scores may be affected by Lake Wenatchee. Nutrient scores were occasionally below 80. Bacteria scores were always or almost always above 80. The upper Wenatchee River has a management plan for temperature and is listed for pH and oxygen. ", "count"=>1} (), {"value"=>"Annual temperature and sediment scores were below 80 most of the time. Phosphorus and pH scores were occasionally below 80. Bacteria, oxygen, and nitrogen scores were always or almost always above 80. The Similkameen River is listed for temperature. ", "count"=>1} (), {"value"=>"Annual temperature and pH scores were below 80 more than half the time. Sediment scores were occasionally below 80. Other scores were always or almost always above 80. The Wenatchee River has a management plan for temperature and is listed for pH. ", "count"=>1} (), {"value"=>"Annual temperature, pH, and sediment scores were occasionally below 80. Other scores were always or almost always above 80. The Entiat has a management plan for temperature and is listed for pH. ", "count"=>1} (), {"value"=>"Annual pH and sediment scores were occasionally below 80. Other scores were always or almost always above 80. The upper Methow is not on the 303d list. ", "count"=>1} (), {"value"=>"Annual scores for sediment, temperature, and phosphorus were frequently below 80. Bacteria was below 80 about half the time. Nitrogen Scores only occasionally dropped below 80. The Walla Walla River has a management plan for temperature, pH, oxygen, and bacteria. ", "count"=>1} (), {"value"=>"Annual scores for all parameters were below 80 more often than not except for oxygen and nitrogen, which only occasionally dropped below 80. The Tucannon River is listed for temperature, pH, and turbidity. ", "count"=>1} (), {"value"=>"Annual temperature, sediment, phosphorus, and pH scores were usually below 80. Oxygen scores were occasionally below 80. Annual bacteria and nitrogen scores were always or almost always above 80. Different portions of the lower Snake River are listed for temperature, oxygen, and pH. ", "count"=>1} ()
  • location_1_needs_recoding
    Text
  • location_1_longitude
    Text
    {"value"=>"-120.4617", "count"=>2} (), {"value"=>"-119.7045", "count"=>1} (), {"value"=>"-119.4267", "count"=>1} (), {"value"=>"-120.734", "count"=>1} (), {"value"=>"-119.442", "count"=>1} (), {"value"=>"-120.3365", "count"=>1} (), {"value"=>"-120.2506", "count"=>1} (), {"value"=>"-120.1143", "count"=>1} (), {"value"=>"-118.7664", "count"=>1} (), {"value"=>"-118.1555", "count"=>1} ()
  • location_1_latitude
    Text
    {"value"=>"46.5815", "count"=>2} (), {"value"=>"48.2804", "count"=>1} (), {"value"=>"48.9391", "count"=>1} (), {"value"=>"47.6762", "count"=>1} (), {"value"=>"48.9346", "count"=>1} (), {"value"=>"47.4588", "count"=>1} (), {"value"=>"47.6632", "count"=>1} (), {"value"=>"48.3593", "count"=>1} (), {"value"=>"46.0376", "count"=>1} (), {"value"=>"46.5376", "count"=>1} ()
  • id
    Number

Related Datasets