About this Dataset

BSM From UDOT And Panasonic Connected Vehicle Data Ecosystem Program

This dataset contains V2X data collected from the Utah Connected Vehicle Data Ecosystem Program. We have submitted 7 days of deduplicated Basic Safety Messages (BSMs) in J2735 standards from 3 intersections in Orem, UT.This includes: (1) vehicles equipped with OBUs (Onboard Units) for real-time V2X (Vehicle-to-Everything) data transmission and reception, (2) road-side units (RSUs) capable of capturing, transmitting, and processing data from the transportation environment, and (3) a secure, scalable cloud platform for aggregating, analyzing, and visualizing transportation data.
Organization: Department of Transportation
Last updated: 2025-07-09T14:22:32.303430
Tags: basic-safety-message-bsm, connected-vehicle-data, intelligent-transportation-systems-its, its-joint-program-office-jpo, signal-phase-and-timing-spat, transit-signal-priority-tsp

Tables

Table 1

@usgov.dot_gov_bsm_from_udot_and_panasonic_connected_vehicle__91fc6d88.table_1

394.87 MB
4137684 rows
120 columns


CREATE TABLE table_1 (
  "tmstp_epoch" BIGINT,
  "tmstp_utc" VARCHAR,
  "date_utc" VARCHAR,
  "rsu_locations" VARCHAR,
  "temp_id" VARCHAR,
  "msg_count" BIGINT,
  "sec_mark" BIGINT,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "elevation" BIGINT,
  "heading" BIGINT,
  "speed" BIGINT,
  "transmission_state" VARCHAR,
  "lateral_acceleration" BIGINT,
  "longitudinal_acceleration" BIGINT,
  "vertical_acceleration" BIGINT,
  "yaw_rate" BIGINT,
  "semi_major_axis_orientation" BIGINT,
  "semi_major_axis_accuracy" BIGINT,
  "semi_minor_axis_accuracy" BIGINT,
  "steering_wheel_angle" BIGINT,
  "abs_status" VARCHAR,
  "auxiliary_brake_status" VARCHAR,
  "brake_boost_status" VARCHAR,
  "scs_status" VARCHAR,
  "traction_control_status" VARCHAR,
  "wheel_brakes_flags" BIGINT,
  "brake_unavailable" BOOLEAN,
  "brake_left_front" BOOLEAN,
  "brake_left_rear" BOOLEAN,
  "brake_right_front" BOOLEAN,
  "brake_right_rear" BOOLEAN,
  "vehicle_length" BIGINT,
  "vehicle_width" BIGINT,
  "vehicle_classification" DOUBLE,
  "vehicle_role" VARCHAR,
  "vehicle_fuel_type" VARCHAR,
  "vehicle_hpms_type" VARCHAR,
  "vehicle_key_type" DOUBLE,
  "vehicle_height" DOUBLE,
  "vehicle_mass" DOUBLE,
  "vehicle_bumper_front" DOUBLE,
  "vehicle_bumper_rear" DOUBLE,
  "air_pressure" DOUBLE,
  "air_temp" DOUBLE,
  "front_wiper_rate" DOUBLE,
  "front_wiper_status" VARCHAR,
  "friction" DOUBLE,
  "is_raining" VARCHAR,
  "precip_situation" VARCHAR,
  "rain_rate" DOUBLE,
  "road_friction" DOUBLE,
  "solar_radiation" DOUBLE,
  "exterior_lights_flags" DOUBLE,
  "low_beam_headlights" VARCHAR,
  "high_beam_headlights" VARCHAR,
  "left_turn_signal" VARCHAR,
  "right_turn_signal" VARCHAR,
  "hazard_lights" VARCHAR,
  "automatic_light_control" VARCHAR,
  "daytime_running_lights" VARCHAR,
  "fog_lights" VARCHAR,
  "parking_lights" VARCHAR,
  "safety_events_flags" DOUBLE,
  "event_hazard_lights" VARCHAR,
  "event_intersection_violation" VARCHAR,
  "event_abs_violation" VARCHAR,
  "event_traction_control_loss" VARCHAR,
  "event_stability_control_activated" VARCHAR,
  "event_hazardous_materials" VARCHAR,
  "event_reserved_1" VARCHAR,
  "event_hard_braking" VARCHAR,
  "event_lights_changed" VARCHAR,
  "event_wipers_changed" VARCHAR,
  "event_flat_tire" VARCHAR,
  "event_disabled_vehicle" VARCHAR,
  "event_airbag" VARCHAR,
  "emergency_events_flags" VARCHAR,
  "emergency_unavailable" VARCHAR,
  "emergency_response" VARCHAR,
  "emergency_lights_active" VARCHAR,
  "emergency_sound_active" VARCHAR,
  "non_emergency_lights_active" VARCHAR,
  "non_emergency_sound_active" VARCHAR,
  "disabled_vehicle_status_details" VARCHAR,
  "type_event" VARCHAR,
  "vehiclealerts_events_not_used" VARCHAR,
  "vehiclealerts_lightbar_use" VARCHAR,
  "vehiclealerts_multi" VARCHAR,
  "vehiclealerts_siren_use" VARCHAR,
  "vehiclealerts_not_used" VARCHAR,
  "trailers_connection_pivot_offset" VARCHAR,
  "trailers_connection_pivots" VARCHAR,
  "trailers_connection_pivot_angle" VARCHAR,
  "trailers_not_used" VARCHAR,
  "trailers_length" VARCHAR,
  "trailers_height" VARCHAR,
  "trailers_width" VARCHAR,
  "trailers_isdolly" VARCHAR,
  "trailers_front_pivot_angle" VARCHAR
);