MAP From UDOT And Panasonic Connected Vehicle Data Ecosystem Program
Department of Transportation
@usgov.dot_gov_map_from_udot_and_panasonic_connected_vehicle__e9d7529c
Department of Transportation
@usgov.dot_gov_map_from_udot_and_panasonic_connected_vehicle__e9d7529c
CREATE TABLE table_1 (
"msg_id" VARCHAR,
"tenant" VARCHAR,
"intersection_id" BIGINT,
"road_regulator_id" VARCHAR,
"intersection_name" VARCHAR,
"min_tmstp_utc" VARCHAR,
"max_tmstp_utc" VARCHAR,
"offset_tmstp_utc" VARCHAR,
"moy_utc" BIGINT,
"layer_id" BIGINT,
"layer_type" VARCHAR,
"msg_revision" BIGINT,
"elevation" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"intersection_revision" BIGINT,
"lane_width" BIGINT,
"vehicle_max_speed" VARCHAR,
"vehicle_min_speed" VARCHAR,
"vehicle_night_max_speed" VARCHAR,
"max_speed_school_zone" VARCHAR,
"max_speed_school_zone_children" VARCHAR,
"max_speed_construction_zone" VARCHAR,
"truck_min_speed" VARCHAR,
"truck_max_speed" VARCHAR,
"truck_night_max_speed" VARCHAR,
"vehicle_trailer_min_speed" VARCHAR,
"vehicle_trailer_max_speed" VARCHAR,
"vehicle_trailer_night_max_speed" VARCHAR,
"unknown_speed" VARCHAR,
"lane_set" VARCHAR
);
Anyone who has the link will be able to view this.