This dataset describes the number and type of instances that the Community Engagement team provides internal support to other departments regarding community engagement and diversity inclusion best practices. Information regarding the employee who entered the data is redacted.

This dataset describes the amount of tax and non-tax revenue collected that is in the Collections Database. It redacts disaggregated protected fields pursuant to ARS 41-2003.

Filtering ERAP applications where funding was disbursed in the "ERAP 2" funding wave. Sums total unique households, individuals, rent/utilities/total $ disbursed. Used for the ERAP Summary Dashboard https://data.mesaaz.gov/stories/s/drz4-3caq. See SoQL query for details.

This view filters park ranger contacts where Location is NOT null.

Log of SMS text reminders sent to customers for upcoming scheduled Solid Waste service. Customer phone numbers in the From Number and To Number fields have been redacted. Only the city phone number used for these notifications remains in either field.

Businesses operating in Arizona that are unlicensed or licensed and are either delinquent or have under reported tax and after research and contact with the business are found to be liable for transaction privilege tax (TPT) or use tax and are brought into compliance through a desk or field assessment.

This view redacts disaggregated tax data protected by ARS 42-2003.

This view aggregates actual, previous and target energy usage in kWh for City buildings (where Site Type = Building) and calculates the percentage change.

month_date,
sum(`kwh`),
sum(`previous_kwh_usage`),
sum(`target_kwh`),
case(`sum_kwh` > 0, (`sum_kwh` - `sum_previous_kwh_usage`) / `sum_previous_kwh_usage`) AS `total_percent_change`,
case(`sum_kwh` > 0, (`sum_kwh` - `sum_target_kwh`) / `sum_target_kwh`) AS `target_percent_change`

WHERE `building_flag` = 'Y'

GROUP BY
`month_date`

ORDER BY `month_date` desc

Summary of revenues assessed. This dataset redacts confidential information protected by ARS 42-2003. Access to employees is granted upon the Tax Administrator's approval with a valid business case.

This view filters on US Census variables for field of bachelor degree reported for Mesa and other local comparison city's and Maricopa County. The American Community Survey (ACS) 1-year Estimates are source of information. For grouping of Majors Into Broad and Detailed Fields, see Appendix A at https://www2.census.gov/library/publications/2012/acs/acs-18.pdf

Science and Engineering include:
Computers, mathematics, and statistics
Biological, agricultural, and environmental sciences
Physical and related science
Psychology
Social sciences
Engineering
Multidisciplinary studies

Science and engineering related includes nursing, architecture, math teacher

Arts, Humanities and other include:
Literature and languages
Liberal arts and history
Visual and performing arts
Communications