MTA Central Business District Bus Routes

This dataset is a list of MTA bus routes that intersect with the CBD, and how each route relates to the CBD (whether it crosses the CBD or is entirely in the CBD). It is meant to be a dimension table that can easily be used with other bus route-level datasets so that data users can easily distinguish between routes serving the CBD and routes that do not.

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 \"ny-gov/mta-central-business-district-bus-routes-cgzt-smqf\".\"mta_central_business_district_bus_routes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.