Categorized them we dont want to call it a if one or two. Get on to the list thats how were handling that in terms of the data migration 63 items to be tested the report status again weve got that split within the 21 tech developing and dbi thats the status of that report in terms of concerns as weve discuss with the configuration item grown after the e d d rounds and subsequent retest weve got more time to address those items that is of concern thought project and the amount of work to be done we also since ive talked with you weve known when it went live avsh on september 22nd last year at that time, there was an estimates done three weeks needed once dbi was to go live three weeks to analyze and merger get the work done to merge the data before live since data is active in the system in that timeframe which sfm that discussion was made in september of last year there was the hope that dbi would be a few months hidden we know that didnt come live so the length of time the dbi has used the system the changes to their configuration since theyve gone live to continue to work with dbi has made the task of analysis of getting the merger done right thing to do so, now the current estimate a weeks we need to get a stable playroom for the Police Radios to begin thats a needed item to going going live and the last points weave talked a couple of meetings about performances and stability and the general Customer Service were ref from excel planning has performance issues and on our tests playrooms have experienced two outages because of the test please state your name and head of the Operations Team they came obesity and met request dbi they listened which is very good they were accepting and acknowledged the issues we let them know of Customer Services and support to and made commitments to make improvements on those fronts weve seen small improvements but they set the right level of people to talk with us and met the commitments were continuing to monitor. Affordable housing. Please continue. If you flip for the back of the sheet i know commissioner mccray i asked how do we know if were getting closer to done with the building and construction type of projects you typically what tell you were you are in the plans and construction how much is left i wish software were as simple but with software the thing that is differently different is that which you change software and go into a particular area of the code it often has impacts i choose they call the need to do regression youll have a single thing to change i want to not allow inspectors to be scheduled after 3 00 p. M. So youll make a change to put that rule in place if youve not been thorough and your testing at the Development Level then that could cause effects you might have broken someone else thats what they call regression you test the things around it to gain conversation the change i made hadnt disturbed anything thats within the big differences between Software Development and construction of a building with that said, just to give you a walk through of this chart this starts in july of this year and carries this is updated is as of this morning the height of the chart shows you the total number of defects and issues this includes the 127 that are configuration or functionality this includes which is the lighter blue bar this is 63 items this is the total from a you know how close to getting done we need to see in the graph this needs to trends down to doyle zero but so thats and so we we see the inspect it made the jump of the august trying and Early September that is e d e thats the subsequent testing and now the developers radio hard at work were asking cecelia to add more developers to get those things fixed to retest them and bring that back down so it is difficult to sfra a percentage but ill continue to publish this chart in a fwraf california where we are to addressing the defects. Commissioner mar. I had kind of a question about that the critical and high defects the first line seems to say this is 45 and the second line hundred and 27. Im glad to explain we had a backlog of defects and added on this that the 71 e d e and sense weve been retesting things as theyve been fixed people are testing it is not uncommon to notice Something Else so those get added to the log were very intents on making sure everything this is noticed captured they dont rank as step 1 and 2 but giving confidence to the users weve capture those things and as i said before we review them with tom to make sure were giving them the right priority. This is a followup to that question one when i was attend this its been a while since i went to the smaller meetings there was one complaint that came from the which was when they fix something dwoi staff raised something new now all the problems are out there i understand the unintended questions that come out using that example not until you right. You might see something you didnt expect we understand that the regression analysis but most of the stuff on the table most of problems. And id like to be able to say we have a high degree of confidence and e d e because we went through the major e d e that dbi glosses everyday that gives us confidence weve glutton this a scenario and uncovered the major areas ones those are fixed other things noticed that were not noticed before so we would expect to say this graph to come down and as were retest to find less and less thats the pattern but hard to guarantee or judge which well hit that point but it will be clear when were on the right trajectory. Thank you for this italianamerican im not surprised because of this going to the ends to end it is kind of the so. The test. Yeah. It gives us a broader picture in looking at the guy and cpc data merger extension is that going to get longer the longer this process takes or 8 weeks sort of the worse case scenario. Yeah. Ive not asked that question but if it grows it should be very struggling within a day or two not weeks and weeks. Okay. I think we need to know that i think that when we made many decision to do that it was assuming a closer yes. Go live period. I think are we learning tlipgz from that that are helpful we can actually feel good about that Going Forward with that part the planning going live before us are we learning from that. We are because theyre part of business is so different from dbi i mean that dbi has hundreds of times the volume of transactions in a given daywear not getting a lot of feedback that is immediately tangible to dbi the more the things that were getting are useful is just you know their cautiously they wished they would have are tested and their invoicing things since live that is that type of feedback caution caution make sure you do this. Okay. Thats great. Commissioner all thank you for your patience. Thank you. Im on the first page under the configuration fixes there were 71 above critical and high defects were found and 26 were fixed. Since yeah, since the august 25th we stopped did e d e. How long did it take to fix. You dont think i dont have the data. Many they went for the ones that were hell fixed. So if we got hundred and 27 more to go we pickup truck that by 3 days each or 4 days or a month. Thats you wouldnt want to give an average i have items that are literally change a lablg on a screen that is 10 or 15 minutes work but another item that is doing configuration of new objects those could take many days you cant really put a number on that and x plat but one good thing not one developer we have at the moment two configurations that are working on fyi those and hoping to add more as they come available. Thank you just one question i dont the platform you had glitches or shuts down is that universal to other cities at the same time or what the plan you are seeing. It depends on the nature of the other on this but the gavel to gavel and Planning Department for that matter are hosted which means those computers are the centers on the west coast and one east Coast Data Center that isolates those two groups but doovn the issues one of the issues during e d e a rotor problem that effected their data center those plants were not impacted by the rotor it sits in front of the system if none can get through the rotor the firewall nobody it assessing the system or slowing down people another issue with the e detector e the allergy i s system is hosted by planning please state your name if i cant valid an address not get a permit or create one or not schedule because the inspectors needs that address validation to it will not effect but that is localized for dbi okay thank you henry and shawn for your presentation here today. One more thing. Oh. And youre confident youre confident were getting the support we need from the vendors. Yes. Although were asking for more weve goes to got two configuration resources weve asked for quite a number of weeks to add Additional Resources they have 21 tech starting next week and excel their identifying the resources but the current contract that is going through review needs to go through the final oca approval before the start. The last thing. May not know this but from planning their problems are they getting solved. Because they had up and running since i think so there was was issues. The small ones they have a few longstanding items my counterparts in planning about tell you theyre not happy with the length of time getting the issues resolved one of them they generate invoices to builds for the planning reviews and there are on a certain threshold theyre not able to generate those invoices for over 6 months after going live theyve also had a longstanding issue with an ingratiation theyve paid for the share point to store lots of documents especially with the planning and making them assessable over the web that piece was positional for only the last couple of months. Are they able to invoice. Yes. Since a couple of months ago. But the hearing on dbi. Yeah. This is a joint i mean. Ankle as far as dbi and their fees and ability to collect them thats the a number one besides doing the inspections the calculations to collect those fees is job one. Okay. Were done thank you. Thank you very much hurp and. Public comment on item 6. Hello engineer want to compliment the presenters on the projects it is apparent it being merged professionally that is a rigorous examination of beginning processes and the capabilities identified hundred and 27 fixes that are necessary to go live but ill suggest strongly that as dr. Commissioner mccray was questioning we put hours we estimate the hours for each fix and measure that against the number of hours and Resources Available as good as the report is it is incomplete because we have no understanding as to when excel will be implemented thank you. Thank you. Next speaker thank you commissioners joe butler looking forward to both planning and building not only being in the same building but on the same database and having some accountability for permits issued without proper contractors licenses, permits that are issued without proper insurance. Permits into the weeds planning review but not made it across to the Planning Department i think those types of favorable treatments that certain individuals consistently receive receive are will have to go away which accountability in this system that the way 67 is now hundred and 27 and 240 by the end of the year but persevere it is important for all the city to provide for all its customers we pay our salaries were your customers thank you. Thank you. Next speaker. No is there any additional Public Comment and item 7 approve the minutes. March 16. Second and throwback is there any Public Comment on the minutes. Okay. Seeing none all commissioners in favor. All in favor, say i. I. Opposed minutes are approved pursue item 8 commissioners matters at this time the commissioners may ask the staff about documents and which are of interest to the commission. So my apologies commissioner walker to the Public Comment that came in regarding commissioner vietor that will be helpful if we could get an update on the backlogs i know we had that in the beginning youre doing a good job at chipping away how many backlogs and novs and how many backlog directors hearing so we know what we are dealing with thank you. Okay item 8 b future meeting and agenda at this time the commissioners can determine did items to be plaid on the next agenda our next meg a october 21st commissioner mar please. I know this is not total honest but i want to reraises the question of explorey whether were going another joint meeting about planning this is partially to discuss cecelia perhaps the decisions theyve gone live and get the february on that. As well as other agenda items which might have to do with permits whats a simultaneously and overthecounter and appropriate 0 those are my things i know that is in their court which usually is but commissioner president mccarthy and might have can have outreach to them again. Duly noted. Thank you. Any any Public Comment on item items 8 ab item 9 adjournment have a motion to adjourn. So moved. Second. There is a motion and a second all commissioners in favor were noting now adjourned 2 25 p. M. Thank you, madam clerk. Thank good morning today is september 24th, i am john avalos, i have with me supervisor supervisor Cohen Malia Cohen supervisor katy tang. Please turn off an electronic devices. Any documents can be submitted to the clerk. Supervisor avalos item number one. Consider the mayors appointment to the children youth and families oversight Advisory Committee. Please come forward and welcome. Thank you for your interest in the oversight committee, we want to talk about your interest in your experience in working with children from families. Im linda martin jordan, currently employed by unintelligible been in the district since 2005, began in the Elementary School working at diablo and malcom x. I have been at unintelligible high school since 2007. Decreasing the truancy rate. It was extremely high. Since 2009 i have been appointed to special project working with africanamerican families and in that capacity i have been able to develop ways for families to be involved and participating in voicing their opinions about what is going on in the School District and in particular in mission. I work with various Community Based organizations to provide services to their students and families. I am a choice that needs to be made for seat number 6, i just want to be clear about it. laughter . One thing that is in the forefront of my mind is how to develop a means to reach out into the community to find out their needs that we can address and retrieving the data. Once would retrieve the data whatever it looks like we need to have courageous conversations about what really needs to happen with the data that is what a kind of bring to the table. Supervisor avalos what is it data tell you in terms of how does the city need to focus on retention and students of color . Have been some how can i say this there has been a lot of headway addressing two issues of various ethnic groups in the city and outward migration and address that issue with the mayors staff unintelligible hired by superintendent carranza and those committees that are working that happen and i have been a part of those committees and i will continue to because it is needed but i work with all students but my focus is africanamericans now. Supervisor avalos how do you see the city advancing the efforts of the city . And also support your work and School District as well . I work across all School Platforms and desires, quality living, quality jobs, quality training, working with the other 10 members of the committee we can sit down and look strategically at what has occurred, what has worked and come up with a plan for how we can address these to make them better. Supervisor avalos are you a parent of a child in the city . Or have you been the parent of a child in the city . I am a grandmother. I know i look younger. laughter unintelligible i was a foster mom but they call me a mom because i claim all the kids at admission. Supervisor avalos thank you for your service and for wanting to be in the committee. I have some people that have come in to speak. Will open it up for Public Comment, no need for speaker cards. Any additional questions . Its good to see you. Many people whom i respect have called me a written me a letter with high recommendations for your candidacy. I want to acknowledge your leadership around my brothers keeper. It had a whole panel and the commitment of president obama is unprecedented and in a direction that we need to be moving in and we are delighted to implemented here in San Francisco at the local level, looking critically at education and the Mental Health aspect to ensure that we are creating and supporting these in mensa they will be successful so i appreciate your advocacy and being involved in that level and again like i said i dont know you personally but the recommendations speak for themselves and i will be happy to support you today. To make a comment, this past saturday our committee came together and vision was to have a black family day from cradle to career. We had 800 families present, students were accepted onsite, they received scholarship money and had workshops on everything from unintelligible and also we had giveaways and the mayor came, families were so pleased, they were so excited to be in the space with all of this going on. I heard the catering was interesting as well. One of my favorites. Also prior to this Committee Meeting speaking about the event last saturday, and that it was successful the mayor speaking unintelligible and make sure that this is come to fruition. Any questions . Supervisor avalos this is a hearing. The right choice has already been made by the mayor. The morning. My name is unintelligible i am the Program Manager of unintelligible in San Francisco speaking in support miss jordan. unintelligible linda jordans appointment to this would be very neede