Baselight

EMS - Fleet Maintenance

City of Austin

@usgov.city_of_austin_ems_fleet_maintenance

Loading...
Loading...

About this Dataset

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.
Organization: City of Austin
Last updated: 2020-11-12T13:22:09.091052
Tags: 911, ambulance, atcems, austin, emergency-medical-services, ems, fleet, travis-county

Tables

Table 1

@usgov.city_of_austin_ems_fleet_maintenance.table_1
  • 11.99 KB
  • 95 rows
  • 11 columns
Loading...

CREATE TABLE table_1 (
  "month_key" BIGINT,
  "month_year" VARCHAR,
  "total_vehicles_due" BIGINT,
  "percent_of_vehicles_serviced" DOUBLE,
  "count_ambulances_due" BIGINT,
  "percent_ambulances_serviced" DOUBLE,
  "count_command_vehicles_due" BIGINT,
  "percent_command_vehicles_serviced" DOUBLE,
  "count_utility_vehicles_due" BIGINT,
  "percent_utility_vehicles_serviced" DOUBLE,
  "scheduled_maintenance_target" BIGINT
);

Share link

Anyone who has the link will be able to view this.