MTA LIRR Branches

This dataset shows the geographic locations of the branches on the LIRR used in passenger service as of 2013. It does not include a more recent change, namely the opening of the line to Grand Central Madison. It will be updated in the future to account for this.

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-lirr-branches-2vcb-zrh4\".\"mta_lirr_branches\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.