histories. part of this product was collecting the history of photographs of this person over the years so that you could see what they looked like in 1995, what they looked like today. that is enormously important in the task of identification. there is just a myriad of facts, figures, what is in someone's property, where they were housed in the jail, who they're known associates were, who visited them? that could be available either suitor or later. incident reports could be available to all the agencies. searchable, secure, easy to access. the efficiency that are so close are so tantalizing because it will change how we do business in san francisco, where

we relied on paper and pencil, and in some cases we still do, we will no longer be doing that. does that answer your question adequately? supervisor mirkarimi: i think it paints a forward-looking victor. i think everyone is getting that and has been hoping for that. -- picture. >> if you need more specific information on how the sheriff's system has impacted us, i have brought capt. kathy gore would here, who worked on the project, but commanded the bookings for a number of years and is expert. i would also offer any member of the board of supervisors who would like to come to county jail one and see what a booking looks like, how our processes have changed, i would be happy to set that up. supervisor mirkarimi: i would and courage that. i have done it, i'd not know who

other has, but it is an important port. colleagues, would you like to ask for a question? supervisor cohen: i do not necessarily have a question for you, but i wanted to ask linda a couple of things. this is actually just a point of clarification. i want to make sure i heard you correctly, the police department is not on board with this -- participating in this technology? >> the police department has the greatest challenge right now because they have a very large work force in a city-wide implementation. i think the police department is here if you want to talk to them. i think the challenge is, they have had multiple chief changes, multiple cio changes. they need to look at what had been delivered and figure out what will work for them. there are things like incident

reports that they need. the bookings module that the sheriff's department talked about. if the players were able to implement that, city wide, it would make their work and the sheriff's department easier. supervisor cohen: so answer is no. you did a great job blowing out where you would like to be in the next six months. public defenders of that, so on and so forth. within that six months, is sfpd also is part of the plan? if not, do we expect them in the first quarter of next year? >> cio sfpd. we are fully on board with the plan. what we have done is, we have tried to build upon comstat, the data warehouse brought in by chief gascon. we have recently automated our report and have put our data

within the police department online. we are working to improve that by creating a better front end, the information that police officers enter into the system, that it better. think we have looked at the criteria and we think we can port are dated into the hub by october or november of this year. supervisor cohen: a question for, i think, robert. the tech guidy. i know you are familiar with the challenges we have been basing battling the budget. frankly, the challenge that we are going to have in the upcoming years. i am sure you understand the sentiment of some of my colleagues and their concerns to the quality -- maybe quality is

not the best word. technology. is this technology that we are working with, is it a credible? is it something that we can build upon? at new technologies come to market, will they be compatible? >> you are asking, i feel, a three-part question. there is technology for the individual departments, technology for the integration hub, and then there is the hardware infrastructure. speaking to this first, that is one of the more expensive components. it is expensive to upgrade. one challenge for delivery is that we've had the hardware for three years. 30 blades on a blade

architecture, and storage network area data. i have only connected three or four blades out of 40. without this, i can't move environments around. with the oracle software technology moving to software support, we are using citrics, and vm ware. this is what we are trying to do. a virtualization model. i can't create virtual machines. i don't have the resources

justice owns. i am not connected to the hard drive. the hardware side is expesnive. on the middleware side, we have followed the upgrade path. when we strted with justice years ago, it was oracle version 8 and 9. now we are on 10 g and want to move to 11. we are folowing lowing the upgre path. i said we had done the study to see the technology for dt.

i was leaning to ibm. oracle has been acquiring the best intergreatioation technolo. oracle, there are no regrets on the technology side. >> one last question for linda. it is daunting to have this huge project. i wonder how long it takes to train people. what is the time investment to train people up and operational?

>> we went from four to tsix. -- to six. they were in the department. we will offer this because we have a complete set of technical skills. rob, do you want to talk about the treaty? >> whe nwe go oun we hire new st is the legacy mainframe data side. they are both trained on the legacy mainframe. when we add to the staff, it is unlikely we find somebody who understands the criminal justice sphere.

but i can get oracle fusion or oracle business. it is a 6-8 month process. that technolgoy person understands a booking and a raimi warrant and the principles of a release and what makes up how booking turns into a filing and a court-scheduled event. we are trying to hire people of immediate value. and then me and my team, i've been with justice for 5 years. we have a handle on how the criminal justice system works.

supervisor campos: thank president chu for letting this come forward. and all of my colleagues. i want to thank linda young for stepping into a difficult situation. this is the subject of much frustration on the part of the board of supervisors. any time we talk about justice, it is a difficult situation. when i was a deuptputy city attorney, i worked on this

contract. to be honest, i appreciate the difficult work but i am not confident we are where we need to be. you want to get to a place where there is more clarity. a number of basic things. the budget is one of them. i think it will be hard to stick with a budget if you don't have a full grasp.

the target amount of money. and there has to be a provided timeline. there has to be an end goal. and specific targets for various tasks. and you need to provide the board with a clear assessment of where each agency is. in terms of their ends where this needs to be done. the finger-pointing is not direct but it talks about what others need to do. my goal is to be in a situation

where we have a clear path to follow. and there is no chance to point fingers. i don't know if people are doing that intentionally. i don't think we are where we need to be. it was unrealstic to think this would happen so quickly. we have the specific agencies because to the extent we talk about an agency not doing what needs to be done, we can hold them accountable. i also don't think it is fair to expect that this project was going to succeed or not succeed

based on the involvement of one agency. this is a monumental task. and the sheriff's department did the best anybody could do. how do we get to the path that gets us to an end date. i don't think we are there yet. one thing i would ask the administrator's office is to step back and look at the internal capacity. if you have the needed staff to do what you need to do. the coordinatonion is the key to

making this work. i do not know if you have the staff to do this, but additional staffing may be required. there may be a need for additional expertise that is brought in. one of the objectives of this project is to make certain that we do not rely on the outside vendors. we have to have a better assessment of this. and we have where each agency is, in regard to the project. and unless those things happen, you'll get a lot of criticism

from the supervisors. this is a chance for you to regroup, to augment the work you have already done. in terms of the project management, i see many of these projects in my life and these have the capacity to go south very quickly. it is time for us to change course and we are headed in the right direction but i do not think that we are at where we need to be. >> this is well said. i just want asked about how this dovetails with the anticipated obligations on prisoner realignment, in particular. the state has moved forward and what is part of the budget signed by governor brown, we see

our responsibilities amplified in anticipation of us being able to manage an infusion of populations. can someone help us? we will need the most up-to-date information and they will be able to help us to process the inmates returning to san francisco. >> i cannot speak exclusively for all the other a city partners that will have to deal with this particular issue. but from the court's perspective, this is another element of our case management system. we will have to modify this to meet our obligations. probation is the lead entity but there is an element in the sheriff's department and perhaps he would like to speak on this. >> we understand that there are many moving parts to this, with

how we deal with prisoner realignment. this is an example of, are we ready in the best way that we can possibly think to be able to handle this responsibility. >> this is a great question. from the sheriff's point of view, we will have many more people coming into our custody, but by the time the first phase in realignment is finished, and we stabilize the jail population, realignment will not only increase the jail population but it will change the nature of the jail population. we will go from being pretrial with people in custody for a short amount of time, for the most part, to a much more sophisticated level of prisoner

for us, because the system is finished. having this system available to us with the enhanced ability to classify prisoners appropriately, and identify them and move them, we are in very good shape. what will be so critical and i do not know if anyone is here from adult probation, but what will be critical is the exchange of information between the sheriff's department and adult probation. and the reentry and out of jail into adult probation programs. it will be extremely important that the adult probation be up and ready to be hoped. >> this is part of the assembly line process. is anyone here from adult probation? i know that there were not

expected as part of the discussion but i will make a public source announcement. we will have a hearing on realignment. there has been progress since the last hearing, and we will make certain that adult probation -- that they're here for that. this is not a question of if or when any more. is there anyone else that you would like to bring up? >> i do want to recognize beverley upton, who is from the domestic violence consortium, and the advocacy that you and your coalition partners have made over the years. if there are any comments that you would like to make i would like to give you the chance to make them. i of the advocates have been waiting very patiently for over 10 years for this, and if you

would like to comment on this i would like for you to do that. >> thank you, members of the public safety committee. i always start with a 2002 article that ran in the chronicle. we talked about the cry for justice. this is in 2002. this is all in your packet. y'all have this article. there have been some lessons learned. when we all stood in shock after the killing in 2000 and mayer brown said that the city is going to implement justice, i think he had all the best intentions but we had no idea what we were in for. we did not know that our systems

were not able to integrate, and technology has spent a lot of time in the 1970's and 80's not integrating itself. and i don't think anyone at that level in the mayor's office recognized with the challenges would be. has this taken too long? yes. having sat now, as a public representative in the government body for this project, i can see how the leadership of the sheriff's department particularly -- and now, the city administrator's office and before that, at least have really pulled this project forward. but we still have issues. i think that there are real concerns about everyone being at

the same pace and the same level. the suggestion from supervisor campos that we have a project management model which shows us, that everyone is at this level, so that we can see where the departments are. the sheriff's department is ready to go. probation almost ready to go. and maybe on a monthly basis or every other month, those at that level should be analyzed. it was so sent the way that supervisor campeau's put this up. i also -- it is concerning to me that we have also watched the slow dismantling of the mayor's office of criminal justice.

when you look at the original place for this, this was populated by knowledgeable staff. when you look at where we have gone to where we are right now, just bringing in paul henderson to help with criminal justice for the mayor's office is a step in the right direction. but if you look at the home of justice and you watch the slow motion dismantling over the last 12 years, you can see that we have -- three mayors, three district attorneys, and i can count three or more of -- when i put fred into the mix we have four police chiefs. a cost of home -- this has not had. there were some real problems

but since we have reconvened, especially with the support of the administrator's office and the leadership of the sheriff's department, and the ongoing oversight and questioning and challenging from the board of supervisors, we are going in the right direction. if so happy to see the time lines being talked about today. if we could have the police department data in by november, we to get these other estimations to come through, for the six month and the 12 months, the progress reports -- which could be in good shape. >> as we just mentioned, we are talking about prisoner realignment. we were just doing the calendar and we think that this is fiber six sheets.

-- police chiefs. there was fong, gaston. >> and now, sir. >> i think this happened when fred lau was the chief. we are at five. i think that the community has been one of the most stable forces at this table. you have my commitment that we will remain so. >> would like to go to public comment? there have been some very vocal department heads, and silent partners. we appreciate all the work that has been fostered the guest of the next step. we very much appreciate you being here today. if there is anyone here who would like to add to the conversation, public comment is

now open. >> i am of san francisco resident and i wanted to attend this meeting on public safety. i want to thank the people who came here today. any discussion of the criminal justice that a base has to include discussions of ongoing misconduct within the san francisco police department, which puts ethical officers at rest. the fact the city attorney has had to throw out 120 cases because of misconduct literally defines a dysfunctional police department where the officers and citizens are made vulnerable. but we, the citizens, our

complicity in this if we do not demand reform. i made a difficult decision to foul a complaint about a police officer and this is the first time in my life that i have the miss. this was after a lieutenant who had defrauded myself and the city and county of san francisco in a contractual agreement the tinted to harass and intimidate me when i asked for him to meet his legal obligations. i had an additional reason to fear him, after he attacked a man outside the precinct. the enraged officer had removed a suspect from booking. and he had escorted the man from the building. he made him lie in the back of a police car, striking him in the face hands and torso, and told the other officers the man had the other officers the man had fallen down and ask for them to