From Chaos to Clarity: A Legal Tech Transformation
- evelynlo1
- Jul 31
- 1 min read
Jonathan worked with the Attorney General’s Office of the Republic of Palau to transform their case management database from a single MS Access table to a robust relational database with added functionality.
The Office of the Attorney General in the Republic of Palau serves as the country’s primary legal
authority, responsible for prosecuting all criminal cases and providing public legal counsel. Jonathan Lindstrom, working with Palau’s Attorney General, Ernestine Rengill, completely reworked Palau’s criminal database of 30,000 records into a normalized, well-structured database with a new user interface and forms. In addition to this he added the ability to track civil cases, multiple parties per case, arresting officer and location information along with the ability to report statistics on misdemeanor and felony charges by fiscal year.