MTA 2025-2044 20-Year Needs Assessment Police Fleet Inventory

The 2025-2044 20-Year Needs Assessment outlines capital work the MTA needs to do over the next two decades to keep the region moving. The MTA developed a three-part plan to secure the foundation of the system and ensure another 100 years of service by reconstructing, renewing, and modernizing the system. This dataset includes data on the fleet inventory for MTA Police, with information on the number of units for each asset type, the useful life of each type, the year the assets were built, and number of years of remaining useful life. It includes all vehicles used by the MTA Police Department that are eligible for capital funding.

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-20252044-20year-needs-assessment-police-fleet-vubw-ein5\".\"mta_20252044_20year_needs_assessment_police_fleet\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.