Baselight

California Water Rights Measurement Devices (Reported In Annual Report)

State of California

@usgov.ca_gov_california_water_rights_measurement_devices_rep_4d57d630

Loading...
Loading...

About this Dataset

California Water Rights Measurement Devices (Reported In Annual Report)

This list includes detail information about the measurement devices and measurement methods associated with the diversion and storage of water as reported annually for water rights as stored in the State Water Resources Control Board's "Electronic Water Rights Information Management System" (EWRIMS) database. All water right holders are required to submit an annual report including information related to the measurement devices and measurement methods associated with the diversion or storage of water. Each row correspond with a unique annual report-water right id-and measurement device ID combination and its associated data. This file is in flat file format and may not include all information associated to a water right such all uses and seasons or the amounts reported used for every month. Other information may be available in the associated flat files for each category. Examples of annual reports templates are provided as supporting information.
Organization: State of California
Last updated: 2021-11-19T09:24:24.937405
Tags: annual-report, division-of-water-rights, ewrims, measurement-devices, regulatory, surface-water, telemetry, water-availability, water-budget, water-diversion, water-markets, water-quantity, water-rights, water-rights-applications, water-transfers, water-use, water-use-measurement

Tables

California Water Rights Measurement Devices (Reported In Annual Report)

@usgov.ca_gov_california_water_rights_measurement_devices_rep_4d57d630.california_water_rights_measurement_devices_reported_i_3a3abf70
  • 5.2 MB
  • 60727 rows
  • 55 columns
Loading...

CREATE TABLE california_water_rights_measurement_devices_reported_i_3a3abf70 (
  "report_year" BIGINT,
  "revision" BIGINT,
  "revision_attribute" VARCHAR,
  "report_system_unique_id" BIGINT,
  "primary_owner" VARCHAR,
  "primary_contact" VARCHAR,
  "date_submitted" TIMESTAMP,
  "application_number" VARCHAR,
  "certificate_id" DOUBLE,
  "permit_id" DOUBLE,
  "license_id" DOUBLE,
  "water_right_type" VARCHAR,
  "water_right_status" VARCHAR,
  "report_type" VARCHAR,
  "source_of_water" VARCHAR,
  "county" VARCHAR,
  "max_direct_diversion_rate" DOUBLE,
  "max_direct_diversion_rate_unit" VARCHAR,
  "max_collection_to_storage" DOUBLE,
  "max_collection_to_storage_unit" VARCHAR,
  "face_value" DOUBLE,
  "face_value_unit" VARCHAR,
  "dev_brief_desc" VARCHAR,
  "measuring_device_record_id" BIGINT,
  "measuring_device_id" VARCHAR,
  "device_nickname" VARCHAR,
  "measuring_device_use" VARCHAR,
  "num_of_device" BIGINT,
  "device_type" VARCHAR,
  "device_make" VARCHAR,
  "device_serial_number" VARCHAR,
  "device_model_number" VARCHAR,
  "device_install_date" VARCHAR,
  "additional_info" VARCHAR,
  "last_calibrated_date" VARCHAR,
  "estimated_accuracy" VARCHAR,
  "calibration_method" VARCHAR,
  "maintenance_schedule" VARCHAR,
  "calibration_person_name" VARCHAR,
  "calibration_person_phone" VARCHAR,
  "calibration_person_email" VARCHAR,
  "calibration_person_qual" VARCHAR,
  "calibration_person_license" VARCHAR,
  "type_of_recorder_method" VARCHAR,
  "recorder_make" VARCHAR,
  "recorder_serial_number" VARCHAR,
  "recorder_model_number" VARCHAR,
  "recorder_uom" VARCHAR,
  "frequency_data_recording" VARCHAR,
  "recorder_additional_info" VARCHAR,
  "telemetry_required" VARCHAR,
  "telemetry_website" VARCHAR,
  "volume_method_attached" VARCHAR,
  "attached_document" VARCHAR,
  "number_attachment" DOUBLE
);

Share link

Anyone who has the link will be able to view this.