About this Dataset

Whidbey Basin CTD Casts

This dataset contains in situ water column data at offshore monitoring stations using a Conductivity Temperature Depth (CTD) sensor for the Whidbey Basin. A CTD is a multi-sensor array that measures dissolved oxygen, salinity, temperature, density (calculated), nitrate + nitrite, and fluorescence (as a measure of chlorophyll).
Organization: King County, Washington
Last updated: 2023-01-13T19:27:46.061609
Tags: ctd, marine, water-and-land-resources, water-quality

Tables

Table 1

@usgov.king_county_washington_whidbey_basin_ctd_casts.table_1

4.67 MB
165,586 rows
31 columns

CREATE TABLE table_1 (
  "depth_meters" DOUBLE  -- Depth (meters),
  "locator" VARCHAR,
  "ch_qual" VARCHAR,
  "do_qual" VARCHAR,
  "no23_qual" VARCHAR,
  "sa_qual" VARCHAR,
  "sample_date" VARCHAR,
  "summ_row_id" VARCHAR,
  "up_down" VARCHAR,
  "chlorophyll_g_l" DOUBLE  -- Chlorophyll (µg/L),
  "density_field" DOUBLE,
  "dissolved_oxygen_mg_l" DOUBLE  -- Dissolved Oxygen (mg/L),
  "light_transmission" DOUBLE,
  "nitrate_nitrite_mg_n_l" DOUBLE  -- Nitrate + Nitrite (mg N/L),
  "par_field" DOUBLE,
  "par_surface" DOUBLE,
  "salinity_psu" DOUBLE  -- Salinity (PSU),
  "scan" VARCHAR,
  "sigma_theta_density_kg_m3" DOUBLE  -- Sigma-Theta Density (kg/m3),
  "temperature_c" DOUBLE  -- Temperature (°C),
  "turbidity_field" VARCHAR,
  "loaddate" VARCHAR,
  "lt_qual" VARCHAR,
  "data_row_id" VARCHAR,
  "dn_qual" VARCHAR,
  "tb_qual" VARCHAR,
  "st_qual" VARCHAR,
  "sd_qual" VARCHAR,
  "pas_qual" VARCHAR,
  "pa_qual" VARCHAR,
  "cast_notes" VARCHAR
);