About this Dataset

Ground Water - Water Quality Results

Groundwater quality data and related groundwater well information available on the page was queried from the GAMA Groundwater information system (GAMA GIS). Data provided represent a collection of groundwater quality results from various federal, state, and local groundwater sources. Results have been filtered to only represent untreated sampling results for the purpose of characterizing ambient conditions. Data have been standardized across multiple data sets including chemical names and units. Standardization has not been performed for chemical result modifier and others (although we are working currently to standardize most fields). Chemicals that have been standardized are included in the data sets. Therefore, other chemicals have been analyzed for but are not included in GAMA downloads. Groundwater samples have been collected from well types including domestic, irrigation, monitoring, municipal. Wells that cannot accurately be attributed to a category are labeled as "water supply, other". For additional information regarding the GAMA GIS data system please reference our factsheet.
Organization: State of California
Last updated: 2025-07-23T14:49:23.038552
Tags: basin, domestic, geotracker, groundwater, priority, swrcb, water, water-supply, well

Tables

Data Dictionary - GAMA - Division Of Drinking Water (2000-2009)

@usgov.ca_gov_ground_water_water_quality_results.data_dictionary_gama_division_of_drinking_water_2000_2009

4.13 KB
38 rows
4 columns


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

Data Dictionary - GAMA - Division Of Drinking Water (2010-2019)

@usgov.ca_gov_ground_water_water_quality_results.data_dictionary_gama_division_of_drinking_water_2010_2019

4.13 KB
38 rows
4 columns


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

Data Dictionary - GAMA - Division Of Drinking Water (pre 2000)

@usgov.ca_gov_ground_water_water_quality_results.data_dictionary_gama_division_of_drinking_water_pre_2000

4.13 KB
38 rows
4 columns


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

Data Dictionary - GAMA GIS Subset For Natural Recharge Study

@usgov.ca_gov_ground_water_water_quality_results.data_dictionary_gama_gis_subset_for_natural_recharge_study

4.21 KB
38 rows
4 columns


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

Data Dictionary - GAMA - USGS NWIS

@usgov.ca_gov_ground_water_water_quality_results.data_dictionary_gama_usgs_nwis

4.21 KB
38 rows
4 columns


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

GAMA - All Wells (Location Data Only)

@usgov.ca_gov_ground_water_water_quality_results.gama_all_wells_location_data_only

32.11 MB
1178900 rows
38 columns


CREATE TABLE gama_all_wells_location_data_only (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" DOUBLE,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" DOUBLE,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" DOUBLE,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" DOUBLE,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" VARCHAR,
  "src_analysis_date" VARCHAR,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - Department Of Pesticide Regulation

@usgov.ca_gov_ground_water_water_quality_results.gama_department_of_pesticide_regulation

1.88 MB
82932 rows
38 columns


CREATE TABLE gama_department_of_pesticide_regulation (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" BIGINT,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" DOUBLE,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" DOUBLE,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" BIGINT,
  "src_result_modifier" VARCHAR,
  "src_result" DOUBLE,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" DOUBLE,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" VARCHAR,
  "src_analysis_date" VARCHAR,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - Department Of Water Resources

@usgov.ca_gov_ground_water_water_quality_results.gama_department_of_water_resources

32.63 MB
1177945 rows
38 columns


CREATE TABLE gama_department_of_water_resources (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" DOUBLE,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" DOUBLE,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" DOUBLE,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" DOUBLE,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" VARCHAR,
  "src_analysis_date" VARCHAR,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - Division Of Drinking Water (2000-2009)

@usgov.ca_gov_ground_water_water_quality_results.gama_division_of_drinking_water_2000_2009

197.72 MB
6885102 rows
38 columns


CREATE TABLE gama_division_of_drinking_water_2000_2009 (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" DOUBLE,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" DOUBLE,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" DOUBLE,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" DOUBLE,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" BIGINT,
  "src_analysis_date" TIMESTAMP,
  "src_analytical_method" VARCHAR,
  "src_lab_note" BIGINT,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - Division Of Drinking Water (2010-2019)

@usgov.ca_gov_ground_water_water_quality_results.gama_division_of_drinking_water_2010_2019

220.18 MB
6811688 rows
38 columns


CREATE TABLE gama_division_of_drinking_water_2010_2019 (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" DOUBLE,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" DOUBLE,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" VARCHAR,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" DOUBLE,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" VARCHAR,
  "src_analysis_date" TIMESTAMP,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - Division Of Drinking Water (pre 2000)

@usgov.ca_gov_ground_water_water_quality_results.gama_division_of_drinking_water_pre_2000

163.27 MB
5897609 rows
38 columns


CREATE TABLE gama_division_of_drinking_water_pre_2000 (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" DOUBLE,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" DOUBLE,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" DOUBLE,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" DOUBLE,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" BIGINT,
  "src_analysis_date" TIMESTAMP,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - GAMA

@usgov.ca_gov_ground_water_water_quality_results.gama_gama

22.9 MB
715157 rows
38 columns


CREATE TABLE gama_gama (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" VARCHAR,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" VARCHAR,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" VARCHAR,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" VARCHAR,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" VARCHAR,
  "src_analysis_date" VARCHAR,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA GIS Subset For Natural Recharge Study

@usgov.ca_gov_ground_water_water_quality_results.gama_gis_subset_for_natural_recharge_study

4.94 MB
226716 rows
38 columns


CREATE TABLE gama_gis_subset_for_natural_recharge_study (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" DOUBLE,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" VARCHAR,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" VARCHAR,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" VARCHAR,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" VARCHAR,
  "src_analysis_date" TIMESTAMP,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - Local Groundwater Projects

@usgov.ca_gov_ground_water_water_quality_results.gama_local_groundwater_projects

18.74 MB
655602 rows
38 columns


CREATE TABLE gama_local_groundwater_projects (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" VARCHAR,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" VARCHAR,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" DOUBLE,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" DOUBLE,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" BIGINT,
  "src_analysis_date" TIMESTAMP,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

GAMA - USGS NWIS

@usgov.ca_gov_ground_water_water_quality_results.gama_usgs_nwis

69.95 MB
1837905 rows
38 columns


CREATE TABLE gama_usgs_nwis (
  "gm_county_name" VARCHAR,
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "gm_chemical_vvl" VARCHAR,
  "gm_chemical_name" VARCHAR,
  "gm_result_modifier" VARCHAR,
  "gm_result" VARCHAR,
  "gm_chemical_units" VARCHAR,
  "gm_reporting_limit" VARCHAR,
  "gm_samp_collection_date" TIMESTAMP,
  "gm_latitude" DOUBLE,
  "gm_longitude" DOUBLE,
  "gm_well_depth_ft" VARCHAR,
  "gm_top_depth_of_screen_ft" VARCHAR,
  "gm_bottom_depth_of_screen_ft" VARCHAR,
  "gm_cas_number" VARCHAR,
  "gm_altwell_id1" VARCHAR,
  "gm_altwell_id2" VARCHAR,
  "gm_altwell_id3" VARCHAR,
  "src_chemical" VARCHAR,
  "src_result_modifier" VARCHAR,
  "src_result" VARCHAR,
  "src_chemical_units" VARCHAR,
  "src_reporting_limit" VARCHAR,
  "src_samp_collection_date" TIMESTAMP,
  "src_samp_collection_time" VARCHAR,
  "src_analysis_date" VARCHAR,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" DOUBLE,
  "src_longitude" DOUBLE,
  "src_datum" VARCHAR,
  "src_well_depth_ft" VARCHAR,
  "src_top_depth_of_screen_ft" VARCHAR,
  "src_bottom_depth_of_screen_ft" VARCHAR,
  "src_well_category" VARCHAR
);

Data Dictionary - GAMA - Division Of Drinking Water (2020 - Present)

@usgov.ca_gov_ground_water_water_quality_results.n__dictionary_gama_division_of_drinking_water_2020_present

4.13 KB
38 rows
4 columns


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