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.

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 \"datahub-austintexas-gov/ems-fleet-maintenance-5nys-nsyc\".\"ems_fleet_maintenance\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.