Baselight

California Water Rights Irrigation Use Annual Reports

State of California

@usgov.ca_gov_california_water_rights_irrigation_use_annual_r_615177f8

Loading...
Loading...

About this Dataset

California Water Rights Irrigation Use Annual Reports

This list includes detail information for IRRIGATION 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 annual Irrigation water use by crop type (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 for irrigation. Each row correspond with a unique annual report-water right id and crop combination and its associated data. Each crop type includes total water use, multiple crops, area irrigated and primary irrigation method. 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 format and may not include all information associated to a water right such all uses and seasons or the amounts reported used for every month. Other information may be available in the associated flat files for each category. Examples of annual reports templates are provided as supporting information.
Organization: State of California
Last updated: 2021-11-07T01:58:17.047723
Tags: annual-report, crop-types, division-of-water-rights, ewrims, irrigation, regulatory, surface-water, water-availability, water-budget, water-diversion, water-markets, water-quantity, water-rights, water-rights-applications, water-transfers, water-use

Tables

California Water Rights Irrigation Water Use Annual Reports

@usgov.ca_gov_california_water_rights_irrigation_use_annual_r_615177f8.california_water_rights_irrigation_water_use_annual_reports
  • 14.86 MB
  • 590,556 rows
  • 30 columns
Loading...
CREATE TABLE california_water_rights_irrigation_water_use_annual_reports (
  "report_year" BIGINT,
  "revision" BIGINT,
  "revision_attribute" VARCHAR,
  "report_system_unique_id" BIGINT,
  "primary_owner" VARCHAR,
  "primary_contact" VARCHAR,
  "date_submitted" TIMESTAMP,
  "application_number" VARCHAR,
  "certificate_id" VARCHAR,
  "permit_id" VARCHAR,
  "license_id" VARCHAR,
  "water_right_type" VARCHAR,
  "water_right_status" VARCHAR,
  "source_of_water" VARCHAR,
  "pod_parcel_number" VARCHAR,
  "county" VARCHAR,
  "max_direct_diversion_rate" DOUBLE,
  "max_direct_diversion_rate_unit" VARCHAR,
  "max_collection_to_storage" DOUBLE,
  "max_collection_to_storage_unit" VARCHAR,
  "face_value" DOUBLE,
  "face_value_unit" VARCHAR,
  "not_used_under_wr" VARCHAR,
  "irrigation" VARCHAR,
  "crop_type" VARCHAR,
  "multiple_crops" VARCHAR,
  "area_irrigated" DOUBLE,
  "primary_irrig_method" VARCHAR,
  "total_acres_irrigated" DOUBLE,
  "total_crops" DOUBLE
);

Share link

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