California Water Rights Measurement Devices (Reported In Annual Report)
State of California
@usgov.ca_gov_california_water_rights_measurement_devices_rep_4d57d630
State of California
@usgov.ca_gov_california_water_rights_measurement_devices_rep_4d57d630
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
);
Anyone who has the link will be able to view this.