About this Dataset

Water Quality Data

The California Department of Water Resources (DWR) discrete (vs. continuous) water quality datasets contains DWR-collected, current and historical, chemical and physical parameters found in routine environmental, regulatory compliance monitoring, and special studies throughout the state.
Organization: State of California
Last updated: 2023-08-12T10:34:04.987537
Tags: california-department-of-water-resources, groundwater, surface-water, water-data-library, water-quality, wdl

Tables

Field Results

@usgov.ca_gov_water_quality_data_c4036.field_results

12.76 MB
1,208,911 rows
22 columns

CREATE TABLE field_results (
  "station_id" BIGINT,
  "station_name" VARCHAR,
  "station_number" VARCHAR,
  "full_station_name" VARCHAR,
  "station_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "status" VARCHAR,
  "county_name" VARCHAR,
  "sample_code" VARCHAR,
  "sample_date" TIMESTAMP,
  "sample_depth" DOUBLE,
  "sample_depth_units" VARCHAR,
  "anl_data_type" VARCHAR,
  "parameter" VARCHAR,
  "fdr_result" DOUBLE,
  "fdr_text_result" VARCHAR,
  "fdr_date_result" TIMESTAMP,
  "fdr_reporting_limit" DOUBLE,
  "uns_name" VARCHAR,
  "mth_name" VARCHAR,
  "fdr_footnote" VARCHAR
);