This view has been redacted for public use including employee and customer information such as name, address and geo location. Information about the City's Surplus Program which disposes of city surplus property in a timely manner and capture best remaining value of these surplus items.

Information about tenants and businesses based at Falcon Field Airport. Redacted fields include contact information, employee counts and other internal notes, expansion plans, etc.

Aggregates current, previous and target energy usage for city owned facilities where site type = Drinking Water Treatment & Distribution.

SELECT
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 `site_type` IN ('Drinking Water Treatment & Distribution')

GROUP BY
`month_date`

ORDER BY `month_date` desc

This view redacts "Inquiries/ Tasks related to Advisory Boards and Committees," and "Projects/Tasks related to GOVQA software management." Monthly tracking of various services provided by City Clerk.

This view excludes employee information and extraneous detail from Cityworks that does not pertain to In-House Street Sweeping. This is a record of every work order captured in the Cityworks program pertaining to sweeping in the City of Mesa. By querying all of the work order records in order to find only the sweeping work orders and organizing by date, we are able to determine if every sweeping route has been revisited within one month.

A view that joins the summed expenditure amounts and the customer counts by month for Electric. Used for Performance Metrics.
Data Sources:
https://citydata.mesaaz.gov/Financial-Services/City-Expenditures/cmtm-9tuw
https://citydata.mesaaz.gov/Energy-Utilities/Electric-Consumption/efwv-ff2w

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.

This program is a residential utility assistance program that provides a 30% discount on the Water Service Rate, on their monthly base service charge. The customer must be 60 years of age or older, be a permanent full-time resident at the service address, and meet the Low-Income criteria defined by the Arizona Department of Economic Security. The program lasts for 5 years, and after 5 years the customer has to recertify for the program again.

Customer ID and address are redacted from this public view.

The list of sewer lines that are cleaned and/or inspected by month, including the number of miles cleaned or inspected. Inspections are accomplished with CCTV and acoustic technologies while cleaning uses a pressure washer to clean the inside of the pipe. The work is completed by City of Mesa crews and contractors. Contractor data is summarized. Location data has been redacted.

Number of cases closed, resolved, and written off each month and how many are still opened.

Collector name has been redacted from this public view. Access is available to certain employees upon the Tax Administrator's approval.