Solid Waste Accidents and Incidents - Public View

citydata.mesaaz.gov | Last Updated 25 Sep 2019

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.

This dataset has the following 16 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Row IDrow_idtextSequentially generated unique ID of accident or incident. Not part of source system
Incident Dateincident_datecalendar_dateDate of the accident or incident
Incident Monthincident_monthtextMonth of the accident or incident
Incident Yearincident_yeartextYear of the accident or incident
Incident Typeincident_typetextType of accident or incident
Preventability Ratingpreventability_ratingtext**Sensitive - not for public access, city employee access permitted. A rating of whether the accident or incident was preventable
Vehicle Typevehicle_typetextType of vehicle involved in the incident or accident
OSHA Recordableosha_recordabletextRelated to injuries of employees and if that injury qualifies as an OSHA recordable injury. This is used quarterly by Safety Services & the Safety Coordinator
DocuSign Sent/Datedocusign_sent_datecalendar_dateDate the Incident Report was put into DocuSign. (Online signatures for Investigator (Foreman), Safety Coordinator and Employee to digitally sign the Incident Report once the incident has been rated.)
DocuSign Signed/Datedocusign_signed_datecalendar_dateThis signifies the completed date after all persons required to review and digitally sign the Incident Report have done so.
Preventable Accidents Flagpreventable_accidents_flagcheckbox**Sensitive - not for public access, city employee access permitted. Indicates if an accident is classified as preventable vehicle collision
Preventable Property Damage Flagpreventable_property_damagecheckboxIndicates if an accident was preventable property damage
Work Related Injury Flagwork_related_injury_flagcheckboxIndicates that incident or accident resulted in a work related injury
Preventable Accidents Enumeratorpreventable_accidentsnumberThis field equals 100,000 for every time the Preventable Accidents Flag is set to ‘TRUE’, in order to calculate the performance measure
Preventable Property Damage Enumeratorpreventable_property_damage_1numberThis field equals 100,000 for every time the Preventable Property Damage Flag is set to ‘TRUE’, in order to calculate the performance measure
Work Related Injury Enumeratorwork_related_injury_enumeratornumberThis field equals 200,000 for every time the Work Related Injury Flag is set to ‘TRUE’, in order to calculate the performance measure