Preventative to Unplanned Repairs Ratio

This measure is part of Measures of Success Program (MOS). MOS is a client-centered approach to demonstrate the County's progress in meeting client needs. Selected measures are representative of County department’s core business and operations. The Facilities and Fleet Department, Building Operations Division, is responsible for maintenance management of County facilities. By performing on-time and effective preventive maintenance, facilities are safe and reliable to serve the public and County staff. Unplanned repair maintenance occurs for a variety of reasons, including system failures, end of useful life for equipment, and wear and tear. The Department records the ratio of preventative maintenance to unplanned repair maintenance. The industry standard for the ratio of preventive maintenance to unplanned repair maintenance is 6 to 1 (6:1). This benchmark demonstrates when the preventive maintenance schedule is met, unplanned repairs are less frequent.

Reporting Period: Fiscal Year 2016 - 2023

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 \"sccgov/preventative-to-unplanned-repairs-ratio-pip4-uegg\".\"preventative_to_unplanned_repairs_ratio\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.