SLO County Veteran Services Recidivism

The group worked with the SLO County Veteran Services Office to analyze their current Veteran Treatment Court.

Our Team

Steven Alvarado

Research Lead

Steven is a senior manufacturing engineering student graduating Winter 2022. As a central coast native, he has developed a strong liking for the outdoors and enjoys exploring new hiking trails and natural landscapes. Steven plans to intern as a manufacturing engineer this coming summer and plans on returning to the central coast to work for a local manufacturing company.

Lilly Brown

Dashboard Design Lead

Lilly Brown is a Chicago-native graduating from Cal Poly this summer with a Bachelor’s in Industrial Engineering. She will go on to work for NetSuite in Austin this fall.

Team Member

Project Manager

Thomas Kim is an Industrial Engineering student and will be graduating from Cal Poly Winter of 2022. He is from San Diego and really enjoys the ocean and the outdoors. He worked as the Project Manager, coordinating tasks and meetings with their sponsor. This summer Thomas will be interning for Epirus as an Industrial Engineer.

Ryan Reynolds

Impact Analysis Lead

 Ryan Reynolds is a first year Industrial Engineering transfer student graduating in Winter of 2022. Although he completed most of his studies at Virginia Tech, Ryan has found a new home at Cal Poly as a mustang. With a wide range of interests in industrial engineering, Ryan focused on making sure the team was moving forward and staying well within the bounds of milestone deadlines, as well as providing occasional comedic relief. 

Acknowledgements

We would like to thank our senior project sponsor, Morgan Boyd, and our senior project advisor, Jill Speece, for their continued support and guidance throughout the senior project sequence. We would also like to thank supporting personnel of the SLO Veteran Services Office for their support. We also want to thank the SLO District Attorney’s Analysts for providing supplemental resources and support to help our team navigate the county databases.

Problem Statement

SLO County would like to improve the lives of veterans in the criminal justice system by giving them the option of treatment court, opposed to traditional court. However, the Veteran Service Office is facing a lack of efficiency with data storage and input.

Background

  • Veteran Treatment Courts (VTC) are an alternative sentencing program for criminal defendants that have served in the active military, naval, or air force services. These treatment courts help veterans with their conditions through rehabilitation and counseling. Veteran Treatment Courts are modeled after drug & alcohol and mental health courts. Treatment courts have proven to be effective year after year, helping their clients trace their problems to the root cause and giving them the appropriate treatment. 

Literature Review

The aim of the literature review is to gain context of the elements that cause inefficiency within the veteran treatment court (VTC) system, as well as spark ideas for potential solutions. Currently, there are 461 treatment courts across the nations that focus solely on serving veterans with a true goal of rehabilitation and compassion instead of blind punishment. Veteran treatment courts have improved homelessness, employment, crime rates, and relationships in many communities. As shown in prior research, the national graduation rates of treatment courts are right around 75%. Across the country, each VTC operates slightly differently, however most of the California VTCs follow an 18 month plan, split into four phases. 

Project Objective

Goals

The goal of this project is to improve effectiveness and efficiency within the SLO County VTC. In order to accomplish this, the team will analyse raw data to: determine the proportion of successful program participants, identify missed client opportunities, isolate and determine circumstances leading to client expulsion, and track recidivism rates on 1,3, and 5 year ranges after successful program completion. With a large data set, it is not expected to contain all pertinent information needed to answer every possible question. In conjunction with available KPIs, the analysis is expected to produce a list of program KPIs that would ideally be present. This will give stakeholders a great starting point to improve data collection moving forward.    

This project is sponsored by the Veteran Services Office in the County of San Luis Obispo, California.

Current State

The District Attorney’s office houses and access their data through SASS

After months of waiting for access and a few weeks of rigorous data extraction, a clear picture of the SLO Veteran Treatment Court developed. The data is collected by the court, which generates a lot of data not relevant to VTC with a few gaps. Luckily, the gaps were filled by files sent by the Probation Department. Developing a link between the two databases finally revealed the graduation rates. The data provided shows that of the 170 clients who were referred to treatment court, only 42 entered. This highlights a lag in the referral process and throughput. On a positive note, the data did show that 33 successful graduates, placing the graduation rate at 79%. As shown in prior research, the national graduation rates of treatment courts are right around 75%. A success rate that is above the national average proves the importance of this program, and the positive impact it has on the community. In order to bypass the need for  additional Probation Department data the team is currently pursuing the addition of a few additional event codes to the system that will allow for direct and clear indication of  program participant success. 

Solution Design

The solution designed was a PowerBI dashboard.

Process of Design

The implementation of Microsoft PowerBI in conjunction with the SQL Server Management Studio has shown promising signs of allowing the SLO County VSO to quickly make decisions based on current data available. The SQL server used by the SLO County Veteran Service Office is appropriately analyzed by SQL commands and filtered by case number and defendant number. By integrating the SQL server database into PowerBI, inferences can be deduced from the dashboard that has been created as a proof of concept. Live connections to the SQL database server result in continuous updates to the PowerBI graphs, charts, and other summarizing features. Early stages of the PowerBI application show great promise as SLO County Treatment Court program participants can easily be filtered on a yearly basis, and the number of program graduates can quickly be compared to the number of enrolled clients. The dashboard can be continuously kept up to date with live connections to SQL databases and can also be published for others to see and to make informed decisions with. The dashboard provides end users with a quick and intuitive way to look at the raw data as a whole and to be able to make decisions based upon patterns and other realizations made possible by PowerBI’s data analytics. PowerBI also provides high level encryption of the SLO County data that is very sensitive and protected. 

Root Cause

At the start of the project, the senior project group conducted a root cause analysis to determine the contributing factors to the inefficiencies in the SLO County Databases involved with the Veteran Treatment Court program. After several discussions with the project sponsor and associated personnel, the team determined that the two main contributing factors of inefficient data access are attributed to fragmented data within the county in addition to federal laws protecting personal client data. These two factors limit data access and as a result, affect the ability of SLO County personnel to extrapolate data to be able to analyze the data and interpret findings.



Impact Analysis

Graduation Rates – The dashboard summarizes graduation rates and allows users to filter by single or multiple years.

Heat Map – The heat map feature assists the VSO in identifying high-crime areas so they can find and support new clients in the system.

Recidivism – The dashboard also shows recidivism rates of those who did and did not enter the program. This is a key metric in determining program success.

Self-Sustaining- The dashboard has a live connection to the DA’s database, meaning that there is little to no upkeep

Next Steps

This senior project will be continued into the Fall 2021 Quarter and the project scope will be expanded to include dashboard refinement, Veteran Treatment Court referral tracking, and predictive models for those entering the SLO County criminal justice system. The dashboard will be expanded to include additional key metrics and key performance indicators and will be formulated to allow for the transition of dashboard maintenance to the Veteran Services Office personnel. The group is exploring options for future integration of platforms such as Adobe Sign to facilitate future referral tracking processes. Predictive models are also being evaluated to identify which key metrics will be needed from adjacent county organizations and illustrate the need for increased collaboration between SLO County departments.

Conclusion

Improvementsto be made if drivetrain were to be re-designed:

  • Optimize drivetrain’s size and weight by reducing the sizes of shafts and gears.
  • Utilize a smaller differential assembly to allow for smallergear sizing.
  • Utilize better material heat treatment processes to allow for stronger and smaller componentswhile still meeting the desired factor of safety.
  • Reduce the rotational inertia of shaft assemblies by slotting the gears faces to reduce excess material and weight.
  • Design and cast a housing for a more compact drivetrain unit.

Graduation Rates – The dashboard summarizes graduation rates and allows users to filter by single or multiple years.

Heat Map – The heat map feature assists the VSO in identifying high-crime areas so they can find and support new clients in the system.

Recidivism – The dashboard also shows recidivism rates of those who did and did not enter the program. This is a key metric in determining program success.

Share

Share on facebook
Share on twitter
Share on linkedin