About this Dataset

Sustainable Groundwater Management Act (SGMA) Basin Prioritization

The following data and resources were used for the SGMA Basin Prioritization of California’s 515 groundwater basins and subbasins. The Department of Water Resources is mandated by California Water Code Section 10933(b) to prioritize each basin based on eight components.

For more information about how the data was analyzed for Basin Prioritization please see Sustainable Groundwater Management Act Basin Prioritization - Process and Results Document.

Additional questions or requests for information related any of the Basin Prioritization datasets should be directed to the Sustainable Groundwater Management Office at sgmps@water.ca.gov.

For more information on SGMA Basin Prioritization please visit the SGMA Basin Prioritization Homepage.
Organization: State of California
Last updated: 2025-07-24T00:12:53.453085
Tags: bulletin-118, california-department-of-water-resources, groundwater, sgma, sustainable-groundwater-management-act, water

Tables

Component 3 – Public Supply Wells

@usgov.ca_gov_sustainable_groundwater_management_act_sgma_bas_1d725859.component_3_public_supply_wells

431.41 kB
11,006 rows
11 columns

CREATE TABLE component_3_public_supply_wells (
  "public_water_supply_identification" VARCHAR,
  "public_water_supply_name" VARCHAR,
  "basin_subbasin_number" VARCHAR  -- Basin - Subbasin Number,
  "basin_subbasin_name" VARCHAR  -- Basin - Subbasin Name,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "service_connections" BIGINT,
  "facility_name" VARCHAR,
  "water_type" VARCHAR,
  "coordinates_assigned" VARCHAR,
  "comments" VARCHAR
);

SGMA Basin Prioritization (Dashboard Data)

@usgov.ca_gov_sustainable_groundwater_management_act_sgma_bas_1d725859.sgma_basin_prioritization_dashboard_data

229.05 kB
515 rows
90 columns

CREATE TABLE sgma_basin_prioritization_dashboard_data (
  "basin_subbasin_number" VARCHAR,
  "basin_subbasin_name" VARCHAR,
  "hydrologic_region" VARCHAR,
  "region_office" VARCHAR,
  "basin_area_acres" DOUBLE,
  "basin_area_sqmi" DOUBLE,
  "project_phase" BIGINT,
  "c1_population_census" BIGINT,
  "c1_population_sqmi" BIGINT,
  "c1_priority_points" BIGINT,
  "c2_population_projection" BIGINT,
  "c2_population_growth" DOUBLE,
  "c2_zero_2010_population" BOOLEAN,
  "c2_negative_or_no_growth" BOOLEAN,
  "c2_postive_growth_and_2010_pop_1000" BOOLEAN,
  "c2_density_50_and_2010_population_25000" BOOLEAN,
  "c2_priority_points" BIGINT,
  "c3_public_supply_groundwater_wells" BIGINT,
  "c3_public_supply_wells_sqmi" DOUBLE,
  "c3_priority_points" BIGINT,
  "c4_total_groundwater_wells" BIGINT,
  "c4_production_wells_sqmi" DOUBLE,
  "c4_priority_points" BIGINT,
  "c5_irrigated_acres" BIGINT,
  "c5_irrigated_acres_sqmi" DOUBLE,
  "c5_priority_points" BIGINT,
  "c6_agricultural_groundwater_af" DOUBLE,
  "c6_agricultural_surface_water_af" DOUBLE,
  "c6_agricultural_total_applied_water_af" DOUBLE,
  "c6_agricultural_groundwater_percent_supply" DOUBLE,
  "c6_agricultural_surface_water_percent_supply" DOUBLE,
  "c6_urban_groundwater_af" BIGINT,
  "c6_urban_surface_water_af" BIGINT,
  "c6_urban_purchased_surface_water_af" BIGINT,
  "c6_urban_total_water_use_af" BIGINT,
  "c6_urban_groundwater_percent_supply" DOUBLE,
  "c6_urban_surface_purchased_water_percent_supply" DOUBLE,
  "c6_other_groundwater" BIGINT,
  "c6_other_surface_water" BIGINT,
  "c6_groundwater_use_af" DOUBLE,
  "c6_surface_water_use_af" DOUBLE,
  "c6_total_water_use_af" DOUBLE,
  "c6a_groundwater_use_af_basinacre" DOUBLE,
  "c6a_points" BIGINT,
  "c6b_groundwater_percent_supply" DOUBLE,
  "c6b_surface_water_percent_supply" DOUBLE,
  "c6b_points" BIGINT,
  "c6_priority_points" DOUBLE,
  "c7_impacts_declining_groundwater_levels_points" VARCHAR,
  "c7_impacts_declining_groundwater_levels_comment" VARCHAR,
  "c7_impacts_subsidence_points" BIGINT,
  "c7_impacts_subsidence_comment" VARCHAR,
  "c7_impacts_salt_intrusion_points" BIGINT,
  "c7_impacts_salt_intrusion_comment" VARCHAR,
  "c7_impacts_wq_detects" BIGINT,
  "c7_wq_mcl_exceed" BIGINT,
  "c7_wq_average_mcl_exceedance" DOUBLE,
  "c7_wq_average_mcl_exceed_points" BIGINT,
  "c7_wq_unique_wells_excd" BIGINT,
  "c7_wq_wells_excd_per_psw" DOUBLE,
  "c7_wq_wells_excd_per_psw_points" BIGINT,
  "c7_wq_calculated_points" BIGINT,
  "c7_wq_other" BIGINT,
  "c7_impacts_water_quality_points" BIGINT,
  "c7_impacts_water_quality_comment" BIGINT,
  "c7_impacts_total_points" DOUBLE,
  "c7_priority_points" BIGINT,
  "c8a_streamflow_points" BIGINT,
  "c8a_habitat_points" BIGINT,
  "c8a_monitoring" BOOLEAN,
  "c8a_monitoring_and_groundwaterthreshold_adverse" VARCHAR,
  "c8a_adverse_adjustment" BIGINT,
  "c8a_adversecomment" VARCHAR,
  "c8a_habitatsf_priority_points" BIGINT,
  "c8b_basinotherinfo_priority_points" BIGINT,
  "c8b_basinotherinfocomment" VARCHAR,
  "c8a_and_c8b_priority_points" BIGINT,
  "c8c_2kgroundwater" BOOLEAN,
  "c8c_9_5kgw_nodocimpacts" BOOLEAN,
  "c8c_adjudication" BOOLEAN,
  "c8c_groundwater_nonadj_af" BIGINT,
  "c8c_9_5kgw_nonadj" BOOLEAN,
  "c8c_criticaloverdraft" BOOLEAN,
  "c8c_outofbasingwexports_substitutiontransfers" BOOLEAN,
  "substitution_year" BIGINT,
  "substitution_amt" BIGINT,
  "substitution_prioritypoints" BIGINT,
  "total_priority_points" DOUBLE,
  "priority" VARCHAR,
  "priority_change_2014_to_2018" VARCHAR
);