SSM From UDOT And Panasonic Connected Vehicle Data Ecosystem Program
Department of Transportation
@usgov.dot_gov_ssm_from_udot_and_panasonic_connected_vehicle__b95ec55c
Department of Transportation
@usgov.dot_gov_ssm_from_udot_and_panasonic_connected_vehicle__b95ec55c
CREATE TABLE table_1 (
"msg_id" VARCHAR,
"tenant" VARCHAR,
"tmstp_utc" VARCHAR,
"date_utc" VARCHAR,
"msg_moy_utc" BIGINT,
"msg_milliseconds_utc" BIGINT,
"msg_count" BIGINT,
"intersection_id" BIGINT,
"road_regulator_id" VARCHAR,
"entity_id" VARCHAR,
"station_id" DOUBLE,
"msg_rank" BIGINT,
"signal_moy_utc" VARCHAR,
"signal_milliseconds_utc" VARCHAR,
"request_id" BIGINT,
"status" VARCHAR,
"vehicle_role" VARCHAR,
"signal_msg_count" BIGINT,
"duration" VARCHAR,
"inbound_lane" BIGINT,
"status_msg_count" BIGINT
);
Anyone who has the link will be able to view this.