About this Dataset

Ground Water - Water Quality Regulatory Information

GeoTracker is the Water Boards' data management system for sites that impact, or have the potential to impact, water quality in California, with emphasis on groundwater. GeoTracker contains records for sites that require cleanup, such as Leaking Underground Storage Tank (LUST) Sites, Department of Defense Sites, and Cleanup Program Sites. GeoTracker also contains records for permitted facilities such as Irrigated Lands, Oil and Gas production, operating Permitted UST's, and Land Disposal Sites.
Organization: State of California
Last updated: 2025-09-23T12:45:55.242592
Tags: cleanup, department-of-defense, gas, groundwater, irrigated-lands, landfill, lust, oil, oil-and-gas-production, underground-storage-tank, ust

Tables

GeoTracker Sites

@usgov.ca_gov_ground_water_water_quality_regulatory_information.geotracker_sites

22.18 MB
75,688 rows
47 columns

CREATE TABLE geotracker_sites (
  "global_id" VARCHAR,
  "business_name" VARCHAR,
  "street_number" VARCHAR,
  "street_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "county" VARCHAR,
  "epa_region" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "coordinate_source" VARCHAR,
  "case_type" VARCHAR,
  "status" VARCHAR,
  "status_date" VARCHAR,
  "claim_no" VARCHAR,
  "claim_status" VARCHAR,
  "lead_agency" VARCHAR,
  "caseworker" VARCHAR,
  "local_agency" VARCHAR,
  "rb_case_number" VARCHAR,
  "loc_case_number" VARCHAR,
  "file_location" VARCHAR,
  "potential_contaminants_of_concern" VARCHAR,
  "quantity_released_gallons" VARCHAR,
  "potential_media_of_concern" VARCHAR,
  "site_history" VARCHAR,
  "begin_date" TIMESTAMP,
  "leak_reported_date" TIMESTAMP,
  "how_discovered" VARCHAR,
  "how_discovered_description" VARCHAR,
  "discharge_source" VARCHAR,
  "discharge_cause" VARCHAR,
  "stop_method" VARCHAR,
  "stop_description" VARCHAR,
  "no_further_action_date" TIMESTAMP,
  "calwater_watershed_name" VARCHAR,
  "dwr_groundwater_subbasin_name" VARCHAR,
  "disadvantaged_community" VARCHAR,
  "calenviroscreen3_score" VARCHAR,
  "calenviroscreen4_score" VARCHAR,
  "military_dod_site" VARCHAR,
  "facility_project_subtype" VARCHAR,
  "rwqcb_region" VARCHAR,
  "n_2022_assembly_district" VARCHAR  -- 2022 ASSEMBLY DISTRICT,
  "n_2022_senate_district" VARCHAR  -- 2022 SENATE DISTRICT,
  "n_2022_congressional_district" VARCHAR  -- 2022 CONGRESSIONAL DISTRICT
);