Doesnt go into justis then . No, it goes through justis. The way it works, technically we are sending the data to justis and technically justis can share it with anybody. But procedurally we are requiring before justis shares it with any department, we want an agreement with that department so we know who is looking at it, what it will be used for, etc. So that he with the District Attorney we basically provided the entire dataset. Supervisor yee are you working on other agreements with different departments at this point . Not yet. As rob mentioned, some of the departments are changing to a new system, but as they do, and they want to receive like for example, the courts. So, we are in discussions with the courts about them receiving our citation data. And once we get a little bit further along well be writing an m. O. U. For that. Supervisor yee ok. Thank you very much for your presentation. And i may call you up again. Next person to present would be maria mcgee, principal analyst of the crime Strategy Unit of the d. A. s office. Maria. Thank you, supervisor yee for calling a hearing on this important topic and thank you to the committee. District attorney is committed to using data to make our city safer and we appreciate the opportunity to highlight the role that data plays in the context of Public Safety. As a principal analyst for the District Attorneys office this topic is very near and dear to my heart. I think we can all agree that these are among the most important criminal justice issues facing San Francisco today. I think we can also agree as supervisor yee stated that data is essential to addressing and understanding these issues. Justis data is an essential tool for effective policy making, also a tool for Crime Prevention and crime fighting. And yet if you were to ask the Public Safety departments in San Francisco today if we can provide the data to answer these questions, i would say that we cant. We cant answer the question of how Law Enforcement is addressing quality of life crimes, we dont know how many citations are issued in San Francisco, to whom, where, and for what crimes. Are we keeping Domestic Violence victims safe, we dont know. We dont know how many 911 calls for d. V. Result in arrest and how many result in prosecution. We currently cant tell you what the driving Racial Disparity in the criminal Justice System, because we cant measure the disparities. And lastly, we dont know if any of our interventions are working because we cant measure our rate of resievetism. Or can we . I think you have heard today we kind of can. While the systems are not in place to answer the questions, the data and the infrastructure exists. Each of our agencies has a lot of the data to answer these questions. So how do we do it . With justis. In 2008, justis vision document and project charter identified the goal of justis to provide ex spa oh expanded to support critical Decision Making. Nearly ten years later through the excellent justis project team we have made significant progress in terms of exchanging data. Public defenders office, District Attorneys office, adult probation, and others have benefitted. Thanks to the leadership of chief scott, facilitate crime Data Warehouse data with the crime strategies unit. Justis also developed a booking notification system that helps address the information overload and inefficiency so those know when a suspect is booked into custody almost immediately. Exchange of data is essential to everyday operation, the capacity to use the data in meaningful ways is equally important. Increasingly this kind of data is also necessary to obtain grants and philanthropic resources for the city. Its time to invest injustice to achieve our full potential. We need to make justis more than a project, it needs to become a Permanent Program so it can support the Decision Making in an ongoing manner. Need to invest in justis to build a Data Repository so that meaningful data is readily available to support Decision Making. We need to integrate s. F. P. D. Incident and citation data and emergency calls for service data so we can tell the story of crime and our systems response to it from the beginning to the end. Our office asks the committee to consider the following. Call on the justis Governance Council to achieve the goal of building an integrative justis data system repository, with the reporting capacity within two years. Call on the executive sponsor to report on the councils progress on a quarterly basis. Thank you to the committee for your time and attention. And the Governance Council consists of the different departments, is that the Governance Council . Yeah, representatives from all the Law Enforcement and Public Safety agencies and representatives from some other agencies, including the department on the status of women, the Mayors Office, the department of technology. And the reporting relationship, rob, you report directly to naomi kelly, is that how that works . No, supervisor, i report directly to ken bakowski. And ken reports to who . The city administrator. Supervisor yee miss mckee, when you talk about investing in justis, what does it mean . Well, ive had the honor to work with this great team of programmers for almost ten years, i used to work for the superior court and now at the District Attorneys office and they are incredibly talented, very knowledgeable, and have done a lot to share the data. So, as discussed previously before 2009, data was not being shared. We were all accessing c. M. S. , like very scary looking black and yellow screen where you have to write code to get any information. So we have advanced a lot in terms of sharing information that helps our Business Operations on a daily basis but they dont have the resources to build a Data Repository where we can take the data moving back and forth and integrate it, and tell a story. Whats happening. How did this person go from being arrested to being convicted, to being placed on probation, to getting rearrested. We dont really have a way to answer those questions very easily. And its totally within our power and ability to do so, we just need resources. Ok. Thank you for that answer. Mr. Castillia, when if in order to have that integrated system up and running more efficiently, and i ask the question what kind of resources, what would it take to get that done . Right now justis does not do a lot of the crime analytics that ray was mentioning. So, right off i would say some additional programming and like i said, they serve dual roles, business analysts. Its hard for me to answer that question quantifiable because so many of the Department Data requests go directly to the mainframe staff that maintains the cable three mainframe. I dont have an accurate gauge of the amount of new reports that are requested on a monthly basis. The amount of reports that need to be modified on a monthly basis. It would be my assumption, however, that if it was brought within justis responsibility to do those reports, we make use of the state of the art Oracle Business intelligence tools. Once justis was to take over reporting and make them available, one of the benefits is the selfservice component, where the departments would no longer have to submit requests to change reports for this time period or to see a report with felonies only, versus misdemeanors only, and i think that would increase the departments native capabilities. Supervisor yee in this governance structure, when you meet, i guess monthly . Monthly. Supervisor yee is this discussed at all . It is. There is its been separate from the actual Governance Council meetings, but there have been working groups i mentioned in my presentation, facilitated by the office of the city of administrator. We are specifically focussed on reviewing the justis vision charter, talking about data sharing policies, m. O. U. S, so it is under discussion. Supervisor yee and how long would it take to do analysis of what it may cost . I would say i would need at least, at least a month, preferably two. That would allow me to work with the mainframe group to gauge the amount of just on the reporting side to gauge the work load so i can come back and give you a better accurate level of staff. Supervisor yee i would really appreciate that. I have interests, it seems ridiculous, not you personally, but the situation where it would be dealing with this since supervisor peskins first first im getting all wet. Supervisor yee so you know, i think many of us would really appreciate, you know, your help and everybody elses help to see us move forward in a much quicker fashion. I dont want to be here for, you know, come to a hearing 20 years from now and say it has not been done. And neither do i, supervisor. Supervisor yee i want to bring up ellen hurst, does not have formal representation, but the chief of staff of the Sheriffs Department, but i heard this is, thank you for even being here. Its her last week on the job, and shes been involved with justis over a decade and i want to ask her a few questions about your experience and what you think is needed to move justis into the next phase. How much time do you have, supervisor . I first became involved in the justis system in about 2001, 2002. First i want to clarify one thing. The number 52 that you mentioned, that was the number of people that were assigned to implement the citys Human Resources data system. And by contrast, justis has never had more than 6 and 7 including rob. So, the original vision and charter of justice was a response to trying to replace the c. M. S. Mainframe that you are hearing so much about. That is the Court Management system. The departments who all shared access to that system got together and knew that this system that was installed in 1968 was antiquated, could not give us what we needed, and they began talking about how we could come together and work this out. The vision of justis is that each department will have its own Case Management system that is responsive to its specific needs, and that would be connected through the justis hub. There was an agreed upon project plan and there was a consolidation of the justis budget so that all the money that was going to be spent by individual departments on Case Management systems, as well as the construction of the hub, were all in one pot, in general city obligation, i think its called. The executive sponsor was the head of the Mayors Office on criminal justice. A party that had no particular agenda in the game other than to get the system up and running. Unfortunately, under the newsome administration the office was dismantled. Slowly cut and then disappeared. So justice was left without an executive sponsor to drive the system forward. We were fortunate that the controller at that time, ed harington, had a very strong interest in keeping things together and myself, the previous project manager, and a consultant who was working with us literally begged the City Administrators Office to please give justice a home in the City Administrators Office. And if i may interrupt you, why did you not try to affiliate with department of technology . For two reasons. One reason was that when justis lived in the department of technology before the Mayors Office became the executive sponsor, it never got priority. We went through a rotating cast of heads of department of technology who saw their priorities and interests elsewhere. And so justis was always the last thing that they addressed. And the second reason has to do with governance. The department of technology was to provide technical support. Technical staff. Technical expertise. And when we thought about it, we thought it would be much better for d. T. To be treated as a vendor with the executive sponsor and justis as their client. So that we would have more ability to work order money, demand that the money be spent the way that the justis council had determined it should be spent and a vendorclient relationship rather than just being one more project in d. T. s huge organization. So, that is why we set it up that way. Eventually even that was not the vendorclient relationship was not going too well, and so the staff that was working on justis was moved into the City Administrators Office. So thats how that came about. In other words, the 6 or 7 staff used to be d. T. Staff and then they became justis staff. Yes, thats right. So since that time we moved forward. The Sheriffs Department came online and got connected to the hub, the District Attorney came online, got connected to the hub, the public defender, their system up and they are connected to the hub . Yes. Also in oneway relationship, data only feeds out to the p. D. And not back from the p. D. , same as the d. A. Or at least thats what that chart showed. No, supervisor. The chart i had and i did not spend much time on it, shows a bidirectional connection from the Public Defenders Office. Very little data that comes out of the Public Defenders Office but it is critical, public defender assigned to the case, added or deleted the public defender really no longer has a dependency on the cable mainframe because of the connection with justis and the successful implementation of their system. And thats the direction the d. A. s office needs to go. And the direction we anticipate we have started working with the d. A. s vendor, their new Case Management system vendor. We have outlined how my team has the integration method with the Sheriffs Department, like i said, its near realtime subsecond. Bidirectionally, and thats how their new system will come up, its exactly how the court system will need to be. We have started working with the court vendor as well, and i anticipate that will be the case with adult probation. Ok. So, i want to speak a little bit about the Governance Council structure. The Governance Council is defined in the administrative code, i forget the citation but its in there. And it is intended to be comprised of the Department Heads of the criminal justice agencies plus the department on the status of women, and d. T. , or their is your surrogates, somebody who can make policy decisions. And that governance is supported by the technical steering committee, robs group, who provide the technical expertise, advice, etc. , to the Governance Council. Over the years those two functions have been mushed together so now the Governance Council is largely made up of technical people so we are not having those policy discussions. We also no longer have the consolidated budget. I am not i was gone from 2012 to 2016 so there was a period of time where in is completely opaque to me. But at some point the consolidated budget during that time was abandoned in favor of giving each department their own i. T. Budget back. On paper that sounds good because it sort of implies greater autonomy among the departments, but the fact is that now justis has much less visibility into what each department is doing. To my knowledge, justis never dictated what Case Management system a department should buy. They were there to help them implement it. And so what has happened now is that there are Case Management systems going out to bid with no project plan in place for how they are going to get connected to the hub once they are up. So if you were to ask me, i think a return to the shared project plan and the consolidated budget would help a great deal. And that consolidated budget was an appropriation to the city administrator for justis . I believe so. It was a separate item within general city obligation that could only be spent on justis and the city administrator was the entity that administrated that budget. Supervisor yee ill ask some of the departments later about this question about whether it makes sense to bring it back to consolidated budget. I mean, logically, it makes some sense to me, but i wonder what the arguments are for sure, that makes sense. Supervisor yee anything else . If i may, supervisor yee, this is a little bit of, i think, a governance conumdrum. Over time, and maybe arguably from the beginning, justis has kind of been orphan child and it needs a level of authority over these departments so that the Technology Works seamlessly and the d. A. Is not off buying one system that after the fact, Great Technology experts have to, you know, do a work around, fit into the system. So seems to me that, and i understand why you didnt go to d. T. In the beginning because you were a stepchild there, and then you became an orphan child. But it seems like it needs to have some amount of cent