Real Time Passenger Information Sign Locations

The Department of Transportation (DOT) replaces standard bus sign poles with Real Time Passenger Information (RTPI) bus signs at numerous locations throughout New York City. The project's initiative is to update the visual look of the current bus stop pole flag design by adding small LED screens next to each bus route that denote the number of minutes until the arrival of the next bus. Additionally, each sign includes a push-button activated audio announcement of the real-time bus arrival information.

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 \"cityofnewyork-us/real-time-passenger-information-sign-locations-g9jx-npbk\".\"real_time_passenger_information_sign_locations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.