About this Dataset

Marine Zooplankton Detailed Records

This dataset contains zooplankton samples collected from Puget Sound and analyzed by the Keister lab at the University of Washington. For more information see the King County marine zooplankton webpage.

This specific dataset summarizes zooplankton abundance and biomass data to the lowest practical taxonomic unit, and includes life history stage information (where available). An additional dataset summarizing total zooplankton abundance and biomass by sample is available HERE .

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

For corresponding water quality data matched by Profile ID see the Water Quality dataset.
Organization: King County, Washington
Last updated: 2022-02-22T00:43:48.076795
Tags: marine, monitoring, plankton, puget-sound, water-quality, zooplankton

Tables

Table 1

@usgov.king_county_washington_marine_zooplankton_detailed_records.table_1

1.47 MB
46,216 rows
32 columns

CREATE TABLE table_1 (
  "uw_sample_code" VARCHAR,
  "agency" VARCHAR,
  "locator" VARCHAR,
  "site_name" VARCHAR,
  "basin" VARCHAR,
  "tow_type" VARCHAR,
  "collectdatetime" VARCHAR,
  "station_depth_m" DOUBLE  -- Station Depth (m),
  "tow_depth_m_estimated" DOUBLE  -- Tow Depth (m) Estimated,
  "sensor_depth_m" DOUBLE  -- Sensor Depth (m),
  "volume_sampled_m_3" DOUBLE  -- Volume Sampled (m^3),
  "mesh_size_um" BIGINT  -- Mesh Size (um),
  "taxon" VARCHAR,
  "rank" VARCHAR,
  "life_stage" VARCHAR,
  "sex" VARCHAR,
  "ssmsp_taxa_group" VARCHAR,
  "functional_group" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "abundance_ind_m_3" DOUBLE  -- Abundance (Ind/m^3),
  "biomass_mg_c_m_3" DOUBLE  -- Biomass (mg C/m^3),
  "quality" BIGINT,
  "steward_note" VARCHAR,
  "sample_id" BIGINT,
  "profile_id" BIGINT,
  "datasource" VARCHAR
);