About this Dataset

Marine Phytoplankton Grouped By Sample And General Functional Group

This dataset contains phytoplankton samples collected from Puget Sound and analyzed using a particle imaging analyzer (FlowCAM®). For more information see the King County marine phytoplankton webpage.

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

• Size Class (all size classes in a sample in one line)

• Sample By Size Class (each sample size class in one line)

• Sample by Specific Functional Group

• Sample by Taxonomic 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:36.442028
Tags: marine, monitoring, phytoplankton, plankton, puget-sound, water-quality

Tables

Table 1

@usgov.king_county_washington_marine_phytoplankton_grouped_by_bb9b846b.table_1

281.76 kB
10,251 rows
16 columns

CREATE TABLE table_1 (
  "locator" VARCHAR,
  "site_name" VARCHAR,
  "sample_number" VARCHAR,
  "collect_date" TIMESTAMP,
  "depth_m" DOUBLE  -- Depth (m),
  "general_group" VARCHAR,
  "biovolume_mm_3_l" DOUBLE  -- Biovolume (mm^3/L),
  "abundance_particles_ml" DOUBLE  -- Abundance (particles/mL),
  "quality" BIGINT,
  "steward_note" VARCHAR,
  "sample_id" BIGINT,
  "grab_id" DOUBLE,
  "profile_id" DOUBLE,
  "replicates" DOUBLE,
  "replicates_of" DOUBLE,
  "datasource" VARCHAR
);