cityofnewyork-us/real-time-passenger-information-sign-locations-g9jx-npbk
Icon for Socrata external plugin
Open repository in Console
 
Readme
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 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.

 
Preview
  • real_time_passenger_information_sign_locations
     
     
     
     
     
Upstream Metadata