OD0002 Pesticide Analysis for Finfish and Shellfish
This data set provides pesticide sample analyses results for finfish (brook and rainbow trout) and shellfish (mussels and soft shell clams) for the province’s Pesticide Monitoring Program. The sampling includes a total of nine rivers that are tested across PEI, with three of the rivers being sampled each year.
Finfish are collected from the river by electrofishing or rod and reel. Shellfish are collected from the same river systems manually, as close to the finfish sampling as possible. The purpose of the sampling is to determine if pesticide residues accumulate in the fish/shellfish.
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/od0002-pesticide-analysis-for-finfish-and-4bk3-u3rm\".\"od0002_pesticide_analysis_for_finfish_and\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.