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

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.

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.

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.

Budget Book page.

Monthly summary of electric energy used (in kWh) by all City Buildings with an Energy Management System (EMS).

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

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.

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.