About this Dataset

GSP Monitoring Data

The Groundwater Sustainability Plan (GSP) Monitoring dataset contains the monitoring sites and associated groundwater level, subsidence or streamflow measurements collected by Groundwater Sustainability Agencies (GSA) during implementation of their GSP. All data is submitted to the Department of Water Resources (DWR) through the Sustainable Groundwater Management Act (SGMA) Portal’s Monitoring Network Module (MNM).

The GSP Regulations established the monitoring network criteria (23 CCR § 354.34) and the data and reporting standard for monitoring sites and measurements (23 CCR § 352.4). The data fields associated with these datasets were created by DWR to ensure that GSAs electronically submit monitoring site and measurement data which meets the GSP Regulation’s data and reporting standards. For additional information regarding GSAs, GSPs, and SGMA related monitoring, please view DWR’s SGMA Portal Resources at https://sgma.water.ca.gov/portal/.
Organization: State of California
Last updated: 2025-07-23T19:40:26.090916
Tags: california-department-of-water-resources, groundwater-sustainability-plan, gsp, monitoring-network

Tables

Groundwater Level Data

@usgov.ca_gov_gsp_monitoring_data_f25ee.groundwater_level_data

62.95 MB
1,714,581 rows
19 columns

CREATE TABLE groundwater_level_data (
  "stn_id" BIGINT,
  "site_code" VARCHAR,
  "wlm_id" BIGINT,
  "well_name" VARCHAR,
  "basin_name" VARCHAR,
  "gsa_name" VARCHAR,
  "gsp_name" VARCHAR,
  "msmt_date" TIMESTAMP,
  "wlm_rpe" DOUBLE,
  "wlm_gse" DOUBLE,
  "gwe" DOUBLE,
  "gse_gwe" DOUBLE,
  "wlm_qa_desc" VARCHAR,
  "wlm_desc" VARCHAR,
  "wlm_acc_desc" VARCHAR,
  "msmt_cmt" VARCHAR,
  "wlm_org_name" VARCHAR,
  "coop_org_name" VARCHAR,
  "monitoring_program" VARCHAR
);

GSP Monitoring Sites (New - Under Development)

@usgov.ca_gov_gsp_monitoring_data_f25ee.gsp_monitoring_sites_new_under_development

847.06 kB
12,514 rows
48 columns

CREATE TABLE gsp_monitoring_sites_new_under_development (
  "sgma_site_id" VARCHAR,
  "program_type" VARCHAR,
  "ewm_id" DOUBLE,
  "general_site_id" DOUBLE,
  "existing_info_id" DOUBLE,
  "program_site_id" VARCHAR,
  "local_site_name" VARCHAR,
  "program_name" VARCHAR,
  "url_site" VARCHAR,
  "location_description" VARCHAR,
  "additional_comments" VARCHAR,
  "site_type" VARCHAR,
  "basin_number_name" VARCHAR,
  "basin_id" VARCHAR,
  "basin_subb" VARCHAR,
  "basin_name" VARCHAR,
  "subbasin_n" VARCHAR,
  "gsa_app_id" DOUBLE,
  "alt_agency_id" DOUBLE,
  "agency_name" VARCHAR,
  "gsp_id" DOUBLE,
  "alt_report_id" DOUBLE,
  "gsp_name" VARCHAR,
  "monitoring_network_type" VARCHAR,
  "sustainability_indicators" VARCHAR,
  "principal_aquifer" VARCHAR,
  "state_well_number" VARCHAR,
  "rp_elevation" DOUBLE,
  "rp_description" VARCHAR,
  "rp_elevation_subsurface" DOUBLE,
  "gs_elevation" DOUBLE,
  "meas_method" VARCHAR,
  "meas_acc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "depth" DOUBLE,
  "cased_depth" DOUBLE,
  "depth_top" DOUBLE,
  "depth_bottom" DOUBLE,
  "county" VARCHAR,
  "created_dt" TIMESTAMP,
  "updated_dt" TIMESTAMP,
  "sus_groundwater_level" VARCHAR,
  "sus_groundwater_storage" VARCHAR,
  "sus_seawater_intrusion" VARCHAR,
  "sus_water_quality" VARCHAR,
  "sus_land_subsidence" VARCHAR,
  "sus_inter_surface_water" VARCHAR
);