Fleet_List_City_PWSA_Combined.xlsx

The file is a comprehensive fleet inventory list for the City of Pittsburgh, encompassing vehicles and equipment across multiple municipal departments including Public Works, Emergency Management, Emergency Services, Police, Fire, and Water and Sewer Authority (PWSA). The inventory contains 722 assets ranging from sedans and SUVs to specialized vehicles like fire trucks, ambulances, dump trucks, recycling packers, utility vehicles, and trailers, with most vehicles manufactured between 2005 and 2022. The vehicles are primarily from manufacturers such as Ford, Chevrolet, International, and Freightliner, with a notable trend toward electric and hybrid vehicles across departments.

The fleet inventory details each vehicle's specific attributes including department assignment, vehicle type, serial number, tag number, in-service date, and contract status. The City's fleet demonstrates a strategic approach to vehicle procurement, with a mix of utility, administrative, emergency response, and specialized operational vehicles. Notable observations include a significant number of electric vehicles (Chevrolet Bolt EVs), hybrid vehicles, and recent investments in Ford F-Series trucks and Ford Interceptor SUVs. The inventory suggests an ongoing modernization effort with newer vehicles replacing older models, a focus on fuel efficiency, and a diverse vehicle portfolio designed to support the City of Pittsburgh's various municipal service requirements.