EMS - Fleet Maintenance
This table contains data on maintenance of the department response fleet – ambulances, command trucks, and utility vehicles. It includes the number of vehicles due for preventative maintenance each month, and the percentage that are serviced. The data is broken out by the three vehicle types in addition to describing overall performance.
When no units are due for service in a month, the "Percent Serviced" column will show a null (blank) value for that month.
|Name||Socrata field name||Column name in ||Data type||Description|
|Percent Utility Vehicles Serviced||percent_vehicles_complete_utility||percent_vehicles_complete_utility||Number||Percent of utility vehicles due for service in month that received service by due date.|
|Count Utility Vehicles Due||count_vehicles_due_utility||count_vehicles_due_utility||Number||Count of all utility vehicles due for service in month.|
|Percent Command Vehicles Serviced||percent_vehicles_complete_command||percent_vehicles_complete_command||Number||Percent of command vehicles due for service in month that received service by due date.|
|Count Ambulances Due||count_vehicles_due_ambulance||count_vehicles_due_ambulance||Number||Count of all ambulances due for service for the month.|
|Percent Ambulances Serviced||percent_vehicles_complete_ambulance||percent_vehicles_complete_ambulance||Number||Percent of ambulances due for service in the month that received service by the due date.|
|Percent of Vehicles Serviced||percent_vehicles_complete_all||percent_vehicles_complete_all||Number||Percentage of vehicles that received service by due date for the month.|
|Total Vehicles Due||count_vehicles_due_all||count_vehicles_due_all||Number||Count of all response vehicles due for service.|
|Month-Year||month_start_date||month_start_date||Calendar date||Month and year for report.|
|Scheduled Maintenance Target||percent_vehicles_complete_target||percent_vehicles_complete_target||Number|
|Month Key||month_key||month_key||Number||Unique ID for record. Year and month in <yyyymm> format.|
|Count Command Vehicles Due||count_vehicles_due_command||count_vehicles_due_command||Number||Count of command vehicles due for service in month.|