Bike Share Inspections

Inspections has halted since March 2020.

DOT field inspectors conduct inspections and issue tickets in real-time to the Bike Share system operator according to service level agreements. Stations, kiosks, docks, and bicycles are checked.

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/bike-share-inspections-5uei-swth\".\"bike_share_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.