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.

Aggregated and summarized information collected from the Point in Time count of the number of persons experiencing homelessness in the Phoenix-Mesa metro area as of the survey date. Detailed results for Mesa Only at https://data.mesaaz.gov/Community-Services/Unsheltered-Point-In-Time-PIT-Count-Details-Mesa-O/efjd-c5mi
Due to the unprecedented COVID-19 pandemic, the US Department of Housing and Urban Development (HUD) approved the Maricopa Regional Continuum of Care to opt out of the unsheltered Point In Time (PIT) Homeless Count for 2021. Every January, volunteers and outreach teams from local communities collaborate to survey and count the number of homeless. persons in their respective locations. With the information provided by the PIT Count, the Maricopa Regional Continuum of Care and local communities can determine how best to address homelessness. For more information see https://www.azmag.gov/Programs/Homelessness/Point-In-Time-Homeless-Count. NOTE: The HUD definition of chronic homelessness is: (1) a person who lives in a place not meant for human habitation, Safe Haven, or Emergency Shelter, (2) has a disability, and (3) has been homeless continuously for one year OR four or more times homeless in the last three years, where the combined length of time homeless is at least 12 months.

Information about the number of Fire/Medical incidents per 1,000 residents. Annual population estimates are found at https://citydata.mesaaz.gov/Census/City-of-Mesa-Population/89tz-2g4j.

Information about the number of Fire/Medical incidents per 1,000 residents. Annual population estimates are found at https://citydata.mesaaz.gov/Census/City-of-Mesa-Population/89tz-2g4j.

Filtered view of site energy usage for Drinking Water Treatment & Distribution site types only.

Filtered view of site energy usage for Water Reclamation site types only. Also known as Wastewater Treatment site types.

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.

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

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