This dataset allows for the monthly computation of the System Average Interruption Frequency Index (SAIFI) for the City of Mesa’s electric utility. The System Average Interruption Frequency Index is commonly used as a reliability indicator by electric power utilities. It measures the average outage frequency per customer and is calculated by taking the sum of the total customers interrupted divided by the total number of active customers. Data reporting may have a 14 day lag.

Information about work performed on Water Resources assets such as valves and hydrants. This view redacts sensitive information including the work order location.

The list of sewer lines that are cleaned and/or inspected by month, including the number of miles cleaned or inspected. Inspections are accomplished with CCTV and acoustic technologies while cleaning uses a pressure washer to clean the inside of the pipe. The work is completed by City of Mesa crews and contractors. Contractor data is summarized. Location data has been redacted.

This view redacts sensitive information including the associated permit number, permitted sources inspected and inspection notes. Information about environmental inspections and notice of violations. An environmental inspection is an investigation of the City of Mesa’s level of compliance with an environmental regulation or permit, or of a perceived noncompliance or a complaint. A Notice of Violation (NOV) notifies the recipient that a regulatory agency believes the recipient committed one or more violations of any applicable rules or regulations. See Environmental Compliance Attachment for additional information.

Inspection Results:
"Pass" (no violations noted);"Opportunity to Correct" (may be issued to afford an opportunity to correct those instances of noncompliance that meets the agency definition of a minor violation) ;"Notice of Violation" (notifies the recipient that a regulatory agency believes the recipient committed one or more violations of any applicable rules or regulations.); "Other Action" (includes requests for follow-up, additional documentation, etc)

Monthly summary of electric energy used by all City Buildings. Use is measured by (kWh) by City Buildings. The data is both internal (CIS) and external data sources (Salt River Project Utility Bills).

Budget Book page.

Total consumption in kWh and as percentage of overall city energy consumption by type of city facility.

Average frequency of interruptions per customer measured on a monthly basis. SAIFI =the number of customers interrupted divided by the total number of active customers.

Amount of water loss per month as a percentage. City of Mesa receives reporting from Central Arizona Project. These reports are received 2 months after the month being reported (example: June 2021 data will be received in August 2021).

This version redacts all sensitive information including the person making the report, street number, longitude, latitude, geolocation, and name of excavator. This dataset contains information necessary to compute the number of reportable incidents occurring per month on Mesa’s natural gas system and determine the cause of any damages that may occur.