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

Water consumption data by service account, also known as premise, for the last 14 months. Please note that some large water customers may have more than one service account (for example Mesa Public Schools and Gilbert Public Schools have multiple Premise/Service Accounts). This dataset includes redactions to protect customer privacy. See Redactions and Definitions in the Attachments section for more information.

A randomized premise code was generated to uniquely identify each service account across all 14 billing periods. However, this premise code does not match the actual code used by customers or the billing system.

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

Number of Notices of Violation for Non-Title V and General air permits issued to the City of Mesa and managed by Environmental Programs.

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.

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

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.