About this Dataset

Drinking Water - Public Water System Information

The is a curated dataset of information for all public water systems (PWS) in California, including the name, location and some general informaiton for each PWS. The source of the data https://sdwis.waterboards.ca.gov/PDWW/ is a public web portal to view public water systems (PWS) location, facilities, sources, and samples.
Organization: State of California
Last updated: 2024-11-26T22:46:53.453344
Tags: drinking-water, operations, public-water-system, water-supply, well-locations

Tables

Drinking Water Watch - Public Water System Facilities

@usgov.ca_gov_drinking_water_public_water_system_information.drinking_water_watch_public_water_system_facilities

414.95 kB
7,815 rows
35 columns

CREATE TABLE drinking_water_watch_public_water_system_facilities (
  "fob" VARCHAR,
  "region" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_no" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "principal_county_served_state" VARCHAR  -- Principal County Served, State,
  "federal_water_system_type_code" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type_code" VARCHAR,
  "state_water_system_type" VARCHAR,
  "water_system_status_code" VARCHAR,
  "system_status" VARCHAR,
  "owner_type_code" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type_code" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population" VARCHAR,
  "non_transient_population" VARCHAR,
  "transient_population" VARCHAR,
  "total_population" VARCHAR,
  "number_of_agricultural_service_connections_ag" VARCHAR  -- Number Of Agricultural Service Connections (AG),
  "number_of_combined_service_connections_cb" VARCHAR  -- Number Of Combined Service Connections (CB),
  "number_of_commercial_service_connections_cm" VARCHAR  -- Number Of Commercial Service Connections (CM),
  "number_of_institutional_service_connections_in" VARCHAR  -- Number Of Institutional Service Connections (IN),
  "number_of_residential_service_connections_rs" VARCHAR  -- Number Of Residential Service Connections (RS),
  "total_number_of_service_connections" VARCHAR,
  "fee_code" VARCHAR,
  "fee_code_description" VARCHAR,
  "date_of_sanitary_survey_visit_snsv_visit_date" VARCHAR  -- Date Of Sanitary Survey Visit (SNSV Visit Date),
  "city" VARCHAR,
  "treatment_plant_class_code" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class_code" VARCHAR,
  "distribution_system_class" VARCHAR
);