OD0001 Pesticide Analysis for Stream Water
This data set provides pesticide sample analyses results for stream water samples for the province’s Pesticide Monitoring Program.
The sampling includes a total of 9 rivers across PEI, with at least 3 of the rivers being sampled each year.
Stream water samples are collected at least once per year during wet weather sampling conditions.
Department staff collects the samples, which are then sent to a laboratory for analysis.
Results with a " < " represent values below the lab's reporting or quantification limit.
Such results do not confirm the presence nor the absence of a pesticide compound below that level.
Water Quality Guideline or Benchmark Values:
When available, Health Canada Guidance Values were used,
otherwise CCME Canadian Water Quality Guidelines for the Protection of Aquatic Life were used, and otherwise USEPA Aquatic Life Benchmark values were.
- The Canadian Long term freshwater Water Quality Guideline for the Protection of Aquatic Life
Website link is here: http://st-ts.ccme.ca/
- USEPA Aquatic Life Benchmark (lowest value on table was chosen).
Website link is here: http://www.epa.gov/pesticide-science-and-assessing-pesticide-risks/aquatic-life-benchmarks-pesticide-registration#use
3. Health Canada Guidance Value
NOTE: the guideline/benchmark values have been converted from the published units to ng/ml by the author in order to compare the values to the detected results.
These samples are collected in the same rivers as the Finfish/Shellfish and the Stream Sediment Pesticide datasets.
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 \"princeedwardisland-ca/od0001-pesticide-analysis-for-stream-water-jj4n-qqq2\".\"od0001_pesticide_analysis_for_stream_water\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.