About this Dataset

California Water Rights Points Of Diversion LIST (Detail Summary List)

This list includes detail information about every Point of Diversion water rights record in the State Water Resources Control Board's "Electronic Water Rights Information Management System" (EWRIMS) database. A Point of Diversion is the geographic area from which water is diverted using infrastructure (works) and put to beneficial use. Examples of works include water storage dams, diversion dams, dugouts, and pump sites along a surface water source. Each row correspond with a unique Point of Diversion ID 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 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. That information may be available in the associated flat files for each category.
Organization: State of California
Last updated: 2024-03-30T02:21:29.522289
Tags: division-of-water-rights, ewrims, points-of-diversion, regulatory, surface-water, water-availability, water-budget, water-markets, water-quantity, water-rights, water-rights-applications, water-transfers

Tables

California Water Rights Points Of Diversion LIST (Detail Summary List)

@usgov.ca_gov_california_water_rights_points_of_diversion_lis_62f650ab.california_water_rights_points_of_diversion_list_detai_810a37eb

10.71 MB
65902 rows
171 columns


CREATE TABLE california_water_rights_points_of_diversion_list_detai_810a37eb (
  "pod_id" BIGINT,
  "pod_number" DOUBLE,
  "pod_status" VARCHAR,
  "source_type" VARCHAR,
  "pod_name" VARCHAR,
  "pod_type" VARCHAR,
  "diversion_works_status" VARCHAR,
  "stream_classification" VARCHAR,
  "direct_div_amount" DOUBLE,
  "direct_diversion_rate" DOUBLE,
  "direct_div_rate_unit" VARCHAR,
  "storage_amount" DOUBLE,
  "diversion_rate_to_off_stream" DOUBLE,
  "off_sto_div_rate_unit" VARCHAR,
  "pod_last_update_date" VARCHAR,
  "pod_count" BIGINT,
  "appl_id" VARCHAR,
  "objectid" DOUBLE,
  "pod_number_gis" DOUBLE,
  "has_opod" VARCHAR,
  "appl_pod" VARCHAR,
  "pod_id_gis" BIGINT,
  "county" VARCHAR,
  "parcel_number" VARCHAR,
  "sp_zone" DOUBLE,
  "diversion_site_name" VARCHAR,
  "north_coord" DOUBLE,
  "east_coord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "quarter_quarter" VARCHAR,
  "quarter" VARCHAR,
  "section_classifier" VARCHAR,
  "section_number" DOUBLE,
  "township_number" DOUBLE,
  "township_direction" VARCHAR,
  "range_number" DOUBLE,
  "range_direction" VARCHAR,
  "meridian" VARCHAR,
  "location_method" VARCHAR,
  "special_use_area" VARCHAR,
  "source_name" VARCHAR,
  "trib_desc" VARCHAR,
  "watershed" VARCHAR,
  "huc_12_number" DOUBLE,
  "huc_12_name" VARCHAR,
  "huc_8_number" DOUBLE,
  "huc_8_name" VARCHAR,
  "quad_map_name" VARCHAR,
  "quad_map_number" 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,
  "application_number_party" VARCHAR,
  "pwss_id" DOUBLE,
  "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" 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_due" DOUBLE,
  "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
);