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.

Comparison of monthly actual and budgeted electric power supply and transmission costs on a cumulative basis.

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

Comparison of monthly actual and budgeted natural gas supply and transportation
costs on a cumulative basis.

Number of customer drop offs of household hazardous materials at HHM Facility. Each customer visit is counted separately.

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.

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 total energy use in kWh across all city buildings per month.

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.

This view includes information about energy usage by City facilities for current and previous year (same month, prior year) Also included are calculated targets for reductions in energy consumption and progress toward achieving them (% change).

SELECT
`row_id`,
`site`,
`site_type`,
`category`,
`address`,
`latitude`,
`longitude`,
`geolocation`,
`premise_code_account_number`,
`building_flag`,
`ems_flag`,
`square_footage`,
`month_date`,
@self.`month_date` AS `previous_date`,
`year`,
`month`,
`kwh`,
@self.`kwh` AS `previous_kwh_usage`,
@self.`kwh` * 0.95 AS `target_kwh`,
case(`target_kwh` > 0, (`kwh` - `target_kwh`) / `target_kwh`) AS `target_percent_change`,
case(`target_kwh` > 0, (`kwh` - `previous_kwh_usage`) / `previous_kwh_usage`) AS `percent_change`

LEFT OUTER JOIN @ksen-g4gs AS @self ON ((date_diff_d(`month_date`, @self.`month_date`)= 365)
OR (date_diff_d(`month_date`, @self.`month_date`) = 366))
AND (`premise_code_account_number` == @self.`premise_code_account_number`)

ORDER BY month_date desc