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.

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.

Confirmed cases of opioid overdose, locations are not actual but instead rounded to approximately 1/3 mile increments. Opioid overdose confirmed by 1) patient or witness verification, 2) Opioid found on scene or 3) positive response to Narcan treatment. For more information on opioid drugs see https://www.drugabuse.gov/drugs-abuse/opioids

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

Census tracts (version 2021) as supplied by the US Census Bureau clipped to Mesa city boundaries as supplied by the city's Geographic Information System (GIS).

Census tract files are found at https://www2.census.gov/geo/tiger/ and are updated annually.

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.

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.

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.