About this Dataset

Groundwater Sustainability Plan Annual Report Data

The Groundwater Sustainability Plan (GSP) Annual Report (AR) datasets contain the following data submitted by Groundwater Sustainability Agencies (GSA) and Alternative Agencies as part of their GSP AR or Alternative to GSP AR: groundwater extraction, surface water supply, total water use, and change in storage volumes for a given water year. All data was originally submitted to the Department of Water Resources (DWR) through the Sustainable Groundwater Management Act (SGMA) Portal’s AR Modules (https://sgma.water.ca.gov/portal/gspar/submitted and https://sgma.water.ca.gov/portal/alternative/annualreport/submitted). Data records within each dataset correspond to either an entire basin or one of multiple GSP areas which collectively correspond to an entire basin.

The GSP Regulations established the AR data requirements (23 CCR § 356.2) and tasked DWR with developing an online reporting system for GSAs and Alternative Agencies to electronically submit these data (23 CCR § 353.2). The data fields associated with these datasets were created by DWR to ensure GSAs and Alternative Agencies electronically submitted the required AR data to DWR’s online reporting system, the SGMA Portal (https://sgma.water.ca.gov/portal/). For additional information regarding the AR Modules and the AR submittal process, please view the DWR’s AR resources (https://sgma.water.ca.gov/portal/resources).
Organization: State of California
Last updated: 2023-08-12T10:15:52.230088
Tags: annual-report, california-department-of-water-resources, groundwater-sustainability-plan, gsp, gspar

Tables

Change In Storage - Basin

@usgov.ca_gov_groundwater_sustainability_plan_annual_report_data_d2b6b.change_in_storage_basin

108.86 KB
490 rows
9 columns


CREATE TABLE change_in_storage_basin (
  "gspar_ids" DOUBLE,
  "altar_ids" DOUBLE,
  "report_year" BIGINT,
  "basin_name" VARCHAR,
  "subbasin_number" VARCHAR,
  "single_multiple_ar" VARCHAR,
  "annual_report_area" VARCHAR,
  "change_amount" BIGINT,
  "change_in_storage_method" VARCHAR
);

Groundwater Extraction

@usgov.ca_gov_groundwater_sustainability_plan_annual_report_data_d2b6b.groundwater_extraction

30.71 KB
443 rows
16 columns


CREATE TABLE groundwater_extraction (
  "gspar_ids" DOUBLE,
  "altar_id" DOUBLE,
  "report_year" BIGINT,
  "basin_name" VARCHAR,
  "subbasin_number" VARCHAR,
  "single_multiple_ar" VARCHAR,
  "annual_report_area" VARCHAR,
  "total_groundwater_extractions" BIGINT,
  "wus_urban" BIGINT,
  "wus_industrial" BIGINT,
  "wus_agricultural" BIGINT,
  "wus_managed_wetlands" BIGINT,
  "wus_managed_recharge" BIGINT,
  "wus_vegetation" BIGINT,
  "wus_other" BIGINT,
  "wus_other_explanation" VARCHAR
);

Groundwater Extraction Methods

@usgov.ca_gov_groundwater_sustainability_plan_annual_report_data_d2b6b.groundwater_extraction_methods

102.98 KB
443 rows
32 columns


CREATE TABLE groundwater_extraction_methods (
  "gspar_ids" DOUBLE,
  "altar_id" DOUBLE,
  "report_year" BIGINT,
  "basin_name" VARCHAR,
  "subbasin_number" VARCHAR,
  "single_multiple_ar" VARCHAR,
  "annual_report_area" VARCHAR,
  "meters_volume" BIGINT,
  "mtrs_method_explanation" VARCHAR,
  "mtrs_type" VARCHAR,
  "mtrs_accuracy" VARCHAR,
  "mtrs_accuracy_explanation" VARCHAR,
  "erecords_volume" BIGINT,
  "erecords_method_explanation" VARCHAR,
  "erecords_type" VARCHAR,
  "erecords_accuracy" VARCHAR,
  "erecords_accuracy_explanation" VARCHAR,
  "luse_volume" BIGINT,
  "luse_method_explanation" VARCHAR,
  "luse_type" VARCHAR,
  "luse_accuracy" VARCHAR,
  "luse_accuracy_explanation" VARCHAR,
  "gw_model_volume" BIGINT,
  "gw_model_method_explanation" VARCHAR,
  "gw_model_type" VARCHAR,
  "gw_model_accuracy" VARCHAR,
  "gw_model_accuracy_explanation" VARCHAR,
  "other_volume" BIGINT,
  "other_method_explanation" VARCHAR,
  "other_type" VARCHAR,
  "other_accuracy" VARCHAR,
  "other_accuracy_explanation" VARCHAR
);

Surface Water Supply

@usgov.ca_gov_groundwater_sustainability_plan_annual_report_data_d2b6b.surface_water_supply

46.92 KB
443 rows
18 columns


CREATE TABLE surface_water_supply (
  "gspar_ids" DOUBLE,
  "altar_id" DOUBLE,
  "report_year" BIGINT,
  "basin_name" VARCHAR,
  "subbasin_number" VARCHAR,
  "single_multiple_ar" VARCHAR,
  "annual_report_area" VARCHAR,
  "methods_used" VARCHAR,
  "wst_central_valley_project" BIGINT,
  "wst_state_water_project" BIGINT,
  "wst_colorado_river_project" BIGINT,
  "wst_local_supplies" BIGINT,
  "wst_local_imported_supplies" BIGINT,
  "wst_desalination" BIGINT,
  "wst_recycled_water" BIGINT,
  "wst_other" BIGINT,
  "wst_other_explanation" VARCHAR,
  "total_surface_water" BIGINT
);

Total Water Use

@usgov.ca_gov_groundwater_sustainability_plan_annual_report_data_d2b6b.total_water_use

74.19 KB
444 rows
23 columns


CREATE TABLE total_water_use (
  "gspar_ids" DOUBLE,
  "altar_id" DOUBLE,
  "report_year" BIGINT,
  "basin_name" VARCHAR,
  "subbasin_number" VARCHAR,
  "single_multiple_ar" VARCHAR,
  "annual_report_area" VARCHAR,
  "method_used" VARCHAR,
  "total_water_use" BIGINT,
  "wst_explanation" VARCHAR,
  "wst_groundwater" BIGINT,
  "wst_other" BIGINT,
  "wst_recycled_water" BIGINT,
  "wst_reused_water" BIGINT,
  "wst_surface_water" BIGINT,
  "wus_agricultural" BIGINT,
  "wus_explanation" VARCHAR,
  "wus_industrial" BIGINT,
  "wus_managed_recharge" BIGINT,
  "wus_managed_wetlands" BIGINT,
  "wus_native_vegetation" BIGINT,
  "wus_other" BIGINT,
  "wus_urban" BIGINT
);