Accessible Pedestrian Signal Locations

NYC DOT's Accessible Pedestrian Signals (APS) are devices affixed to pedestrian signal poles to assist blind or low vision pedestrians in crossing the street. APS are wired to a pedestrian signal and send audible and vibrotactile indications when pedestrians push a botton installed at a crosswalk.

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/accessible-pedestrian-signal-locations-de3m-c5p4\".\"accessible_pedestrian_signal_locations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.