About this Dataset

2014 ITS World Congress Connected Vehicle Test Bed Demonstration Vehicle Situation Data

During the 2014 ITS World Congress a demonstration of the connected vehicle infrastructure in the City of Detroit was conducted. The test site included approximately 14 intersections around Detroit’s COBO convention center and involved 9 equipped vehicles. The Vehicle Situation Data (VSD) data set includes a series of data files that recorded vehicle situational data that were generated by an equipped vehicle. During the ITS World Congress, VSDs were encoded with one of two schemas. The dataset contains decoded data using both 2.0 and 2.1 ASN.1 schemas.
Organization: Department of Transportation
Last updated: 2020-11-12T12:49:10.999178
Tags: 2014-its-world-congress-itswc-connected-vehicle-cv-test-bed-demonstration, application-message, arterial, connected-equipment, connected-vehicles, detroit, field-test, intelligent-transportation-systems-its, its-joint-program-office-jpo, its-world-congress, map, michigan, signal-phase-and-timing-spat, vehicle-situation-data-vsd

Tables

Table 1

@usgov.dot_gov_2014_its_world_congress_connected_vehicle_test_21aa9074.table_1

108.38 MB
3167670 rows
39 columns


CREATE TABLE table_1 (
  "schema" BIGINT,
  "dialogid" VARCHAR,
  "seqid" VARCHAR,
  "requestid" VARCHAR,
  "type" BIGINT,
  "path_initialposition_utctime_year" BIGINT,
  "path_initialposition_utctime_month" BIGINT,
  "path_initialposition_utctime_day" BIGINT,
  "path_initialposition_utctime_hour" BIGINT,
  "path_initialposition_utctime_minute" BIGINT,
  "path_initialposition_utctime_seconds" DOUBLE,
  "path_initialposition_longitude" DOUBLE,
  "path_initialposition_latitude" DOUBLE,
  "path_initialposition_elevation_meters" DOUBLE,
  "path_itemcnt" BIGINT,
  "path_crumbdata_pathhistorypointsets_04" VARCHAR,
  "bundle_tempid" VARCHAR,
  "bundle_time_year" BIGINT,
  "bundle_time_month" BIGINT,
  "bundle_time_day" BIGINT,
  "bundle_time_hour" BIGINT,
  "bundle_time_minute" BIGINT,
  "bundle_time_seconds" DOUBLE,
  "bundle_pos_longitude" DOUBLE,
  "bundle_pos_latitude" DOUBLE,
  "bundle_pos_elevation_long" BIGINT,
  "bundle_fundamental_speed_meterspersecond" DOUBLE,
  "bundle_fundamental_speed_transmission" VARCHAR,
  "bundle_fundamental_heading_deg" DOUBLE,
  "bundle_fundamental_steeringangle_long" BIGINT,
  "bundle_fundamental_accelset" VARCHAR,
  "bundle_fundamental_accel_long" BIGINT,
  "bundle_fundamental_accel_lat" BIGINT,
  "bundle_fundamental_accel_vert" BIGINT,
  "bundle_fundamental_accel_yaw" BIGINT,
  "bundle_fundamental_brakes_long" BIGINT,
  "bundle_fundamental_vehsize_width" BIGINT,
  "bundle_fundamental_vehsize_length" BIGINT,
  "crc" VARCHAR
);