Cooperative Automated Research Mobility Applications (CARMA) 2
Department of Transportation
@usgov.dot_gov_cooperative_automated_research_mobility_applic_7b548596
Department of Transportation
@usgov.dot_gov_cooperative_automated_research_mobility_applic_7b548596
CREATE TABLE table_1 (
"locationdatetime" VARCHAR,
"runno" BIGINT,
"elapsed_time" DOUBLE,
"veh_color_black" VARCHAR,
"bin_utc_time_s_black" DOUBLE,
"throttle_ovr_flag_black" DOUBLE,
"max_accel_cacc_black" DOUBLE,
"command_mode_cacc_black" DOUBLE,
"speed_command_cacc_black" DOUBLE,
"override_enabled_cacc_black" DOUBLE,
"accelerator_pedal_override_active_black" DOUBLE,
"vehspdavgdrvn_srx_black" DOUBLE,
"flrrtrk1range_srx_black" DOUBLE,
"flrrtrk1azimuth_srx_black" DOUBLE,
"flrrtrk1rangerate_srx_black" DOUBLE,
"flrrtrk7range_srx_black" DOUBLE,
"flrrtrk7azimuth_srx_black" DOUBLE,
"flrrtrk7rangerate_srx_black" DOUBLE,
"flrrtrk9range_srx_black" DOUBLE,
"flrrtrk9azimuth_srx_black" DOUBLE,
"flrrtrk9rangerate_srx_black" DOUBLE,
"accdrvrseltdspd_precacc_srx_black" DOUBLE,
"accact370_precacc_srx_black" DOUBLE,
"acactpos_precacc_srx_black" DOUBLE,
"p29_engine_rpm_srx_black" DOUBLE,
"brkpdlpos_precacc_srx_black" DOUBLE,
"brklightflag_srx_black" DOUBLE,
"strwhang_srx_black" DOUBLE,
"global_yaw_pinpoint_black" DOUBLE,
"velocity_fwd_pinpoint_black" DOUBLE,
"velocity_fwd_admas_black" DOUBLE,
"research_bus_injected_torque_cacc_mab_black" DOUBLE,
"acc_axle_torque_cmd_axle_torque_request_black" DOUBLE,
"throttle_commanded_position_black" DOUBLE,
"full_speed_range_acc_cruise_switch_action_detected_black" DOUBLE,
"p29_accelerator_effective_position_black" DOUBLE,
"p5_commanded_axle_torque_immediate_black" DOUBLE,
"p5_commanded_axle_torque_predicted_black" DOUBLE,
"p29_actual_vehicle_acceleration_black" DOUBLE,
"p5_autonomous_braking_accelerator_actual_pstn_stts_prt_ba921370" DOUBLE,
"p5_road_load_nominal_axle_torque_black" DOUBLE,
"p5_driver_intended_axle_torque_black" DOUBLE,
"p5_instantaneous_fuel_consumption_rate_black" DOUBLE,
"p5_accelerator_pedal_override_active_black" DOUBLE,
"veh_color_green" VARCHAR,
"bin_utc_time_s_green" DOUBLE,
"throttle_ovr_flag_green" DOUBLE,
"max_accel_cacc_green" DOUBLE,
"command_mode_cacc_green" DOUBLE,
"speed_command_cacc_green" DOUBLE,
"override_enabled_cacc_green" DOUBLE,
"accelerator_pedal_override_active_green" DOUBLE,
"vehspdavgdrvn_srx_green" DOUBLE,
"flrrtrk1range_srx_green" DOUBLE,
"flrrtrk1azimuth_srx_green" DOUBLE,
"flrrtrk1rangerate_srx_green" DOUBLE,
"flrrtrk7range_srx_green" DOUBLE,
"flrrtrk7azimuth_srx_green" DOUBLE,
"flrrtrk7rangerate_srx_green" DOUBLE,
"flrrtrk9range_srx_green" DOUBLE,
"flrrtrk9azimuth_srx_green" DOUBLE,
"flrrtrk9rangerate_srx_green" DOUBLE,
"accdrvrseltdspd_precacc_srx_green" DOUBLE,
"accact370_precacc_srx_green" DOUBLE,
"acactpos_precacc_srx_green" DOUBLE,
"p29_engine_rpm_srx_green" DOUBLE,
"brkpdlpos_precacc_srx_green" DOUBLE,
"brklightflag_srx_green" BIGINT,
"strwhang_srx_green" DOUBLE,
"global_yaw_pinpoint_green" DOUBLE,
"velocity_fwd_pinpoint_green" DOUBLE,
"velocity_fwd_admas_green" DOUBLE,
"research_bus_injected_torque_cacc_mab_green" DOUBLE,
"acc_axle_torque_cmd_axle_torque_request_green" DOUBLE,
"throttle_commanded_position_green" DOUBLE,
"full_speed_range_acc_cruise_switch_action_detected_green" DOUBLE,
"runid_green" BIGINT,
"p29_accelerator_effective_position_green" DOUBLE,
"p5_commanded_axle_torque_immediate_green" DOUBLE,
"p5_commanded_axle_torque_predicted_green" DOUBLE,
"p29_actual_vehicle_acceleration_green" DOUBLE,
"p5_autonomous_braking_accelerator_actual_pstn_stts_prt_53fadaa3" DOUBLE,
"p5_road_load_nominal_axle_torque_green" DOUBLE,
"p5_driver_intended_axle_torque_green" DOUBLE,
"p5_instantaneous_fuel_consumption_rate_green" DOUBLE,
"p5_accelerator_pedal_override_active_green" DOUBLE,
"veh_color_grey" VARCHAR,
"bin_utc_time_s_grey" DOUBLE,
"throttle_ovr_flag_grey" DOUBLE,
"max_accel_cacc_grey" DOUBLE,
"command_mode_cacc_grey" DOUBLE,
"speed_command_cacc_grey" DOUBLE,
"override_enabled_cacc_grey" DOUBLE,
"accelerator_pedal_override_active_grey" BIGINT,
"vehspdavgdrvn_srx_grey" DOUBLE,
"flrrtrk1range_srx_grey" DOUBLE,
"flrrtrk1azimuth_srx_grey" DOUBLE,
"flrrtrk1rangerate_srx_grey" DOUBLE,
"flrrtrk7range_srx_grey" DOUBLE,
"flrrtrk7azimuth_srx_grey" DOUBLE
);
Anyone who has the link will be able to view this.