kingcounty-gov/marine-phytoplankton-grouped-by-sample-and-xyty-wq8n
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 12 days ago
Indexed 6 hours ago

Marine Phytoplankton Grouped by Sample and Specific Functional Group

<p>This dataset contains phytoplankton samples collected from Puget Sound and analyzed using a particle imaging analyzer (FlowCAM®). For more information see the King County <a href="https://green2.kingcounty.gov/marine/Monitoring/Phytoplankton" > marine phytoplankton</a> webpage. </p><p>This specific dataset summarizes phytoplankton abundance and biovolume data by functional group. Additional datasets summarize abundance and biovolume data by:</p><p>• <a href="https://data.kingcounty.gov/Environment-Waste-Management/Phytoplankton-Grouped-by-Size-Class/ap4k-tvru" >Size Class (all size classes in a sample in one line)</a></p><p>• <a href="https://data.kingcounty.gov/Environment-Waste-Management/Phytoplankton-Grouped-by-Sample-and-Size-Class/qah3-t5yd" >Sample By Size Class (each sample size class in one line)</a></p><p>• <a href="https://data.kingcounty.gov/dataset/Phytoplankton-Grouped-by-Sample-and-General-Functi/ddc7-9f23" >Sample by Generic Functional Group</a></p><p>• <a href="https://data.kingcounty.gov/Environment-Waste-Management/Marine-Phytoplankton-Samples-by-Taxonomic-Group/uydm-m3ym" >Sample by Taxonomic Group</a></p><p>For locator information, see the <a href="https://data.kingcounty.gov/dataset/WLRD-Sites/wbhs-bbzf">WLRD Water Quality Collection Sites</a> dataset.</p><p>For corresponding water quality data matched by Grab ID see the <a href="https://data.kingcounty.gov/Environment-Waste-Management/Water-Quality/vwmt-pvjw">Water Quality</a> dataset.</p>

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 \"kingcounty-gov/marine-phytoplankton-grouped-by-sample-and-xyty-wq8n\".\"marine_phytoplankton_grouped_by_sample_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • marine_phytoplankton_grouped_by_sample_and