Baselight
Sign In

Water Quality Data

State of California

@usgov.ca_gov_water_quality_data_c4036

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.987535
Tags: california-department-of-water-resources, groundwater, surface-water, water-data-library, water-quality, wdl

Tables

Lab Results

@usgov.ca_gov_water_quality_data_c4036.lab_results
  • 21.35 MB
  • 4661894 rows
  • 18 columns
Loading...
 

CREATE TABLE lab_results (
  "station_id" BIGINT,
  "station_name" VARCHAR,
  "full_station_name" VARCHAR,
  "station_number" 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,
  "parameter" VARCHAR,
  "result" VARCHAR,
  "reporting_limit" DOUBLE,
  "units" VARCHAR,
  "method_name" VARCHAR
);

Field Results

@usgov.ca_gov_water_quality_data_c4036.field_results
  • 12.16 MB
  • 1208898 rows
  • 22 columns
Loading...
 

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
);