A Southern California Public Works Department faced difficulty in assigning government employees to clean up rapidly-increasing graffiti on city walls. StackMason provided comprehensive training for a custom-built application to combat the vandalism.

Client Objectives:

• Request work orders promptly
• Parse wording of graffiti to determine source
• Ability to transfer public work order to responsible party upon determination of source

Our Approach:

• Employed data analytics to isolate source of graffiti
• Standard cycle development utilizing agile processes
• Individualized project approach to gain complete understanding of system architecture

Results:

• Provided all user training
• Custom application to best address client’s business requirements
• Client successfully abandoned antiquated systems rooted in Microsoft Access
• Created enhanced graffiti matrix, empowering law enforcement to effectively maintain community areas