Number of disruptions at least 4 hours in duration. *No measure since this is a leading measure that is tied into the Water Disruptions Ratio PM.

Budget Book page for the department.

Budget Book page for the department.

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).

Daily high/low air temperature recorded at KFFZ1M High Frequency ASOS weather station located at Falcon Field Airport. 2016 data is missing. Location information: Latitude 33.46667, Longitude -111.73333; Elevation (ft)1,391; Elevation from DEM 1,355.

This version redacts sensitive information including personnel assigned and responding to the service request. This dataset allows for the calculation of the Arizona 811 Tickets submitted in the Mesa and/or Magma Service Areas. An 811 locate ticket is generated by a homeowner or excavator contacting Arizona’s 811 service and informing them that they have a project that involves underground excavation. The ticket is assigned a ticket identification number and forwarded to the appropriate utility that assigns department various staff (gas, water, electric, etc.) to identify and mark any existing underground utilities in the specified project area.

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

Aggregates current, previous and target energy usage for city owned facilities where site type = Drinking Water Treatment & Distribution.

SELECT
month_date,
sum(`kwh`),
sum(`previous_kwh_usage`),
sum(`target_kwh`),
case(`sum_kwh` > 0, (`sum_kwh` - `sum_previous_kwh_usage`) / `sum_previous_kwh_usage`) AS `total_percent_change`,
case(`sum_kwh` > 0, (`sum_kwh` - `sum_target_kwh`) / `sum_target_kwh`) AS `target_percent_change`

WHERE `site_type` IN ('Drinking Water Treatment & Distribution')

GROUP BY
`month_date`

ORDER BY `month_date` desc

This version redacts all sensitive information including who the case was submitted to, who was dispatched, actual location of the incident, and the geocoded location of the incident. The data documented in the table below is the information related to each emergency call that is received by Energy Resources. The data serves as the official record for each call and is used for various things such as determining response time, tracking call volume and ultimately serving as the official record of a response if any questions should arise about how Energy Resources handled an emergency call.

A view that joins the summed expenditure amounts and the customer counts by month for Electric. Used for Performance Metrics.
Data Sources:
https://citydata.mesaaz.gov/Financial-Services/City-Expenditures/cmtm-9tuw
https://citydata.mesaaz.gov/Energy-Utilities/Electric-Consumption/efwv-ff2w