About this Dataset

California Water Rights Status History

This list includes detail information for the Status History of each water right as stored in the State Water Resources Control Board's "Electronic Water Rights Information Management System" (EWRIMS) database. Each row is a unique combination of the water right Application ID (unique identifier for a water right) and status combination. It shows the the status of the application ID at the associated effective date. For example, an application id can have a status of "Permited" on 01/01/2001 and a status of "Licensed" as 01/01/2002, there would be two rows on the dataset with the same application id with different status. 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 the information associated to a water right such all uses and seasons. Other information may be available in the associated flat files for each category.
Organization: State of California
Last updated: 2021-11-19T09:24:41.281054
Tags: division-of-water-rights, ewrims, regulatory, surface-water, water-availability, water-budget, water-markets, water-quantity, water-rights, water-rights-applications, water-rights-status, water-transfers, water-use

Tables

California Water Rights Status History

@usgov.ca_gov_california_water_rights_status_history.california_water_rights_status_history

11.61 MB
82,869 rows
165 columns

CREATE TABLE california_water_rights_status_history (
  "wr_water_right_id" BIGINT,
  "status_at_status_effectivedate" VARCHAR,
  "status_effective_date" VARCHAR,
  "status_update_datetime" VARCHAR,
  "status_update_user" VARCHAR,
  "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" TIMESTAMP,
  "application_recd_date" VARCHAR,
  "application_acceptance_date" VARCHAR,
  "project_type" VARCHAR,
  "record_summary" VARCHAR,
  "incomplete_statement" VARCHAR,
  "number_of_protests" DOUBLE,
  "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" DOUBLE,
  "effective_from_date" TIMESTAMP,
  "effective_to_date" TIMESTAMP,
  "last_name_or_company_name" VARCHAR,
  "middle_name" VARCHAR,
  "first_name" VARCHAR,
  "primary_owner_name" VARCHAR,
  "official_mail_receiver" VARCHAR,
  "count_npo_or_other" BIGINT,
  "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,
  "pod_type" VARCHAR,
  "diversion_works_status" VARCHAR,
  "stream_classification" VARCHAR
);