Police calls for service dispatched as drug related

This dataset was created to be used by Performance Measure "Total Building Inspections per Month" and has redacted sensitive information including inspector name. The complete Inspections dataset is located at https://citydata.mesaaz.gov/Development-Services/Inspections/sqxq-7rdw

This dataset represents the total number of individuals educated and engaged through Community Engagement initiatives.

This dataset redacts sensitive information including employee names and comments which may be sensitive.

Information about program attendees between all program age groups and all branches. This public view redacts employee information.

New specialty licenses issued, and specialty licenses renewed. This public view redacts sensitive location information.

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

The list of sewer lines that are cleaned and/or inspected by month. Includes the location and 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.
*Redacted the exact date of the work because the cleaning/inspection may result in leaving the lines open to the air longer than expected.
*Redacted location, latitude, and longitude to protect employees and the infrastructure.

Access counts for Open Data Portal (assets where the URL includes the domain data.mesaaz.gov)

This dataset includes data on how all datasets, stories and derived views (tabular views, visualizations and measures) on a domain are being accessed by users.

The following usage types are included in the Access Type column:

• grid view
• primer page view
• download
• api read access
• story page view
• visualization page view
• measure page view

Usage data are segmented into the following user types:

• site member: users who have logged in and have been granted a role on the domain
• community user: users who have logged in but do not have a role on the domain
• anonymous: users who have not logged in to the domain

Data are updated by a system process at least once a day.

Please see Site Analytics: Asset Access for more detail.

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

Accidents or incidents that have occurred within the Environmental Management and Sustainability department in the current calendar year. This public view redacts fields that are deemed sensitive or protected including Chargeable, Incident Summary, Name of Employee and Notes.