California Water Rights Violations
State of California
@usgov.ca_gov_california_water_rights_violations
State of California
@usgov.ca_gov_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
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
);
Anyone who has the link will be able to view this.