Dataset: California Water Rights Water Use Reported

About this Dataset

California Water Rights Water Use Reported

This list includes detail information for WATER USE as reported annually under each water right as stored in the State Water Resources Control Board's "Electronic Water Rights Information Management System" (EWRIMS) database. All water right holders are required to submit an online report of water diversion and use detailing their monthly water diversion, storage and use (even if no water was diverted or used during the period). The information is required pursuant to Title 23, Sections 847 and 925, of the California Code of Regulations. The annual report contains information about the water diversion and use. Each row correspond with a unique annual report-water right id, month and diversion type combination and its associated data. The list include basic summary information about the Water Right record, such as the type and status, the location of the Points of Diversion, the amount of water allowed (Face Value), and summary data associated with the electronic Water Right record. This file is in flat file LONG format and may not include all information associated to a water right such all uses and seasons. The information associated with crop irrigation is not included in this list but is included on a separate file. Other information may be available in the associated flat files for each category. Examples of annual reports templates are provided as supporting information. The dataset is also available in "Wide Format" by reporting year using the eWRIMS public report system here https://ciwqs.waterboards.ca.gov//ciwqs/ewrims/reportingDiversionDownloadPublicSetup.do
Organization: State of California
Last updated: 2021-11-13T09:58:06.687837
Tags: annual-report, direct-diversion, division-of-water-rights, ewrims, regulatory, surface-water, water-availability, water-budget, water-diversion, water-markets, water-quantity, water-rights, water-rights-applications, water-storage, water-transfers, water-use

Tables

California Water Rights Water Use Reported (1914 To 2015)

@usgov.ca_gov_california_water_rights_water_use_reported_df8b0.california_water_rights_water_use_reported_1914_to_2015

27.25 MB
4684956 rows
168 columns


CREATE TABLE california_water_rights_water_use_reported_1914_to_2015 (
  "month_name" VARCHAR,
  "month_formatted" TIMESTAMP,
  "water_right_id" BIGINT,
  "appl_id" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "amount" DOUBLE,
  "diversion_type" VARCHAR,
  "wr_water_right_id" BIGINT,
  "application_number" VARCHAR,
  "certificate_id" DOUBLE,
  "permit_id" DOUBLE,
  "license_id" DOUBLE,
  "water_right_type" VARCHAR,
  "water_right_status" VARCHAR,
  "priority_date" TIMESTAMP,
  "receipt_date" VARCHAR,
  "rejection_date" VARCHAR,
  "application_recd_date" VARCHAR,
  "application_acceptance_date" TIMESTAMP,
  "project_type" VARCHAR,
  "record_summary" VARCHAR,
  "incomplete_statement" VARCHAR,
  "number_of_protests" BIGINT,
  "agent_name" VARCHAR,
  "agent_entity_type" VARCHAR,
  "application_primary_owner" VARCHAR,
  "primary_owner_entity_type" VARCHAR,
  "sub_type" VARCHAR,
  "ini_reported_div_amount" DOUBLE,
  "ini_reported_div_unit" VARCHAR,
  "face_value_amount" DOUBLE,
  "face_value_units" VARCHAR,
  "fee_received" DOUBLE,
  "appl_fee_amount" DOUBLE,
  "appl_fee_amt_recd" DOUBLE,
  "max_dd_appl" DOUBLE,
  "max_dd_units" VARCHAR,
  "max_dd_ann" DOUBLE,
  "max_storage" DOUBLE,
  "max_taken_from_source" DOUBLE,
  "year_diversion_commenced" DOUBLE,
  "max_beneficially_used" DOUBLE,
  "supplemental_statement_cycle" VARCHAR,
  "type_of_diversion_facility" VARCHAR,
  "quantity_of_water_diverted" DOUBLE,
  "qow_diverted_unit" VARCHAR,
  "quantity_measurement_year" DOUBLE,
  "max_rate_of_diversion" DOUBLE,
  "max_rate_of_div_unit" VARCHAR,
  "recent_water_use_min" DOUBLE,
  "water_use_min_unit" VARCHAR,
  "recent_water_use_max" DOUBLE,
  "water_use_max_unit" VARCHAR,
  "request_for_revocation_recd" VARCHAR,
  "state_well_number" VARCHAR,
  "drilled_well_year" DOUBLE,
  "surface_water_diversions" VARCHAR,
  "depth_of_well" DOUBLE,
  "relationship_type" VARCHAR,
  "party_id" BIGINT,
  "effective_from_date" TIMESTAMP,
  "effective_to_date" TIMESTAMP,
  "primary_owner_name" VARCHAR,
  "official_mail_receiver" VARCHAR,
  "count_npo_or_other" BIGINT,
  "effective_date" VARCHAR,
  "update_datetime" VARCHAR,
  "use_code" VARCHAR,
  "use_status" VARCHAR,
  "number_of_residences" DOUBLE,
  "seperately_owned" VARCHAR,
  "use_population" DOUBLE,
  "use_population_people" DOUBLE,
  "estimated_use_per_person" DOUBLE,
  "use_population_stock" DOUBLE,
  "type_of_stock" VARCHAR,
  "area_for_inci_irrigation" DOUBLE,
  "use_net_acreage" DOUBLE,
  "use_gross_acreage" DOUBLE,
  "use_direct_div_annual_amount" DOUBLE,
  "use_direct_diversion_rate" DOUBLE,
  "use_direct_div_rate_units" VARCHAR,
  "pou_development_status" VARCHAR,
  "direct_div_season_start" VARCHAR,
  "direct_div_season_end" VARCHAR,
  "use_storage_amount" DOUBLE,
  "storage_season_start" VARCHAR,
  "storage_season_end" VARCHAR,
  "season_direct_div_rate" DOUBLE,
  "season_storage_amount" DOUBLE,
  "season_direct_div_aa" DOUBLE,
  "direct_div_season_status" VARCHAR,
  "collection_season_status" VARCHAR,
  "use_count" BIGINT,
  "pod_number" DOUBLE,
  "pod_id" DOUBLE,
  "pod_status" VARCHAR,
  "source_type" VARCHAR,
  "pod_name" VARCHAR
);

California Water Rights Water Use Reported 2016-2018

@usgov.ca_gov_california_water_rights_water_use_reported_df8b0.california_water_rights_water_use_reported_2016_2018

12.22 MB
2047992 rows
168 columns


CREATE TABLE california_water_rights_water_use_reported_2016_2018 (
  "month_name" VARCHAR,
  "month_formatted" TIMESTAMP,
  "water_right_id" BIGINT,
  "appl_id" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "amount" DOUBLE,
  "diversion_type" VARCHAR,
  "wr_water_right_id" BIGINT,
  "application_number" VARCHAR,
  "certificate_id" DOUBLE,
  "permit_id" DOUBLE,
  "license_id" DOUBLE,
  "water_right_type" VARCHAR,
  "water_right_status" VARCHAR,
  "priority_date" TIMESTAMP,
  "receipt_date" TIMESTAMP,
  "rejection_date" VARCHAR,
  "application_recd_date" TIMESTAMP,
  "application_acceptance_date" TIMESTAMP,
  "project_type" VARCHAR,
  "record_summary" VARCHAR,
  "incomplete_statement" VARCHAR,
  "number_of_protests" BIGINT,
  "agent_name" VARCHAR,
  "agent_entity_type" VARCHAR,
  "application_primary_owner" VARCHAR,
  "primary_owner_entity_type" VARCHAR,
  "sub_type" VARCHAR,
  "ini_reported_div_amount" VARCHAR,
  "ini_reported_div_unit" VARCHAR,
  "face_value_amount" DOUBLE,
  "face_value_units" VARCHAR,
  "fee_received" DOUBLE,
  "appl_fee_amount" DOUBLE,
  "appl_fee_amt_recd" DOUBLE,
  "max_dd_appl" DOUBLE,
  "max_dd_units" VARCHAR,
  "max_dd_ann" DOUBLE,
  "max_storage" DOUBLE,
  "max_taken_from_source" DOUBLE,
  "year_diversion_commenced" DOUBLE,
  "max_beneficially_used" DOUBLE,
  "supplemental_statement_cycle" VARCHAR,
  "type_of_diversion_facility" VARCHAR,
  "quantity_of_water_diverted" VARCHAR,
  "qow_diverted_unit" VARCHAR,
  "quantity_measurement_year" VARCHAR,
  "max_rate_of_diversion" VARCHAR,
  "max_rate_of_div_unit" VARCHAR,
  "recent_water_use_min" VARCHAR,
  "water_use_min_unit" VARCHAR,
  "recent_water_use_max" VARCHAR,
  "water_use_max_unit" VARCHAR,
  "request_for_revocation_recd" VARCHAR,
  "state_well_number" VARCHAR,
  "drilled_well_year" DOUBLE,
  "surface_water_diversions" VARCHAR,
  "depth_of_well" DOUBLE,
  "relationship_type" VARCHAR,
  "party_id" BIGINT,
  "effective_from_date" TIMESTAMP,
  "effective_to_date" TIMESTAMP,
  "primary_owner_name" VARCHAR,
  "official_mail_receiver" VARCHAR,
  "count_npo_or_other" BIGINT,
  "effective_date" TIMESTAMP,
  "update_datetime" VARCHAR,
  "use_code" VARCHAR,
  "use_status" VARCHAR,
  "number_of_residences" DOUBLE,
  "seperately_owned" VARCHAR,
  "use_population" DOUBLE,
  "use_population_people" DOUBLE,
  "estimated_use_per_person" DOUBLE,
  "use_population_stock" DOUBLE,
  "type_of_stock" VARCHAR,
  "area_for_inci_irrigation" VARCHAR,
  "use_net_acreage" DOUBLE,
  "use_gross_acreage" DOUBLE,
  "use_direct_div_annual_amount" DOUBLE,
  "use_direct_diversion_rate" DOUBLE,
  "use_direct_div_rate_units" VARCHAR,
  "pou_development_status" VARCHAR,
  "direct_div_season_start" VARCHAR,
  "direct_div_season_end" VARCHAR,
  "use_storage_amount" DOUBLE,
  "storage_season_start" VARCHAR,
  "storage_season_end" VARCHAR,
  "season_direct_div_rate" DOUBLE,
  "season_storage_amount" DOUBLE,
  "season_direct_div_aa" DOUBLE,
  "direct_div_season_status" VARCHAR,
  "collection_season_status" VARCHAR,
  "use_count" BIGINT,
  "pod_number" DOUBLE,
  "pod_id" BIGINT,
  "pod_status" VARCHAR,
  "source_type" VARCHAR,
  "pod_name" VARCHAR
);

California Water Rights Water Used Reported (Simple Version)

@usgov.ca_gov_california_water_rights_water_use_reported_df8b0.california_water_rights_water_used_reported_simple_version

25.1 MB
13651476 rows
8 columns


CREATE TABLE california_water_rights_water_used_reported_simple_version (
  "month_name" VARCHAR,
  "month_formatted" TIMESTAMP,
  "water_right_id" BIGINT,
  "appl_id" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "amount" DOUBLE,
  "diversion_type" VARCHAR
);