About this Dataset

Dry Well Reporting System Data

In California, water systems serving one (1) to 15 households are regulated at the county level. Counties vary in their practices, but rarely do counties collect data regularly from these systems. Even where data is collected, it is entirely voluntary. A review of well permit information suggests there are over 1 million such water systems in California.

In early 2014, a cross-agency Work Group created an easily accessible reporting system to get more systematic data on which parts of the state had households at risk of water supply shortages. The initial motivation for local water supply systems to report shortage information was to obtain statewide drought assistance. The reporting system receives ongoing reports of shortages from local, state, federal and non-governmental organizations, and tracks their status to resolution. While several counties have developed their own tracking mechanisms, this data is manually entered into the reporting system.

The cross-agency team, led by DWR, seeks to verify and update the data submitted. However, due to the volunteer nature of the reporting and limitations on reporting agencies, collected data are undoubtedly under-representative of all shortages to have occurred. In addition, reports are received from multiple sources and there are occasionally errors and omissions that can create duplicate entries, non-household water supply reporting, and under-reporting. For example, missing information or no data for a given county does not necessarily mean that there are no household water shortages in the county, rather only that none have been reported to the State.
Organization: State of California
Last updated: 2023-08-25T21:11:00.140761
Tags: california-department-of-water-resources, dry-wells, water-supply-shortage

Tables

Data Dictionary - Dry Well Reports

@usgov.ca_gov_dry_well_reporting_system_data_3dc42.data_dictionary_dry_well_reports

5.4 KB
22 rows
4 columns


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

Dry Well Reports

@usgov.ca_gov_dry_well_reporting_system_data_3dc42.dry_well_reports

321.36 KB
5964 rows
22 columns


CREATE TABLE dry_well_reports (
  "id" BIGINT,
  "create_date" TIMESTAMP,
  "status" VARCHAR,
  "shortage_type" VARCHAR,
  "primary_usages" VARCHAR,
  "household_support" VARCHAR,
  "water_issues" VARCHAR,
  "approximate_issue_start_date" VARCHAR,
  "county" VARCHAR,
  "city" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "well_depth" VARCHAR,
  "was_issue_resolved" VARCHAR,
  "approximate_repair_cost" VARCHAR,
  "additional_info" VARCHAR,
  "well_to_water_depth" VARCHAR,
  "measure_date" VARCHAR,
  "pump_rate_reduction" VARCHAR,
  "report_date" TIMESTAMP,
  "statustype" VARCHAR,
  "region" VARCHAR
);