About this Dataset

DWR Continuous Data Download Links

Stations and a table of download links for time-series data, from DWR's continuous environmental monitoring database. For more information, see DWR's Water Data Library, continuous data section: https://wdl.water.ca.gov/ContinuousData.aspx, where this data is also available.
Organization: State of California
Last updated: 2025-07-23T19:48:43.693545
Tags: california, california-department-of-water-resources, data, dwr, environmental, groundwater, monitoring, surface-water, time-series, water, water-quality

Tables

Data Dictionary - Stations

@usgov.ca_gov_dwr_continuous_data_download_links_90cc9.data_dictionary_stations

5.74 KB
16 rows
4 columns


CREATE TABLE data_dictionary_stations (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Station-Trace Links To Time-series Downloads

@usgov.ca_gov_dwr_continuous_data_download_links_90cc9.data_dictionary_station_trace_links_to_time_series_downloads

4.04 KB
9 rows
4 columns


CREATE TABLE data_dictionary_station_trace_links_to_time_series_downloads (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Parameters

@usgov.ca_gov_dwr_continuous_data_download_links_90cc9.parameters

2.82 KB
25 rows
2 columns


CREATE TABLE parameters (
  "param" VARCHAR,
  "desc" VARCHAR
);

Stations

@usgov.ca_gov_dwr_continuous_data_download_links_90cc9.stations

143.83 KB
1273 rows
16 columns


CREATE TABLE stations (
  "county" VARCHAR,
  "station_short_name" VARCHAR,
  "station_name" VARCHAR,
  "cdec_id" VARCHAR,
  "positional_accuracy" VARCHAR,
  "dwr_gw_site_code" VARCHAR,
  "station_type" VARCHAR,
  "longitude" DOUBLE,
  "comments" VARCHAR,
  "lldatum" VARCHAR,
  "station_number" VARCHAR,
  "last_modified_date" TIMESTAMP,
  "latitude" DOUBLE,
  "last_modified_by" VARCHAR,
  "source" VARCHAR,
  "date_data_refers_to" TIMESTAMP
);

Station-Trace Links To Time-series Downloads

@usgov.ca_gov_dwr_continuous_data_download_links_90cc9.station_trace_links_to_time_series_downloads

141.08 KB
6598 rows
9 columns


CREATE TABLE station_trace_links_to_time_series_downloads (
  "station_number" VARCHAR,
  "station_type" VARCHAR,
  "parameter" VARCHAR,
  "datasource" VARCHAR,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "desc" VARCHAR,
  "output_interval" VARCHAR,
  "download_link" VARCHAR
);