Sustainable Groundwater Management Act (SGMA) Basin Prioritization by US Government | Environmental and Climate Sciences

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: 2023-08-12T12:05:05.612823
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_0da6f896.component_3_public_supply_wells

421.3 KB
11006 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_name" VARCHAR,
  "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_0da6f896.sgma_basin_prioritization_dashboard_data

223.68 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
);