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. 

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-transportation-gov/enhanced-transit-safety-retrofit-package-etrp-7xqa-bpf3\".\"enhanced_transit_safety_retrofit_package_etrp\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.