Beach Water Quality

Contains results of weekly water samples collected at beaches in Marin County, CA. The weekly samples are collected and analyzed for Total Coliform, E. coli, and Enterococcus bacteria. Advisories are posted at a beach when a recreational standard for these indicator organism is exceeded.

Weekly results are published each year starting in April and continuing through October. Sample results in this dataset start with the week of May 29, 2017.

If a sample result is labeled "N/A" it means that no results are available from the beach location that week.

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 \"marincounty/beach-water-quality-88ua-5nh2\".\"beach_water_quality\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.