About this Dataset

Marine Phytoplankton Samples By Taxonomic Group

This dataset contains phytoplankton biovolume data from Puget Sound. For species level presence/absence data, please contact MarineWQ@kingcounty.gov . Please download the ReadMe file prior to using the data. For phytoplankton photos, go to https://green2.kingcounty.gov/marine/photo. For more information see the King County marine phytoplankton webpage.

This specific dataset summarizes phytoplankton biovolume data to the lowest practical taxonomic unit. Additional datasets summarize abundance and biovolume data by:

• Sample by Generic Functional Group

• Sample by Specific Functional Group

For locator information, see the WLRD Water Quality Collection Sites dataset.

For corresponding water quality data matched by Grab ID see the Water Quality dataset.
Organization: King County, Washington
Last updated: 2020-11-10T16:58:45.026886
Tags: marine, monitoring, phytoplankton, plankton, puget-sound, water-quality

Tables

Table 1

@usgov.king_county_washington_marine_phytoplankton_samples_by_90730f83.table_1

1.01 MB
48,045 rows
23 columns

CREATE TABLE table_1 (
  "locator" VARCHAR,
  "site_name" VARCHAR,
  "sample_number" VARCHAR,
  "collect_date" TIMESTAMP,
  "depth_m" DOUBLE  -- Depth (m),
  "taxon" VARCHAR,
  "rank" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "biovolume_mm_3_l" DOUBLE  -- Biovolume (mm^3/L),
  "quality" BIGINT,
  "steward_note" VARCHAR,
  "sample_id" BIGINT,
  "grab_id" DOUBLE,
  "profile_id" DOUBLE,
  "replicates" DOUBLE,
  "replicates_of" DOUBLE,
  "datasource" VARCHAR
);