Advanced Messaging Concept Development: Basic Mobility Message
Department of Transportation
@usgov.dot_gov_advanced_messaging_concept_development_basic_m_ff6b87a6
Department of Transportation
@usgov.dot_gov_advanced_messaging_concept_development_basic_m_ff6b87a6
CREATE TABLE table_1 (
"message_id" BIGINT,
"obu_id" BIGINT,
"time_sent" BIGINT,
"time_received" BIGINT,
"mode_of_transmission" BIGINT,
"container_message_id" BIGINT,
"width" BIGINT,
"length" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"elevation" DOUBLE,
"speed" DOUBLE,
"heading" DOUBLE,
"transmission_state" BIGINT,
"longitudinal_acceleration" DOUBLE,
"lateral_acceleration" DOUBLE,
"vertical_acceleration" BIGINT,
"brake_applied_status" BIGINT,
"traction_control_state" BIGINT,
"stability_control_status" BIGINT,
"steering_wheel_angle" DOUBLE,
"yaw_rate" DOUBLE,
"abs_active" BIGINT,
"ambient_air_temperature" BIGINT,
"ambient_air_pressure" BIGINT,
"precipitation_sensor" BIGINT,
"tire_air_pressure" BIGINT,
"wiper_status" BIGINT,
"light_status" BIGINT,
"test_no" BIGINT
);
Anyone who has the link will be able to view this.