About this Dataset

Enhanced Transit Safety Retrofit Package (E-TRP)

The data is taken from three intersections and 24 buses over a six month period in Cleveland, Ohio. The systems at the intersections provided MAP and SPAT messages and the SPAT message contained pedestrian detections from a series of cameras at the intersection. The buses received these messages and used them to alert the vehicle driver when pedestrians were about to enter the crosswalks or was in the crosswalk. The buses also used basic safety messages from external vehicles to warn the driver when another vehicle had the potential of making a right hand turn in front of the vehicle. The data contains bus locations, bus state changes, pedestrian detections and user interface state changes.
Organization: Department of Transportation
Last updated: 2020-11-12T12:39:28.155634
Tags: application-message, bus-locations, cleveland, connected-vehicle-message, enhanced-transit-safety-retrofit-package-e-trp, intelligent-transportation-systems-its, its-joint-program-office-jpo, ohio, pedestrian-detection, pedestrian-in-crosswalk-warning-pcw, roadside-equipment-rse, transit, transit-signal-priority-tsp, vehicle-turning-right-in-front-of-bus-warning-vtrw

Tables

Table 1

@usgov.dot_gov_enhanced_transit_safety_retrofit_package_e_trp.table_1

17.23 MB
239455 rows
10 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "alertid" VARCHAR,
  "eventid" VARCHAR,
  "interactionid" VARCHAR,
  "eventtimestamp" VARCHAR,
  "applicationtype" VARCHAR,
  "appmessagetype" VARCHAR,
  "eventcodetype" VARCHAR,
  "deviceid" BIGINT,
  "vehicleid" BIGINT
);