MTA Eye on the Future Contract Solicitations: June 2018 – May 2019

Until March 2020, the MTA publicized solicitations on its website for capital projects in its Eye on the Future newsletters. Each report contained information for prospective contractors, engineers, architects and vendors about contracts for professional services, construction, and equipment procurement capital projects that are expected to be advertised for bids during specific time period by the Metropolitan Transportation Authority’s operating agencies.

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-eye-on-the-future-contract-solicitations-june-e3e7-qwer\".\"mta_eye_on_the_future_contract_solicitations_june\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.