Monthly summary of electric energy used by all City facilities. Use is measured by (kWh) by facility. 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.

Energy usage by City facilities for current and previous year (same month, prior year), calculated targets for reductions in energy consumption and progress toward achieving (% change). See the Attachments section below for SoQL used to create this view.

Monthly summary of electric energy used by all City facilities. Use is measured by (kWh) by facility. 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.

Monthly natural gas consumption data in Therms by Rate Classification (i.e. Residential, Commercial, Other Public Authority, Interdepartmental) and customer counts within the City of Mesa natural gas service territory.  Consumption totals are for the month in which they are billed to the customer (“Billing Month”). Due to the constant reading of utility meters throughout the month, much of the consumption occurs in the month prior to the Billing Month.

Monthly summary of electric energy used by all City facilities. Use is measured by (kWh) by facility. 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.

Monthly electric consumption data in kWh and customer counts within the City of Mesa's electric service territory broken down by Rate Classification (i.e. Residential, Commercial, Other Public Authority, Interdepartmental). Consumption totals are for the month in which they are billed to the customer (“Billing Month”). Due to the constant reading of utility meters throughout the month, much of the consumption occurs in the month prior to the Billing Month.

Monthly natural gas consumption data in Therms by Rate Classification (i.e. Residential, Commercial, Other Public Authority, Interdepartmental) and customer counts within the City of Mesa natural gas service territory.  Consumption totals are for the month in which they are billed to the customer (“Billing Month”). Due to the constant reading of utility meters throughout the month, much of the consumption occurs in the month prior to the Billing Month.

Trash, Recycle and Green Waste barrels placed out for collection by residents and businesses are collected weekly as scheduled.

View based on Energy Resources - Gas Master Meters and Regulator Stations Maintained.
This dataset tracks the number of gas master meters and regulator stations that are inspected and maintained on a monthly basis to meet the system’s regulatory requirements and needs.

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