Icon for Socrata external plugin
Open repository in Console
Updated 8 days ago
Indexed 5 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/real-time-passenger-information-sign-locations-g9jx-npbk\".\"real_time_passenger_information_sign_locations\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • real_time_passenger_information_sign_locations
Upstream Metadata