California Water Rights Violations by US Government | Environmental and Climate Sciences

About this Dataset

California Water Rights Violations

This list includes detail information for each violation 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 violation record and the associated investigations 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:26.032379
Tags: ewrims, failure-to-file-initial-or-supp-statement, failure-to-pay-fees, failure-to-submit-monitoring-report-or-studies, insufficient-documentation-of-right, investigations, misuse-of-water, non-use-of-water, points-of-investigation, public-trust-impact, term-91-violation, term-93-violation, threat-of-unauthorized-diversion, unauthorized-storage, violation-of-permit-or-license-term, violation-of-place-of-use, water-markets, water-rights, water-rights-enforcement, water-rights-investigations, water-rights-violations, water-transfers, water-use-curtailment

Tables

California Water Rights Violations

@usgov.ca_gov_california_water_rights_violations.california_water_rights_violations

408.18 KB
5730 rows
39 columns


CREATE TABLE california_water_rights_violations (
  "violation_id" BIGINT,
  "violation_type" VARCHAR,
  "county_primary_poi" VARCHAR,
  "source_primary_poi" VARCHAR,
  "tributary_primary_poi" VARCHAR,
  "discovery_date" TIMESTAMP,
  "violation_summary" VARCHAR,
  "last_updated_date" VARCHAR,
  "last_update_user" VARCHAR,
  "investigation_id" BIGINT,
  "investigation_type" VARCHAR,
  "investigation_start_date" TIMESTAMP,
  "investigation_closure_date" TIMESTAMP,
  "num_enf_action_ass_inv" DOUBLE,
  "case_number" VARCHAR,
  "case_start_date" TIMESTAMP,
  "case_clossure_date" TIMESTAMP,
  "enf_action_type" VARCHAR,
  "cid_number" DOUBLE,
  "field_insp" BIGINT,
  "office_insp" BIGINT,
  "num_app_ass_violation" DOUBLE,
  "app_number" VARCHAR,
  "primary_owner" VARCHAR,
  "un_party_name" VARCHAR,
  "lead_staff" VARCHAR,
  "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
);