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 dataset allows for the monthly computation of the System Average Interruption Duration Index (SAIDI) for the City of Mesa’s electric utility. The System Average Interruption Duration Index is commonly used as a reliability indicator by electric power utilities. It measures the average outage duration for each customer served and is calculated by taking the sum of the total customer minutes of service interruptions and dividing that by the total number of customers served. Data reporting may have a lag of 14 days.

Measures and tracks the percent of emergency response times within the Mesa gas system area that exceed the 30 minutes response time target, from notification to arrival on the scene.

The number of 'probable non-compliance issues' and 'notice of violations' from the AZ Corporation Commission. Data is reported quarterly but may have an additional 30 day lag.

Budget Book page.

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

Total tonnages for blue recycle & green waste barrels divided by total trash, blue
recycle and green waste barrel tonnage. This includes recycling of cardboard, paper and
paperboard, packaging/containers including aluminum, glass, plastic and yard waste.

This view aggregates actual, previous and target energy usage in kWh for City buildings (where Site Type = Building) and calculates the percentage change.

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 `building_flag` = 'Y'

GROUP BY
`month_date`

ORDER BY `month_date` desc

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). Although update job runs daily, the source data is updated monthly and is delayed by up to 30 days for the prior billing period.