About this Dataset

Marine Zooplankton Grouped By Sample

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 in an entire sample (abundance and biomass of all species added together). An additional dataset which includes abundance and biomass to a fine taxonomic resolution including life history stages 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:47.614428
Tags: marine, monitoring, plankton, puget-sound, water-quality, zooplankton

Tables

Table 1

@usgov.king_county_washington_marine_zooplankton_grouped_by_sample.table_1

72.24 kB
894 rows
21 columns

CREATE TABLE table_1 (
  "uw_sample_code" VARCHAR,
  "locator" VARCHAR,
  "agency" VARCHAR,
  "site_name" VARCHAR,
  "basin" VARCHAR,
  "tow_type" VARCHAR,
  "collectdatetime" VARCHAR,
  "station_depth_m" DOUBLE  -- Station Depth (m),
  "tow_depth_estimated" DOUBLE  -- Tow Depth (estimated),
  "sensor_depth_m" DOUBLE  -- Sensor Depth (m),
  "volume_sampled_m_3" DOUBLE  -- Volume Sampled (m^3),
  "mesh_size_um" BIGINT  -- Mesh Size (um),
  "collection_confidence" VARCHAR,
  "total_abundance_ind_m_3" DOUBLE  -- Total Abundance (Ind/m^3),
  "total_biomass_mg_c_m_3" DOUBLE  -- Total Biomass (mg C/m^3),
  "total_unique_taxa" BIGINT,
  "quality" BIGINT,
  "steward_note" VARCHAR,
  "sample_id" BIGINT,
  "profile_id" BIGINT,
  "datasource" VARCHAR
);