Name: WQS ExcursionDataset
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

WQS ExcursionDataset

This dataset consists of stream water quality data from the King County Ambient Stream Monitoring program. The data are evaluated based on the water quality standards assigned to each site by the Washington Department of Ecology.
Organization: King County, Washington
Last updated: 2025-03-22T17:17:18.699824

Tables

Table 1

@usgov.king_county_washington_wqs_excursiondataset.table_1

673.78 KB
145719 rows
19 columns


CREATE TABLE table_1 (
  "sitename" VARCHAR,
  "locator" VARCHAR,
  "lng" DOUBLE,
  "lat" DOUBLE,
  "area" VARCHAR,
  "parameter" VARCHAR,
  "collectdate" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "value" DOUBLE,
  "units" VARCHAR,
  "qualifier" VARCHAR,
  "excursion" BOOLEAN,
  "wria" BIGINT,
  "reachcode" DOUBLE,
  "au" VARCHAR,
  "aquaticlifeuse" VARCHAR,
  "supplemental_spawning" VARCHAR,
  "recreationaluse" VARCHAR
);