About this Dataset

Marine Benthic Biomass Data

This dataset contains Puget Sound benthic biomass data by major taxonomic group. **Before accessing data please download theREADME file. ** King County monitors the community of animals that live in and on the sediments at the bottom of Puget Sound. These animals, called benthos, are crucial to the health of Puget Sound. We collect sediment samples to help us understand what the sediments are like physically and chemically and how they support different species. Benthic samples have been collected since 2015 from 14 sites. Every 2 years we sample eight sites in Elliott Bay and every 5 years we collect samples from three deep sites in the mainstem of the Central Basin and three smaller embayments. We also collect benthic samples near treatment plant outfalls as well as cleanup sites. Benthic samples are typically collected in replicates (3-5 samples per location and period of time). These replicates help us understand the variability of the benthic community at that location and are distinguished by the fields "Sample Rep ID" and "Field Replicate". For corresponding benthos identification and abundance data see: Marine Benthic Abundance Data. For questions about the data, please contact MarineWQ@kingcounty.gov.
Organization: King County, Washington
Last updated: 2024-09-13T19:21:15.754657
Tags: benthic, benthos, biomass, invertebrates, marine, puget-sound, sediment

Tables

Table 1

@usgov.king_county_washington_marine_benthic_biomass_data.table_1

50.59 kB
934 rows
21 columns

CREATE TABLE table_1 (
  "sample_rep_id" VARCHAR,
  "locator" VARCHAR,
  "site" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "approx_depth_m" BIGINT  -- Approx Depth (m),
  "project" VARCHAR,
  "sample_type" VARCHAR,
  "sample_id" VARCHAR,
  "collection_date" TIMESTAMP,
  "year" BIGINT,
  "field_replicate" BIGINT,
  "annelida_g" DOUBLE  -- Annelida (g),
  "annelida_qual" VARCHAR,
  "crustacean_g" DOUBLE  -- Crustacean (g),
  "crustacea_qual" VARCHAR,
  "mollusca_g" DOUBLE  -- Mollusca (g),
  "mollusca_qual" VARCHAR,
  "misc_g" DOUBLE  -- Misc. (g),
  "misc_qual" VARCHAR  -- Misc. Qual,
  "notes" VARCHAR
);