SRM From UDOT And Panasonic Connected Vehicle Data Ecosystem Program
Department of Transportation
@usgov.dot_gov_srm_from_udot_and_panasonic_connected_vehicle__b3e6ab23
Department of Transportation
@usgov.dot_gov_srm_from_udot_and_panasonic_connected_vehicle__b3e6ab23
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,
"requestor_name" DOUBLE,
"requestor_type" VARCHAR,
"vehicle_role" VARCHAR,
"vehicle_subrole" VARCHAR,
"request_id" BIGINT,
"request_type" VARCHAR,
"request_duration" DOUBLE,
"request_moy_utc" BIGINT,
"request_milliseconds_utc" BIGINT,
"inbound_lane" BIGINT,
"heading" DOUBLE,
"elevation" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"speed" BIGINT,
"transmission" VARCHAR
);
Anyone who has the link will be able to view this.