>> call to order. >> good afternoon, my name is dr. jackson, and to bore you there. >> public comment on matters appearing or not appearing on the agenda that are within the jurisdiction of the ethic's commission. >> good afternoon, my name is

mrs. jackson. >> >> i am getting the papers together for you. thank you. last week i went before the civil service commission and the statement that is here and that i am giving to you is the same statement that was presented to them concerning the news article that you have before you, about the statements that he had made. dear chair person, the black human rights leadership council of san francisco is a coalition of dozens of community lead theirs came together, and in 2012, and order to promote the opportunity and fairness for black san franciscans recently we have been focused on issues

pertaining to housing and employment. last week, we raised a matter that concerned both the these issues in san francisco, civil service commission and we will raise the same matter with you. >> we have many, members who live and in the dilapidated conditions who have indicated to us that there is no maintenance occurring on the housing authority sites and now we know why, it was reported and last week. san francisco chronicle, and what you have before you. and that the commission and from the union have filed legal action against the housing authority, because the agency wants to use the local hire to do the work instead of his plumbers from outside of the city. we also, learned over the past several weeks, from housing authorities, staff that mr. mazola action has stopped all effort to repair the public housing sites and to make them safe and that they have the

total housing authority on the individual that he will withdraw his action against the authority if mayor lee reappoints him to the commission. second we have heard from the individuals employed at the san francisco airport, that no ethics investigation ever occurred and to the revolution that last year, the commissioner has sought to secure the employment and opportunities for the family member and no influence, promotion of his family members to the inclusion of the minoritis that work at the airport, and we understand that this is nepotism and undue influence is ongoing, and we therefore, request that the ethics commission, promptly launch immediately investigation into both of these allegations regarding the improper use of mozola status as the airport commission, and one to seek personal gain by holding the well-being of thousands of black and asian

and pacific islands and public housing residents, hostage until he gets his new appoint and to violate the law of ethics to violate the opportunities for family members, as a sitting airport commission. thank you, jackson, i just want to, and i got through it even though hope that you understand that it is a great concern and because we have in this city, positions but they are not federal or state certificated and so we are having problem that this has not occurred in the last few years, thank you so very much. you all have a blessed day

before i begin, i would like to hand it out to you. >> i received a letter from director st. croix dismissing my second complaint against the memoranda have i had pilpel his letter dismissing the second august, 4th, sie complaint, only cited section iii.5.1, activists that conflict with the official duties, but mr. st. croix did not mention in his dismissal letter, section iii.b.1. restrictions that apply to the officers and the employees in specified positions. and 3 d one states unless otherwise expressly permitted by state or local law and,

regulations, no officer employee may assist, advise, or represent other persons or entities. and that an entity would be you. >> he was clearly engaging and giving advice to the ethics commission including a sunshine complaint that may have appeared in front of him in his jurisdiction and inside of the scope of his duties and he had no business, speaking to you on july 28th, about the case before you, that is both of my sia complaints, against pilpel illustrates that he appears to be engaging in exparta communications with you, defined in a quasi sitting raise bid pun person in the

absence of and without presentation or notification to other interested parties, say the sunshine task force, and that he was here, to sway your judgment. indeed, the ethics commission's own regulations from the investigation enforcements, viii and in section 8.a, it says that once a complaint is filed, no ethics commission staff member shall engage in oral or written communications outside of a meeting and the same rule should apply to the task force members, in addition, the sunshine and ethics training video on the city attorney's website, that the pilpel effectively has reviewed numerous times, clearly, indicates that the task force has been adjudicated

body, and he should not be violating the procedural rules such as bans on exparta communications. and for these reasons, i am asking the ethics commission to calendar or a discussion to resubmit the dismissal of my second sia complaint and hear both of them. and i have been waiting, for months, for you to calendar a hearing, on mr. pilpel. and it is way overdue, commissioner, you need to prove this along. >> good afternoon, my name is karin hugens and i am president of the holly courts president council, it is 120 units of public housing in vernal heights and i am also the ceo of the new, san francisco

residents union, where we support section 8, and sros, and senior disabled house and public housing. and i am here to reiterate what doctor jackson has already said, we do need a total investigation of mr. masola and what he is doing is what we believe is illegal and you know, there are federal funds that come into this city and when they come into the city, and if they come into public housing, there is something called section three sxim sure that you are aware of it. where 25 percent of the residents need to be hired with those dollars, and 25 percent of the city workers, if there is any, a drop of federal money, going anywhere, 25 percent of the surroundings areas should be hire and what he is is trying to do is eliminate that. and now, as you know, we are going through rad, which is resident, and it is, stands for, rental assistance, and demonstration projects. and where, holly courts is number one. and we are going through rad.

that is privatization of public housing, that is going to be the vernal heights community center and the managers and for 99 years, along with bridge developers and in partnership with the holly council, which is also known as the management corporation, we are going to be able to do business toelgt and together sxb the model to the city so that the public housing residents will know that there is someone out there fighting for their rights because there is no one out there now, except us. and that the section 8 should be adhered to in this city. now, i am going to the colleges, south east facility college, and i have already spoken with their commission and i am going back there again on wednesday and to talk about bringing in a curriculum that will show the residents how to become trained as property managers and get their phm, which is a certifiable title. and they will learn, plan and organize work, and supervisor

the staff and supervise the residents service and so on and so forth. back in the 90s, the formal vice president, quail, came to this city and he came to hunter's view and he was in total support of resident management and resident management corporations and owning in the public housing and residents owning their own public housing, and so when he left, there were 20 residents hired, and 12 out of that 20, went to work, and i was one of them and i managed 7 developments here in the city for 7 years. and the others were put on a waiting list and then we got dropped like we didn't exist. and so there are residents out there who are willing to do the work, they just need your support, and to be ethical city and use the ethics commission, you need to look into this mazola issue and this is not right and this is illegal, thank you. >> next item on the agenda is

presentation by information officer steven massey regarding campaign finance data. >> we need to tell them that the scene? or tell them about the screen? >> okay. good evening commissioners. my name is steven massey and i am the information technology fer and tonight i am going to demonstrate two data visualizations that i have been working on in anticipation of the upcoming election, the best screen to look at is this one over here because the screens on your desk are some what blurry and so we do the best

that we can to show this off. so the first visualization that you are familiar with is the campaign finance dash boards and, they started this in 2012, and this is the third year that i have produced one of these, and to interactive web tool and it is the sunrises that the campaign finance data that we have and the entire site is built on open data. the second project... >> steven, i am sorry, could you explain what the map is at the bottom of the page. >> i am going to go through each of the projects. >> sorry. >> the second project is a balance lot measure dashboard and this one we have done the summaries in the past but this one is different and because it allows you to browse all of the activity, by only knowing just the measure letter and so you don't need to know the committees involved and you don't need to know the different contributers it will just display the information as long as you know the measure letter whether or not you want to look at the supporting or

opposing side. and the third project that i am going to go over, is sort of a fun project and this one is called a democracy facts label. and it is summarizes the activity by committee, and it allows to you look at the top donors to the ballot measure committee and it is based on a design by professioner levett of the law school and so we have been working with him on this. >> before i get into those projects i think that it will be useful to get a basic understanding of the infrastructure that we focus on because, the infrastructure is actually taking us much longer to build, and i think that it is worth going over, we had a contract with net file since 2007 to host our data bases and our electronic filing systems they host four sis decembers the campaign finance, the lobbyist and the form 700, and

the campaign consultants and we don't have electronic for that one but they allow us to scan the paper documents into the system.

the contributions that go back to 1998 and there are about 260,000 of them and we have all of the lobbyists reports since 2010, and the public financing disbursements and the campaign and the zoning reports are on paper, but we actually type up a lot that have data and put it up on the data so that it is usable. >> and we also post summaries of the contracts and that pertain to the pay to play provisions in 1.6, and then, we also have a list of the summary and that i think that goes back

to 2004. so what can you do with the data on the sf. >> there are three ways to interact, there is the basic spread sheet view and it is like looking at excel and you can also download the data into a variety of formats if you have a particular application that you want to use to analyze the data and then we have the application programming enter face and we have been working recently with the cold for america and there are a number that have been interested in working, and they can build the websites and the software applications by using our data as the source data and then whenever the data updates the software will update as well. if you are not a programmer and just at the spread sheet level, which is fine you can actually do quite a bit and using the website you can aggregate the

data and filter and some of the dash boards use that functionality to build the charts and graphs and the powerful thing about using this tool is that when the new contributions come in, for instance, and let's say that you build a graph that was analyzing the contributions your graph will update automatically and you will not need to build a new graph every time that new financial data comes in and the last thing that you can do is that you can mash up the data so you can take the data and even if the data source is from another department and if, for instance, the city's geographic team posts a zip code map and we have data that aggregates to the zip code level. in this is a that is right ha the staff presented on the information technology that shows that each department's contributions to the open data effort and despite the fact that we are one of the smallest

departments, we are basically the largest contributor by far, and the second, department is there, and that is, data sets, that were contributed where the document and the department did not label they take the information and the lobbyist forms that are filed with us and the campaign reports which are compiling the data together and we put it altogether, on one display. so how do people do this before we have the dash boards and i think that it is important to get an idea of where we have come from, when i started in 2005, on a filing deadline, all of the campaign reports came in on paper, and the reporters would come into our office and go into our public access room. and they, and all of the

filings would have just come in and they would sit through unorganized campaign filings and try to make the sense of it. and then, in 2007, when the contractor with the net file we allowed the people to download the data, in large quantities and also search it, and one of the problems with search is that it assumes that you know what you are looking for before you run the search. and the other problems with the data is that you need to understand the various codes in the data which are defined by the state's campaign finance format. and then, there is the element of, as he likes to say, there you are sure drinking from a fire hose, there are 260,000 transactions and trying to make the sense of it is difficult. so one of the things that we want to do when building the dash boards is trying to allow the people to filter out the noise and what i mean by filtering out the noise is if

you are looking at a ballot measure, and they received, half a billion dollars from one source, and then they received, you know, 50 contributions, you know, to the $100 dollar level, and if you only had a few minutes to look at it, you probably want to find the half a million contribution and not the smaller ones. and so, why these dash boards focus on a lot of allowing you to see that information, quickly. and so let's try to take a look at it and see if you guys can read it from here. >> we have the home page and down here, there is a link to the dash boards. so, this first view shows the activity in the 90 day late reporting period and so late contributions, they are disclosed when a committee receives the contributions in total in the aggregate of 1,000 dollars or more in the 90 days before the election and that

could be a contribution and in monetary contribution, or in-kind, contribution or a loan. and so, over on the left, here, this box, we are showing total contributions per day, and so you can't see on the bottom, it is showing the days and the amounts so the amounts are up to half a million dollars and so right away you can see that there are about peak days, where large contributions were coming in. so, a couple of ways that you can interact with this page, and you can either click on it, or one of the peaks, or you can filter it using the tools at the top. on the right here, it is very hard to see and there is actually a map of california, and you can see some contributions here and coming from the bay area and then down on the bottom there are some coming from the los angeles area and let's click on one of the contribution and let me click on this first peak. and so we have half a million

dollars coming from the fcpier 70, residential group that is going to a committee that they are controlling and they loaned this committee the money which was going to allow them to build and project with what they are trying to build. and then over here, it is in and you can't see it because of the contrast, but it tells you the zip code and it zooms into the area in san francisco where they are located. >> in addition, there are other ways that you can look at this, for instance, at the top here, we have this tool, which allows us to filter out by an amount, and let's say that we want to look at contributions of greater than $100,000, and so i can literally just drag this tool and i will reshape the graph and a list of contributions at the bottom. and now, we are only looking at the larger contributions. and so these are just a much

faster way of getting this information and looking through 90 late contribution reports is what we will have to do if you are doing this from paper. and the next section that i am going to go over are the candidate pages and so we built a candidate for each race and so i am going to pull up the district ten race, because that has been a popular page during this election. >> on the data and it is current as of june 30th, there is a lot of activity since then and it will update in early october when the committees file the new financial statements. so on the left-hand side, we list the candidates that are qualified and supervisor cohen and right here we have a map of the district and not every person knows that they are in

district ten. so up here, i can search and find this particular, address in district ten and so i am going to type in an address. so it zooms in and i know that this is in the district ten and this is the district that pertains to us, two charts and one is the total spending and the total contributions to the committee and so it is probably hard to read the labels on these. she had raised over 200,000 more, since then, the other s

have applied for public financing and i sunshine expect that this chart will be looking different in october. we have a list of all of the contributers, so if you want to search this list, you can so you can browse through it and so we have taken out all of the contributions that don't apply to this race. we have a happen and a map of the map of the greater bay area, and it is showing all of the contributions and it puts in red, the most intense activity and this is actually coming from district ten and

this is the last section lobbyist ands their contribution to candidates. and so because they are required on a monthly basis to report any of the contributions that they are making or arranging or delivering. we have been the starts that are lifting to the local office in november and then right here, it shows all of the firms and what you can do, you can actually mouse over any candidate and it will display the firm and how much money they have been giving. and so you