This transformed view counts the number of current employees

This view includes a computed geometry value for use only by region map (applications by zip code) and redacts the City of Mesa Account number. Applications for assistance under the MesaCARES Utility Assistance program and awards granted under the program.

Filtering ERAP applications where funding was disbursed in the "Phase C-R" 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.

View grouped by unique restaurant name, number of meals and year.

This filtered view groups and sums parent dataset by Ethnicity and Year (2021) and shows the count and percentage of city resident ethnicity. This information is used by the "City Employee vs. Community Demographics: Ethnicity" filtered view at https://citydata.mesaaz.gov/Diversity/Chart-Data-for-City-Employee-vs-Community-Demograp/bt2n-zimw

SOQL created derived view designed to ensure the computed columns are pulled correctly and can be used to create region maps.

Material collected by City of Mesa Solid Waste department by service request and EXCLUDES materials collected by regular weekly pickup. Includes the type of container, commodity material groupings and net tonnage. For information about materials collected during regular scheduled weekly pickup see https://data.mesaaz.gov/Solid-Waste/Solid-Waste-Barrel-Tonnage-by-Year-Type/vemm-477m

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.

Comparing the percentage of city residents (community) ethnicity to the percentage of city employee ethnicity. Employee information comes from Employee Demographics: Ethnicity https://citydata.mesaaz.gov/Human-Resources/Employee-Demographics-Ethnicity/6kd3-uaks. Community information comes from Community Demographics: Ethnicity at https://citydata.mesaaz.gov/Census/Community-Demographics-Ethnicity/g34w-9rxw