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.090906
Tags: california-department-of-water-resources, groundwater-sustainability-plan, gsp, monitoring-network

Tables

Data Dictionary - Existing Sites

@usgov.ca_gov_gsp_monitoring_data_f25ee.data_dictionary_existing_sites

5.05 kB
20 rows
4 columns


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

Data Dictionary - Groundwater Level Data

@usgov.ca_gov_gsp_monitoring_data_f25ee.data_dictionary_groundwater_level_data

5.49 kB
19 rows
4 columns


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

Data Dictionary - Groundwater Level Sites

@usgov.ca_gov_gsp_monitoring_data_f25ee.data_dictionary_groundwater_level_sites

6.25 kB
30 rows
4 columns


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

Data Dictionary - Stream Gage Data

@usgov.ca_gov_gsp_monitoring_data_f25ee.data_dictionary_stream_gage_data

4.62 kB
15 rows
4 columns


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

Data Dictionary - Stream Gage Sites

@usgov.ca_gov_gsp_monitoring_data_f25ee.data_dictionary_stream_gage_sites

5.26 kB
27 rows
4 columns


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

Data Dictionary - Subsidence Data

@usgov.ca_gov_gsp_monitoring_data_f25ee.data_dictionary_subsidence_data

4.83 kB
15 rows
4 columns


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

Data Dictionary - Subsidence Sites

@usgov.ca_gov_gsp_monitoring_data_f25ee.data_dictionary_subsidence_sites

5.42 kB
27 rows
4 columns


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

Groundwater Level Data

@usgov.ca_gov_gsp_monitoring_data_f25ee.groundwater_level_data

63 MB
1,715,163 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
);

Groundwater Level Sites

@usgov.ca_gov_gsp_monitoring_data_f25ee.groundwater_level_sites

693.66 kB
6,685 rows
30 columns


CREATE TABLE groundwater_level_sites (
  "stn_id" BIGINT,
  "site_code" VARCHAR,
  "well_name" VARCHAR,
  "basin_name" VARCHAR,
  "gsa_name" VARCHAR,
  "gsp_name" VARCHAR,
  "monitoring_network_type" VARCHAR,
  "sustainability_indicators" VARCHAR,
  "principal_aquifer" VARCHAR,
  "swn" VARCHAR,
  "wcr_no" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "well_use" VARCHAR,
  "well_type" VARCHAR,
  "well_depth" DOUBLE,
  "top_prf" DOUBLE,
  "bot_prf" DOUBLE,
  "last_gse" DOUBLE,
  "last_rpe" DOUBLE,
  "smc_start_date" TIMESTAMP,
  "smc_mt" DOUBLE,
  "smc_im_5_yr" DOUBLE,
  "smc_im_10_yr" DOUBLE,
  "smc_im_15_yr" DOUBLE,
  "smc_mo" DOUBLE,
  "comments" VARCHAR,
  "first_msmt_date" TIMESTAMP,
  "last_msmt_date" TIMESTAMP,
  "msmt_count" DOUBLE
);

GSP Monitoring Sites (New - Under Development)

@usgov.ca_gov_gsp_monitoring_data_f25ee.gsp_monitoring_sites_new_under_development

846.75 kB
12,517 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
);

Data Dictionary - GSP Monitoring Sites (New - Under Development)

@usgov.ca_gov_gsp_monitoring_data_f25ee.n__dictionary_gsp_monitoring_sites_new_under_development

3.91 kB
48 rows
4 columns


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

Data Dictionary - Sustainability Management Criteria (SMC) (New - Under Development)

@usgov.ca_gov_gsp_monitoring_data_f25ee.n__dictionary_sustainability_management_criteria_smc_n_b7136a49

3.39 kB
9 rows
4 columns


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

Stream Gage Data

@usgov.ca_gov_gsp_monitoring_data_f25ee.stream_gage_data

1.33 MB
215,651 rows
15 columns


CREATE TABLE stream_gage_data (
  "program_type" VARCHAR,
  "general_site_id" BIGINT,
  "local_site_name" VARCHAR,
  "basin_name" VARCHAR,
  "gsp_name" VARCHAR,
  "gsa_name" VARCHAR,
  "alt_agency_name" VARCHAR,
  "monitoring_network_type" VARCHAR,
  "date_of_measurement" TIMESTAMP,
  "cum_displace_elev" VARCHAR,
  "date_of_displace_start" VARCHAR,
  "comments" VARCHAR,
  "name" VARCHAR,
  "created_dt" TIMESTAMP,
  "updated_dt" TIMESTAMP
);

Stream Gage Sites

@usgov.ca_gov_gsp_monitoring_data_f25ee.stream_gage_sites

26.21 kB
82 rows
27 columns


CREATE TABLE stream_gage_sites (
  "program_type" VARCHAR,
  "general_site_id" BIGINT,
  "local_site_name" VARCHAR,
  "site_type" VARCHAR,
  "basin_name" VARCHAR,
  "gsp_name" VARCHAR,
  "gsa_name" VARCHAR,
  "alt_agency_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" VARCHAR,
  "gs_elevation" DOUBLE,
  "meas_method" VARCHAR,
  "meas_acc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "depth" VARCHAR,
  "cased_depth" VARCHAR,
  "depth_top" VARCHAR,
  "depth_bottom" VARCHAR,
  "county" VARCHAR,
  "created_dt" TIMESTAMP,
  "updated_dt" TIMESTAMP
);

Subsidence Data

@usgov.ca_gov_gsp_monitoring_data_f25ee.subsidence_data

195.59 kB
17,654 rows
15 columns


CREATE TABLE subsidence_data (
  "program_type" VARCHAR,
  "general_site_id" BIGINT,
  "local_site_name" VARCHAR,
  "basin_name" VARCHAR,
  "gsp_name" VARCHAR,
  "gsa_name" VARCHAR,
  "alt_agency_name" VARCHAR,
  "monitoring_network_type" VARCHAR,
  "date_of_measurement" TIMESTAMP,
  "cum_displace_elev" DOUBLE,
  "date_of_displace_start" TIMESTAMP,
  "comments" VARCHAR,
  "name" VARCHAR,
  "created_dt" TIMESTAMP,
  "updated_dt" TIMESTAMP
);

Subsidence Sites

@usgov.ca_gov_gsp_monitoring_data_f25ee.subsidence_sites

35.22 kB
241 rows
27 columns


CREATE TABLE subsidence_sites (
  "program_type" VARCHAR,
  "general_site_id" BIGINT,
  "local_site_name" VARCHAR,
  "site_type" VARCHAR,
  "basin_name" VARCHAR,
  "gsp_name" VARCHAR,
  "gsa_name" VARCHAR,
  "alt_agency_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
);

Sustainability Management Criteria (SMC) (New - Under Development)

@usgov.ca_gov_gsp_monitoring_data_f25ee.sustainability_management_criteria_smc_new_under_development

98.36 kB
16,745 rows
9 columns


CREATE TABLE sustainability_management_criteria_smc_new_under_development (
  "sgma_site_id" VARCHAR,
  "ewm_id" BIGINT,
  "info_site_id" VARCHAR,
  "existing_site_id" VARCHAR,
  "sustainability_indicator" VARCHAR,
  "start_dt" TIMESTAMP,
  "measurement_type" VARCHAR,
  "value_dt" TIMESTAMP,
  "data_value" DOUBLE
);