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: 2023-08-12T10:15:59.167845
Tags: california-department-of-water-resources, groundwater-sustainability-plan, gsp, monitoring-network

Tables

GSP Monitoring Sites (New - Under Development)

@usgov.ca_gov_gsp_monitoring_data_0e154.gsp_monitoring_sites_new_under_development

833.02 KB
12609 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
);

Subsidence Sites

@usgov.ca_gov_gsp_monitoring_data_0e154.subsidence_sites

34.35 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,
  "gsa_name" VARCHAR,
  "gsp_name" VARCHAR,
  "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_0e154.sustainability_management_criteria_smc_new_under_development

95.52 KB
16590 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
);