About this Dataset

Routine Marine Sediment Chemistry

Prior to downloading data, please download the **README **file. This dataset contains chemistry results from marine sediment sample collected from offshore (subtidal) and beaches (intertidal) from Puget Sound. It can be filtered by "Site Type". See the Sediment Monitoring Program Website for more information about the program and the Science Section Documents Database to see sampling and analysis plans and reports related to this dataset.
Organization: King County, Washington
Last updated: 2023-07-08T04:39:39.641774
Tags: beach, chemistry, intertidal, marine, offshore, sediment, subtidal, toxics

Tables

Table 1

@usgov.king_county_washington_routine_marine_sediment_chemistry.table_1

468.44 kB
39,085 rows
37 columns

CREATE TABLE table_1 (
  "locator" VARCHAR,
  "site_name" VARCHAR,
  "site_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "sample_number" VARCHAR,
  "sample_depth" DOUBLE,
  "depth_of_sediment" VARCHAR,
  "total_organic_carbon_dry_weight" DOUBLE,
  "toc_qualifier" VARCHAR,
  "total_solids" DOUBLE,
  "parameter" VARCHAR,
  "parameter_type" VARCHAR,
  "dry_weight_concentration" DOUBLE,
  "dry_weight_units" VARCHAR,
  "qualifier" VARCHAR,
  "data_quality" VARCHAR,
  "non_detect" BOOLEAN,
  "mdl_dry_weight" DOUBLE,
  "rdl_dry_weight" DOUBLE,
  "text_value" VARCHAR,
  "steward_note" VARCHAR,
  "criteria_for_comparison" VARCHAR,
  "toc_normalized_concentration" DOUBLE,
  "oc_normalized_units" VARCHAR,
  "oc_normalization" VARCHAR,
  "sms_sqs" DOUBLE,
  "sms_csl" DOUBLE,
  "sms_units" VARCHAR,
  "aet_sqs" DOUBLE,
  "aet_csl" DOUBLE,
  "aet_units" VARCHAR,
  "method" VARCHAR,
  "data_source" VARCHAR,
  "date_analyzed" VARCHAR
);