About this Dataset

California Water Rights Inspections

This list includes detail information for each inspection 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 inspection record and the associated investigation, the "Points of Investigation" (POI) and the associated water right Application ID (unique identifier for a water right). An inpection record may or not may be associated to a specific water right ID and one inspection 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:40.877587
Tags: division-of-water-rights, ewrims, inspections, points-of-investigation, regulatory, surface-water, 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 Inspections

@usgov.ca_gov_california_water_rights_inspections.california_water_rights_inspections

1.49 MB
8,485 rows
45 columns

CREATE TABLE california_water_rights_inspections (
  "inspection_id" BIGINT,
  "inspection_date" VARCHAR,
  "inspection_method" VARCHAR,
  "inspection_report_date" TIMESTAMP,
  "inspection_notes" VARCHAR,
  "num_inspection" BIGINT,
  "num_poi" DOUBLE,
  "poi_id_1" DOUBLE,
  "poi_county_1" VARCHAR,
  "poi_source_1" VARCHAR,
  "poi_tributary_to_1" VARCHAR,
  "poi_latitude_1" DOUBLE,
  "poi_longitude_1" DOUBLE,
  "poi_description_1" VARCHAR,
  "primary_poi_1" VARCHAR,
  "poi_id_2" DOUBLE,
  "poi_county_2" VARCHAR,
  "poi_source_2" VARCHAR,
  "poi_tributary_to_2" VARCHAR,
  "poi_latitude_2" DOUBLE,
  "poi_longitude_2" DOUBLE,
  "poi_description_2" VARCHAR,
  "primary_poi_2" VARCHAR,
  "poi_id_3" DOUBLE,
  "poi_county_3" VARCHAR,
  "poi_source_3" VARCHAR,
  "poi_tributary_to_3" VARCHAR,
  "poi_latitude_3" DOUBLE,
  "poi_longitude_3" DOUBLE,
  "poi_description_3" VARCHAR,
  "primary_poi_3" VARCHAR,
  "investigation_id" BIGINT,
  "investigation_type" VARCHAR,
  "investigation_start_date" TIMESTAMP,
  "investigation_closure_date" TIMESTAMP,
  "num_of_violations" BIGINT,
  "enf_case_number" VARCHAR,
  "enfocement_action_type" VARCHAR,
  "enf_case_closure_date" TIMESTAMP,
  "investigation_lead_staff" VARCHAR,
  "invest_section_or_office" VARCHAR,
  "investigation_sweep" VARCHAR,
  "resource_value_priority" VARCHAR,
  "investigation_summary" VARCHAR,
  "associated_wr_to_inv" VARCHAR
);