Call for public comment. No public comment. Any comments from commissioners. Ill move for a motion to approve agenda items number 3 and 4. So moved. Second. All in favor. Aye. So, agenda items 3 and 4 are unanimously approved. Agenda item number 5. An informational presentation on new Ethics Commission data Dashboard Tools for the novembe. H. I good afternoon, commissioners. My name is tyler field. I am a Information Systems engineer. I just got a new title. Im here today to give you a brief presentation on updates to the data tools that the Ethics Commission provides. And if we can witch over to the computer, i want to first start with a quick refresher on the reporting and president came in finances reporting dead lines and periods and dead lines and throughout the year throughout the year, campaign communities have to present or have to file a form 460 with the commission thats a very tense, typically governmental difficult to under paper form and these are due at different periods throughout the year. I have a nifty little calender here. Showing the 2019 dead lines and ok. And reporting periods. For 2019, the first semi annual form 460 was due on july 31st and it covered januaro 30th and im sure i dont have to elaborate too much on the calender. You can see that were right here on october 18th and the last form 460 was due on the 26th of september which covered september or forgive me, jul. Do we currently know how much the campaign has raised or spent as of only the 21st of september and the answer is complicate but not really because we do know some Additional Information about campaigns or Campaign Committees fundraising and spending efforts during the 90day period before an election which started on august the seventh. And during the 90day per they have to file an additional report if they have to file an additional report if they spend or receive more than 1,000 and im bringing all this up to emphasize how the data dash boards used to present information in a way that mimicked the way that it was reported. Either in this dense 460 or on these additional late period reportings. But someone coming to our website wanting to know how much money is being raised or spent by a committee doesnt want to know how much was spent as of september 21st. Theyre interested in how much has been raised or spent as of right now. So, these dash boards and the improvements of the dash boards ive made are a way to receive that information. Im sorry, could i ask a question. Of course. So the 460 is a retrospective filing so you will the communities are reporting on funds raised and spent on a prior period so that would have been most recently september 21st you said. Maybe this is for mr. Ford, lets go to september 3rd like the end of the month or is there any particular magic to the dates that were picking . You are talking about the reporting periods for the 460 . Those are established by state law and theyre generally described as days before the election. Theyll say you have to file a report that covers the 40th day to the 20th day before the election. And, im not sure exactly what the calculus was that went into defining those periods. They were trying to make those that were progressively shorter as you approached the election. So the closer you get to the election. But of course under the state regime theres a big gap that is left since they only have two preelection reports and our new preelection report fills the majority omajority of that gap s another 460 that will get you 11 of the remaining 17 days before the election. Theres still a little gap thats missing but most of it will come in on the 460. Thank you. If we can switch back to the computer. Thank you. The dash boards are the way members of the public, press, interested parties come to our website to understand what is going on. If its very similar to the dashboard i presented to you in february. With some additions, like i said earlier, these were a representation based on the forms that were filed. This page used to show the 460 which is the latest accounting of or the most recent very thorough accounting. It would be the form itself or just the the representation shown on this page came directly from only the 460. Now its showing the 460 and those additional late period reporting added together so like i said when someone calls and says how much someone in this race, they dont care how much was in the race as of september 21st, and they want to have the most edition. This is the funds reported to us in one place. And money that has not yet had an opportunity to be reported same type of thing i have now done for the expenditures tab. This is money spent by committees. You can see independent expendituring by third parties and the money that the community has spent and late contributions made in support of committees. I just want to reemphasize they make understanding the current elections camping finance easier in real time. And, moving over to come neat new features and im switching to the running sums tab that shows a running some overtime and how committee has spent their money and how they have money coming in. You can do Interesting Research and most importantly you dont have to go through a stack of paper forms with a calculator. Switching to the estimated cash tab, this is an interesting new idea. Its those two charts from the previous tabs, expenditures and money in with the subtraction done for the interested person. Its an estimate. Some transaction dozen have dates reported with them so i have to make an assumption that the period of that or the date, the beginning or end date of the period in which the transaction was reported. This is kind of an idea of the Bank Accounts of a certain committees. You can start with this information, you can start to look for patterns and ask interesting questions. Again its something that is not possible with just stacks of paper and now that you have this data on computer you can ask interesting questions like what type of donors might a candidate have. Committees are asked for occupation and employer of their contributors and here on this occupations tab you can see the top 10 occupations listed by contributors to committees and and on the employers tab, we can see the top 10 employers of contributors. You can ask questions do employees give them large amount and it turns out city and county of San Francisco, the employees of the city are civically minded as you might notice and it shows up as an employer for many committees. Could you scroll back there was unitemized listing monetary. Unitemized monetary contributions are contributions less than 100 in this is the aggregate of all the contributions of small ton arrest and committee dozen haveo report the name of those contributors that give less than 100. So, you can already see how useful this tool is and a t allows you to understand this dense information quickly where it would take hours if you have paper. Over the next year ill work on projects to update the infrastructure behind this data so we can do exciting new things. Here on this location lab n. I have a map of the concentration of contributions by zip code with the work that ill be doing, well provide zip codes or supervisor districts. Another interesting thing that comes out of this work ill be doing, right now the public can see how much the committee has spent to buy an add but soon well be able to make so they can see that add also whether. When you add a filter by district would that mean the public or a reporter can go into search where contributions are coming for a candidate for the district seven, for example and what percent of those contributions are totaling from district 7 are they coming outside the district . The darker the color on the map, the more contributions have come from that zip code. Sue filter down by contested, by candidates and see where one candidate is fundraising more than another and you can be with the supervisor district map, you can ask questions like, board of exercise canada dates where do they get most of their funds within their district of outside of their district and things like that. For ballot measures you can do the same thing. Could you show us, i dont want to derail your presentation but could you show us prop c for San Francisco that would have been the thats the vaping . Certainly, im filtered down to candidates only so ill change to develop measures and filter down to measure c. 15 almost 26 million. Wow. So yeah, not a lot of variety in that measure c right here. How do i look at this state map so that california is highlighted and the amount ranges from 540 to 19,000,421. So orange, the state of new york, the shade is that indicating the amount falls in the middle of that bar . Yes, i should emphasize the colors are automatically generated because they change as the filter changes and i remember in this contest theres not that many contributions to either supporting or opposing and i believe theyre all from either new york or california. The idea there is you can see on the scale on the bottom, bright red is 19 million and yellow is 500. The two states are both new york is in between and i think california is the 19 million. Definitely eyeopening. So other well be able to provide uptodate information to the citys central repository of open data data sf. This is a warehouse that of data that departments across the city use to provide access to the public for open data. Now these tools that ive shown you and that will be fourth coming arent that useful unless people know about them and know how to use them. So over the next year, ill work on outreach to educate people on these tools and others that we provide and how to use them. Last year, pat ford and i did a lot of outreach to members of the press. Ill be continuing that type of work and looking to expand the audience. Theres a high level overview and a quick update but i didnt want to get lost in jargon and phone numbers. Im happy to open it up to additional questions that you may have. Any other questions . This is a quantum leap forward in the presentation of the data is accessible and its undeunderstandable and makes it easier for people to find the information that they need and i would like to hear more as plans become more concrete on how the outreach is going and which organizations there was the reporter who came previously and i think that he was surprised and delighted to learn there could be a cool like this im not sure where it resides and compliance and engagement to just keep usebreast of the efforts to promulgate this more widely would be great. Thank you. Any Public Comments . My name is ellen and i am a Public Employee and i am a resident both of San Francisco and whatever you are doing here at Commission Staff volunteers and people pay or not pay, it is almost an illegal operation for San Francisco and we have no other party to be in the political sense. Because the United States constitution clearly spells it out that we are a republic government. In San Francisco, for the last 45 years, we only have democrats for 45 years. All the lefty policies that you are presented right before me have no other political balance. About two weeks ago, current mayor london breed, passed an and for Public Employees that means that theres a lot of imbalance and employees and representation along the government. I am here to charge you all as a commissioners pay staff volunteers to think about what you do for the city. If San Francisco has hundred thousand residents and almost 32,000 government employees, with a budget of 12. 3 billion, u have a duty to deliver quality care to make sure electoral offices deliver what they are running for office. As you know in our guest, 2019, we were reported by 13 departments and we now have 21,000 homeless people. Dying. Suffering. Overdose. Hunger, sickness, on the streets. I have to come in at you because you volunteer your time and the people in here they get paid for. As i run for mayor right now, i have been bullied because i am a conservative and i am a republican. Theres no other party other than democratics. I have been bullied. And i have been reported to you nothing has been done. Im asking for the people in San Francisco, we have choice. The choice is to report this to the federal government, the public has been abused because we dont have any political voice, political means for what is you are doing here in another world that we are running a government, a mafia government and a government scam the Public Services and have scammed the government money into a lot of illegal activity and you might be part of it. Thank you. Agenda item number 6, discussion of monthly stuff policy reports. Thank you, chair chu. Good afternoon commissioners. Pat ford senior policy and legislative affairs council. I have a short report for you this month. Just a few key updates on on going projects. One of them which is a big update is is that on the fourth of act, the mayor signed the Public Financing ordinance so it is now finally approved, all the steps are done and it is slated to be operative on the first of the year. We are implementing it and im meeting with the heads of other divisions in the office to figure out everything that we need to do so that its a very seamless and smooth roll out of these new provisions and very confident that we can do that t im happy to report that to you. Thats terrific news, congratulations. Thank you. Another update which is a Good Movement is on the form 700 project we have a tentative date with the first meeting employee bargaining units and were shooting for november 6th. Hopefully, within the next week or so, the department of Human Resources will issue a notice to the bargaining units and on the staff side, were going to be preparing our comments and probably some kind of presentations to make sure they understand the project and that are fully part of the process. Were hoping well have this meeting and one more before the holidays. During the Holiday Season it against hard to plan these meetings because so many people are involved. Potentially over a dozen different unions might want to come and participate so its just a lot of people to coordinate with. So were hoping that well be able to make Good Progress on this before the holidays and most likely then take a hiatus if were not done and pick it up again in january. Hopefully doing these meetings in the next few weeks will be a good start on that. How many meet and confirm meetings do you anticipate needing to hold . Its hard to say. Its very hard to say. A ballpark. Low to high range. At least one, right. At least one. I can tell you on previous meet and confer projects, i think weve had three, average of three. I think thats how many we had for the last update. Which at least is somewhat similar subject matter. If this process is similar to that, maybe three. Is the process time boned at all . Or deadline by which all the meetings need to be completed . Not bylaw. Really only operationally. Theres a certain point at which we as a staff just need to have that process completed so that we can bring the regulation before you and you have the opportunity to consider it and potentially improve it and we would then have enough time to do our implementation for january 1, 2021. Im not sure what that dropdead date is for completing meet and confer but some time in the spring is when i would like to have that done so you could have two or so meetings to consider that regulation and then we would have that 60day window where it sits over at the board and they have the opportunity to veto it and then when that 60 days passes, then we would be able to do our final implementation and hopefully we will have three or four months on that. So i think its this meet and confer process if we find ourselves in the middle of next summer and its not done yet, well have to have a discussion with you about whether or not we can meet january 1, 2021 deadline then. Im hoping that we wont find ourselves there and that we can do one or two meetings here in november and maybe a third or fourth one in january or february and that in that late winter, early spring time, that that is when ill be able to bring a regulation to you. That would be great. Keep us posted as the planning unfolds and im happy to write a letter or engage a letter that would be helpful to keep this on track so we can meet that january 2021 deadline. Great. Ill definitely do that. The last update that i wanted to highlight for you is that i designed a depart mental training that is meant to give City Employees, Department Heads and any City Employees who support commissioners information about their on going responsibilities under our code and understate laws that we enforce. So this training includes information about conflictofinterest rules, form 700 filings, statements of incompatible activities, all things that comply to all City Employees and we talk about Department Responsibilities like receiving form 700s or distributing statements and compatible activities to employees and with commissioners about recuseel rules and things that apply to commissioners and this is something that the director asked me to do because after her recent presentation to the meeting of all Department Heads that the mayor holds, she gave a presentation about some of our new laws and the mayor expressed center in all Department Heads saying abreast of those rules and as a result, some Department Heads if they could get a refresher. We could come on site and talk to them. So we developed this training to be responsive to that. They feel supported and our department is a partner and were there to help them and make sure that they understand their response act and they have all the information they need. Hopefully as we do these training on site were building alliances with other departments and other employees that they see us as a