About this Dataset

California Water Rights Investigations

This list includes detail information for each investigation record as stored in the State Water Resources Control Board's "Electronic Water Rights Information Management System" (EWRIMS) database. Each row is represent the unique investigation record and the associated inspections, enforcement actions, violations, complaints, the "Points of Investigation" (POI) and the associated water right Application ID (unique identifier for a water right). Not all investigations are associated to a water right so there may not be any water right associated to the investigation and one investigation may be associated with multiple points of investigations and multiple water right IDs. This file is in flat file LONG format and does 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.626660
Tags: division-of-water-rights, ewrims, inspections, investigations, points-of-investigation, regulatory, surface-water, violations, water-availability, water-budget, water-markets, water-quantity, water-rights, water-rights-applications, water-rights-enforcement, water-rights-inspections, water-rights-investigations, water-rights-status, water-transfers, water-use

Tables

California Water Rights Investigations

@usgov.ca_gov_california_water_rights_investigations.california_water_rights_investigations

2.53 MB
10,800 rows
159 columns

CREATE TABLE california_water_rights_investigations (
  "investigation_id" BIGINT,
  "investigation_type" VARCHAR,
  "investigation_start_date" TIMESTAMP,
  "investigation_closure_date" TIMESTAMP,
  "num_of_violations" BIGINT,
  "enfor_case_number" VARCHAR,
  "enfocement_action_type" VARCHAR,
  "enfor_case_closure_date" TIMESTAMP,
  "invest_section_or_office" VARCHAR,
  "investigation_sweep" VARCHAR,
  "resource_value_priority" VARCHAR,
  "investigation_summary" VARCHAR,
  "num_comment" DOUBLE,
  "comment_text" VARCHAR,
  "comment_date_added" TIMESTAMP,
  "comment_last_updated_date" VARCHAR,
  "comment_last_updated_user" VARCHAR,
  "investigation_un_app_id" VARCHAR,
  "investigation_last_update_date" VARCHAR,
  "investigation_last_update_user" VARCHAR,
  "num_inspection" DOUBLE,
  "inspection_id_1" DOUBLE,
  "inspection_date_1" VARCHAR,
  "inspection_method_1" VARCHAR,
  "inspection_report_date_1" TIMESTAMP,
  "inspection_notes_1" VARCHAR,
  "inspection_id_2" DOUBLE,
  "inspection_date_2" TIMESTAMP,
  "inspection_method_2" VARCHAR,
  "inspection_report_date_2" TIMESTAMP,
  "inspection_notes_2" VARCHAR,
  "inspection_id_3" DOUBLE,
  "inspection_date_3" TIMESTAMP,
  "inspection_method_3" VARCHAR,
  "inspection_report_date_3" TIMESTAMP,
  "inspection_notes_3" VARCHAR,
  "num_application" DOUBLE,
  "application_id_1" VARCHAR,
  "primary_owner_1" VARCHAR,
  "reason_for_linking_1" VARCHAR,
  "link_source_1" VARCHAR,
  "application_id_2" VARCHAR,
  "primary_owner_2" VARCHAR,
  "reason_for_linking_2" VARCHAR,
  "link_source_2" VARCHAR,
  "application_id_3" VARCHAR,
  "primary_owner_3" VARCHAR,
  "reason_for_linking_3" VARCHAR,
  "link_source_3" VARCHAR,
  "num_violation" BIGINT,
  "violation_id" DOUBLE,
  "violation_type" VARCHAR,
  "violation_discovery_date" TIMESTAMP,
  "violation_summary" VARCHAR,
  "violation_associated_app_id" VARCHAR,
  "num_poi" DOUBLE,
  "poi_id" DOUBLE,
  "poi_county" VARCHAR,
  "poi_source" VARCHAR,
  "poi_tributary_to" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "primary_poi" VARCHAR,
  "enforcement_case_number" VARCHAR,
  "num_enforcement_action" DOUBLE,
  "ea_id_1" DOUBLE,
  "ea_type_1" VARCHAR,
  "ea_start_date_1" TIMESTAMP,
  "ea_closure_date_1" TIMESTAMP,
  "ea_lead_staff_1" VARCHAR,
  "ea_res_div_off_1" VARCHAR,
  "ea_notification_date_1" TIMESTAMP,
  "ea_summary_1" VARCHAR,
  "ea_hearing_req_date_1" TIMESTAMP,
  "ea_set_req_date_1" TIMESTAMP,
  "ea_order_number_1" VARCHAR,
  "ea_order_date_1" TIMESTAMP,
  "ea_order_issued_by_1" VARCHAR,
  "ea_purs_to_settle_ind_1" VARCHAR,
  "ea_reconsider_date_1" TIMESTAMP,
  "ea_reason_for_close_1" VARCHAR,
  "ea_staff_follow_up_1" VARCHAR,
  "ea_initial_proposed_liab_1" DOUBLE,
  "ea_final_acl_amount_1" DOUBLE,
  "ea_acl_amount_collected_1" DOUBLE,
  "ea_last_update_date_1" VARCHAR,
  "ea_last_update_user_1" VARCHAR,
  "ea_id_2" DOUBLE,
  "ea_type_2" VARCHAR,
  "ea_start_date_2" TIMESTAMP,
  "ea_closure_date_2" TIMESTAMP,
  "ea_lead_staff_2" VARCHAR,
  "ea_res_div_off_2" VARCHAR,
  "ea_notification_date_2" TIMESTAMP,
  "ea_summary_2" VARCHAR,
  "ea_hearing_req_date_2" TIMESTAMP,
  "ea_set_req_date_2" TIMESTAMP,
  "ea_order_number_2" VARCHAR,
  "ea_order_date_2" TIMESTAMP,
  "ea_order_issued_by_2" VARCHAR
);