About this Dataset

2014 ITS World Congress Connected Vehicle Test Bed Demonstration Intersection 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.Intersection Situation Data (ISD) data set communicates MAP and signal phase and timing (SPaT) information. MAP information communicates an intersection’s location (latitude and longitude), elevation, and geometric features such as approaches and lane configuration. SPaT data communicates the (current) state of the intersection’s signal indication(s). The data is composed of discrete Row Groups. A Row Group is a collection of (approximately 3-4) consecutive rows with common attribute.

NOTE: All Extra Files are attached in 2014 ITS World Congress Connected Vehicle Test Bed Demonstration Vehicle Situation Data
Organization: Department of Transportation
Last updated: 2020-11-12T12:35:29.376087
Tags: 2014-its-world-congress-itswc-connected-vehicle-cv-test-bed-demonstration, application-message, arterial, connected-equipment, connected-vehicle-message, detroit, field-test, intelligent-transportation-systems-its, intersection-situation-data-isd, its-joint-program-office-jpo, its-world-congress, map, michigan, signal-phase-and-timing-spat

Tables

Table 1

@usgov.dot_gov_2014_its_world_congress_connected_vehicle_test_2544c6f7.table_1

23.37 MB
4,103,332 rows
36 columns

CREATE TABLE table_1 (
  "dialogid" VARCHAR,
  "seqid" VARCHAR,
  "requestid" VARCHAR,
  "bundlenumber" BIGINT,
  "timetolive" VARCHAR,
  "serviceregion_nwcorner_lat" BIGINT,
  "serviceregion_nwcorner_long" BIGINT,
  "serviceregion_secorner_lat" BIGINT,
  "serviceregion_secorner_long" BIGINT,
  "map_msgid" VARCHAR,
  "map_msgcnt" BIGINT,
  "map_layertype" VARCHAR,
  "map_int_name" VARCHAR,
  "map_int_id" VARCHAR,
  "map_int_refpoint_lat" BIGINT,
  "n__mapdata_int_refpoint_long" BIGINT  -- MapData Int RefPoint Long,
  "map_int_approach_name" VARCHAR,
  "map_int_approach_id" BIGINT,
  "map_int_approach_drivinglanes_lanenumber" BIGINT  -- Map Int, Approach DrivingLanes LaneNumber,
  "map_int_approaches_approach_drivinglanes" BIGINT,
  "map_int_approach_drivinglanes_laneattributes" BIGINT,
  "map_int_approach_drivinglanes_nodelist" VARCHAR,
  "map_crc" VARCHAR,
  "spat_timestamp_year" BIGINT,
  "spat_timestamp_month" BIGINT,
  "spat_timestamp_day" BIGINT,
  "spat_timestamp_hour" BIGINT,
  "spat_timestamp_minute" BIGINT,
  "spat_timestamp_second" BIGINT,
  "spat_int_id" VARCHAR,
  "spat_int_status" BIGINT,
  "spat_int_states_laneset" VARCHAR,
  "spat_int_states_currstate" BIGINT,
  "spat_int_states_timetochange" BIGINT,
  "n__spat_int_states_stateconfidence" VARCHAR  -- Spat Int States StateConfidence,
  "spat_int_states_yellstateconfidence" VARCHAR
);