Icon for Socrata external plugin
Open repository in Console
Updated almost 4 years ago
Indexed 3 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"princeedwardisland-ca/od0002-pesticide-analysis-for-finfish-and-4bk3-u3rm\".\"od0002_pesticide_analysis_for_finfish_and\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • od0002_pesticide_analysis_for_finfish_and
Upstream Metadata