About this Dataset

California Water Rights Enforcement Actions

This list includes detail information for each enforcement action 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 enforcement action record and the associated investigation, number of violations, complaints, the "Points of Investigation" (POI) and the associated water rights Application ID (unique identifier for a water right). Not all enforcement actions are associated to a water right so there may not be any water right associated to the enforcement action and one enforcement action may be associated with 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. https://ciwqs.waterboards.ca.gov//ciwqs/ewrims/EWMenuPublic.jsp https://www.waterboards.ca.gov/waterrights/water_issues/programs/enforcement/
Organization: State of California
Last updated: 2021-11-19T09:24:25.917779
Tags: division-of-water-rights, enforcement, ewrims, investigations, points-of-investigation, regulatory, surface-water, violations, water-availability, water-quantity, water-rights, water-rights-applications, water-rights-enforcement, water-rights-investigations, water-use

Tables

California Water Rights Enforcement Actions

@usgov.ca_gov_california_water_rights_enforcement_actions.california_water_rights_enforcement_actions

240.71 kB
3,553 rows
44 columns

CREATE TABLE california_water_rights_enforcement_actions (
  "ea_id" BIGINT,
  "ea_case_number" VARCHAR,
  "investigation_id" BIGINT,
  "investigation_type" VARCHAR,
  "investigation_start_date" TIMESTAMP,
  "investigation_closure_date" TIMESTAMP,
  "num_violation_investigation" DOUBLE,
  "num_application_ea" DOUBLE,
  "application_linked_ea" VARCHAR,
  "primary_owners" VARCHAR,
  "un_responsible_party" VARCHAR,
  "county_primary_poi" VARCHAR,
  "source_primary_poi" VARCHAR,
  "tributary_primary_poi" VARCHAR,
  "enforcement_action_type" VARCHAR,
  "ea_start_date" TIMESTAMP,
  "ea_closure_date" TIMESTAMP,
  "ea_reason_for_close" VARCHAR,
  "ea_lead_staff" VARCHAR,
  "ea_response_division_office" VARCHAR,
  "ea_notification_date" TIMESTAMP,
  "ea_hearing_req_date" TIMESTAMP,
  "ea_order_number" VARCHAR,
  "ea_order_date" TIMESTAMP,
  "ea_order_issued_by" VARCHAR,
  "ea_pursuant_to_settlement" VARCHAR,
  "ea_staff_follow_up" VARCHAR,
  "ea_initial_proposed_liability" DOUBLE,
  "ea_final_acl_amount" DOUBLE,
  "ea_acl_amount_collected" DOUBLE,
  "total_wrs" BIGINT,
  "apps_filed_after" BIGINT,
  "apps_pending_at" BIGINT,
  "apps_perm_at" BIGINT,
  "apps_lic_at" BIGINT,
  "regs_filed_after" BIGINT,
  "regs_pending_at" BIGINT,
  "regs_regs_at" BIGINT,
  "stmt_sub_after" BIGINT,
  "stmt_active_at" BIGINT,
  "unknown_all" BIGINT,
  "nonj_active_before" BIGINT,
  "nonj_active_after" BIGINT,
  "all_other" BIGINT
);