wa-gov/asotin-county-water-quality-ep6p-x4sw
Icon for Socrata external plugin
  •  
    Overview
  •  
    Tables
  •  
    REST API
  •  
    SQL Query
Open repository in Console
 
Readme
Updated 9 months ago
‧
Indexed 5 hours ago

Asotin County Water Quality

Asotin County Public Utilities District (PUD) annual water quality reports, 2003-2020.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"wa-gov/asotin-county-water-quality-ep6p-x4sw\".\"asotin_county_water_quality\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • asotin_county_water_quality
     
    Left sidebar is currently unimplemented
     
     
     
     
    Right sidebar is currently unimplemented
Upstream Metadata
Notes1.-Definitions of Terms Used: Disinfection Byproducts: Trihalomethanes (TTHMs) form as by-products of the chlorination process that is used to kill or inactivate disease-causing microbes. Haloacetic Acids (HAA) are disinfection by-products monitored to determine compliance with EPA ‘s Disinfection By-products Rule.EPA Allowable Limit orMaximum Contaminant Level (MCL):The highest level of contaminant allowed in drinking water.EPA Ideal Goal orMaximum Contaminant Level Goal (MCLG):The level of contaminant in drinking water below which there is no known or expected health risk.Levels in PUD Water: The highest level of compound detected in the PUD water supply. ND= No detection of substance.Year Tested: Indicates the most recent year that a compound was tested. The state requires certain contaminants to be monitored less than once per year because concentrations do not vary significantly from year to year. Testing occurs between Jan. 1 andDec. 31st.Source of Compound: The common source of the compounds detected.Complies?: A “Yes” indicates that the range detected is within EPA allowable limits. A “No” would require an Action Level (AL), the concentration of a contaminant which, if exceeded, triggers treatment or other requirements a water system must follow. •Parts Per Million/Parts Per Billion (PPM/PPB): These units describe the levels of detected contaminants.•Picocuries per liter (pCi/L):This is a measure of radiation for radionuclide testing.2.-If you encounter a term that is not defined in the above note, check the attachment and look for it in the specific year where the term was used.
TemporalPeriod of Time2003-2020Posting FrequencyAnnually

About

Asotin County Water Quality
9 months ago (updated)
5 hours ago (indexed)
Loading...

Topics

  • contaminants
  • disinfection byproducts
  • drinking water
  • environmental protection agency
  • epa
  • + 6

Source

  • Mary Neuman - Asotin County Water Quality

License

Public Domain U.S. Government