About this Dataset

Marine Phytoplankton Grouped By Sample And Specific 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 by functional group. 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 Generic 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:47.764596
Tags: marine, monitoring, phytoplankton, plankton, puget-sound, water-quality

Tables

Table 1

@usgov.king_county_washington_marine_phytoplankton_grouped_by_ca4edee5.table_1

451.3 kB
18,062 rows
17 columns

CREATE TABLE table_1 (
  "locator" VARCHAR,
  "site_name" VARCHAR,
  "sample_number" VARCHAR,
  "collect_date" TIMESTAMP,
  "depth_m" DOUBLE  -- Depth (m),
  "general_group" VARCHAR,
  "specific_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
);