Baselight
Sign In

Ground Water - Water Quality Results

State of California

@usgov.ca_gov_ground_water_water_quality_results

Loading...
Loading...

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-10-23T12:45:51.418493
Tags: basin, domestic, geotracker, groundwater, priority, swrcb, water, water-supply, well

Tables

GAMA - All Wells (Location Data Only)

@usgov.ca_gov_ground_water_water_quality_results.gama_all_wells_location_data_only
  • 7.72 MB
  • 284,806 rows
  • 18 columns
Loading... 
CREATE TABLE gama_all_wells_location_data_only (
  "gm_dataset_name" VARCHAR,
  "gm_well_category" VARCHAR,
  "gm_data_source" VARCHAR,
  "gm_well_id" VARCHAR,
  "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_gis_county" VARCHAR,
  "gm_gis_dwr_basin" VARCHAR,
  "gm_gis_regional_board" VARCHAR,
  "gm_gis_senate_district" VARCHAR,
  "gm_gis_hva" VARCHAR,
  "gm_gis_gama_study_area" VARCHAR,
  "gm_gis_assembly_district" VARCHAR,
  "gm_gis_gsa" VARCHAR,
  "gm_gis_dwr_region" VARCHAR
);

GAMA - Department Of Pesticide Regulation

@usgov.ca_gov_ground_water_water_quality_results.gama_department_of_pesticide_regulation
  • 1.97 MB
  • 82,932 rows
  • 38 columns
Loading... 
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
  • 34.35 MB
  • 1,178,900 rows
  • 38 columns
Loading... 
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
  • 208.89 MB
  • 6,880,546 rows
  • 38 columns
Loading... 
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" VARCHAR,
  "src_longitude" VARCHAR,
  "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
  • 242.99 MB
  • 6,811,190 rows
  • 38 columns
Loading... 
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" VARCHAR,
  "src_analytical_method" VARCHAR,
  "src_lab_note" VARCHAR,
  "src_latitude" VARCHAR,
  "src_longitude" VARCHAR,
  "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
  • 171.38 MB
  • 5,897,456 rows
  • 38 columns
Loading... 
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
  • 23.98 MB
  • 715,157 rows
  • 38 columns
Loading... 
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 - Local Groundwater Projects

@usgov.ca_gov_ground_water_water_quality_results.gama_local_groundwater_projects
  • 19.78 MB
  • 657,791 rows
  • 38 columns
Loading... 
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" 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 - USGS NWIS

@usgov.ca_gov_ground_water_water_quality_results.gama_usgs_nwis
  • 73.43 MB
  • 1,832,811 rows
  • 38 columns
Loading... 
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
);

Share link

Anyone who has the link will be able to view this.