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.

This data set provides information about work performed on Transportation assets such as street inventory, street lights, traffic signals, signs, and pavement markings. Data are stored on Cityworks servers.