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/h7j9-vgr3Created: 2014-04-28Modified : 2014-11-18Update by syncSocrata script at: 2017-01-05 01:15:32.308000

Dataset Attributes

  • station_name
    Text
    {"value"=>"NF Sullivan Creek", "count"=>1} (), {"value"=>"Pend Oreille R @ Newport", "count"=>1} (), {"value"=>"Pend Oreille R @ Metaline Falls", "count"=>1} (), {"value"=>"Meadow Creek at Aladdin Rd", "count"=>1} (), {"value"=>"Columbia R @ Northport", "count"=>1} (), {"value"=>"Kettle R nr Barstow", "count"=>1} (), {"value"=>"Hunters Creek at Hunters Inn", "count"=>1} (), {"value"=>"Little Pend Oreille R nr NatWildRef", "count"=>1} (), {"value"=>"Colville R @ Greenwood Loop Rd", "count"=>1} (), {"value"=>"Spokane R @ Stateline Br", "count"=>1} ()
  • cat
    Text
    {"value"=>"1", "count"=>39} (), {"value"=>"3", "count"=>26} (), {"value"=>"2", "count"=>21} (), {"value"=>"4", "count"=>3} ()
  • wqitemp
    Text
    {"value"=>"82", "count"=>6} (), {"value"=>"80", "count"=>5} (), {"value"=>"68", "count"=>5} (), {"value"=>"85", "count"=>4} (), {"value"=>"83", "count"=>4} (), {"value"=>"78", "count"=>4} (), {"value"=>"76", "count"=>3} (), {"value"=>"72", "count"=>3} (), {"value"=>"71", "count"=>3} (), {"value"=>"49", "count"=>3} ()
  • station
    Text
    {"value"=>"62C070", "count"=>1} (), {"value"=>"62A150", "count"=>1} (), {"value"=>"62A090", "count"=>1} (), {"value"=>"61E070", "count"=>1} (), {"value"=>"61A070", "count"=>1} (), {"value"=>"60A070", "count"=>1} (), {"value"=>"59D070", "count"=>1} (), {"value"=>"59B200", "count"=>1} (), {"value"=>"59A080", "count"=>1} (), {"value"=>"57A150", "count"=>1} ()
  • id
    Text
  • wqitss
    Text
    {"value"=>"80", "count"=>7} (), {"value"=>"77", "count"=>6} (), {"value"=>"85", "count"=>5} (), {"value"=>"78", "count"=>5} (), {"value"=>"87", "count"=>4} (), {"value"=>"99", "count"=>3} (), {"value"=>"84", "count"=>3} (), {"value"=>"82", "count"=>3} (), {"value"=>"72", "count"=>3} (), {"value"=>"67", "count"=>3} ()
  • wqiturb
    Text
    {"value"=>"87", "count"=>7} (), {"value"=>"100", "count"=>4} (), {"value"=>"82", "count"=>4} (), {"value"=>"97", "count"=>3} (), {"value"=>"88", "count"=>3} (), {"value"=>"86", "count"=>3} (), {"value"=>"84", "count"=>3} (), {"value"=>"77", "count"=>3} (), {"value"=>"75", "count"=>3} (), {"value"=>"73", "count"=>3} ()
  • wqitp
    Text
    {"value"=>"100", "count"=>7} (), {"value"=>"88", "count"=>5} (), {"value"=>"95", "count"=>4} (), {"value"=>"75", "count"=>4} (), {"value"=>"73", "count"=>4} (), {"value"=>"92", "count"=>3} (), {"value"=>"82", "count"=>3} (), {"value"=>"81", "count"=>3} (), {"value"=>"79", "count"=>3} (), {"value"=>"78", "count"=>3} ()
  • core
    Text
    {"value"=>"C", "count"=>66} (), {"value"=>"B", "count"=>9} (), {"value"=>"P", "count"=>7} (), {"value"=>"S", "count"=>7} ()
  • wqitpn
    Text
    {"value"=>"98", "count"=>13} (), {"value"=>"100", "count"=>9} (), {"value"=>"97", "count"=>6} (), {"value"=>"91", "count"=>5} (), {"value"=>"94", "count"=>4} (), {"value"=>"90", "count"=>4} (), {"value"=>"84", "count"=>4} (), {"value"=>"89", "count"=>3} (), {"value"=>"88", "count"=>3} (), {"value"=>"81", "count"=>3} ()
  • overallwqi_2013
    Text
    {"value"=>"79", "count"=>8} (), {"value"=>"85", "count"=>6} (), {"value"=>"86", "count"=>5} (), {"value"=>"84", "count"=>4} (), {"value"=>"75", "count"=>4} (), {"value"=>"68", "count"=>4} (), {"value"=>"88", "count"=>3} (), {"value"=>"81", "count"=>3} (), {"value"=>"69", "count"=>3} (), {"value"=>"90", "count"=>2} ()
  • wqiph
    Text
    {"value"=>"93", "count"=>11} (), {"value"=>"96", "count"=>7} (), {"value"=>"94", "count"=>7} (), {"value"=>"92", "count"=>7} (), {"value"=>"89", "count"=>5} (), {"value"=>"95", "count"=>4} (), {"value"=>"91", "count"=>4} (), {"value"=>"88", "count"=>4} (), {"value"=>"83", "count"=>4} (), {"value"=>"97", "count"=>3} ()
  • wqifc
    Text
    {"value"=>"86", "count"=>7} (), {"value"=>"91", "count"=>6} (), {"value"=>"90", "count"=>6} (), {"value"=>"85", "count"=>6} (), {"value"=>"81", "count"=>6} (), {"value"=>"79", "count"=>6} (), {"value"=>"83", "count"=>5} (), {"value"=>"100", "count"=>4} (), {"value"=>"82", "count"=>4} (), {"value"=>"89", "count"=>3} ()
  • wqioxy
    Text
    {"value"=>"92", "count"=>10} (), {"value"=>"89", "count"=>8} (), {"value"=>"93", "count"=>7} (), {"value"=>"87", "count"=>6} (), {"value"=>"81", "count"=>5} (), {"value"=>"80", "count"=>5} (), {"value"=>"95", "count"=>4} (), {"value"=>"88", "count"=>4} (), {"value"=>"86", "count"=>4} (), {"value"=>"85", "count"=>4} ()
  • location_1_needs_recoding
    Text
  • location_1_longitude
    Text
    {"value"=>"-117.328", "count"=>1} (), {"value"=>"-117.0352", "count"=>1} (), {"value"=>"-117.3733", "count"=>1} (), {"value"=>"-117.6649", "count"=>1} (), {"value"=>"-117.7766", "count"=>1} (), {"value"=>"-118.1253", "count"=>1} (), {"value"=>"-118.2027", "count"=>1} (), {"value"=>"-117.7173", "count"=>1} (), {"value"=>"-117.9923", "count"=>1} (), {"value"=>"-117.0446", "count"=>1} ()
  • location_1_latitude
    Text
    {"value"=>"48.8602", "count"=>1} (), {"value"=>"48.1847", "count"=>1} (), {"value"=>"48.8649", "count"=>1} (), {"value"=>"48.7456", "count"=>1} (), {"value"=>"48.9224", "count"=>1} (), {"value"=>"48.7846", "count"=>1} (), {"value"=>"48.1175", "count"=>1} (), {"value"=>"48.4569", "count"=>1} (), {"value"=>"48.5886", "count"=>1} (), {"value"=>"47.6985", "count"=>1} ()
  • id
    Number

About

  • By on September 8, 2016
  • Updated 3 months ago

Related Datasets