Good afternoon. My name is Peter Szarsian from Budapest, Hungary. Today I will tell you a story of a country that had a relatively advanced harm reduction system in the beginning of the 21st century and I will tell you how it fall back into a zero tolerance approach because of lack of financial resources, but mostly because of political populism which is unfortunately hitting my country now. So harm reduction in Hungary started in the early 90s where the first programs harm reduction programs were created and the first needle exchange program was established in 1993 and our first national drug strategy in the year 2000 approved harm reduction programs and in 2007 a social welfare law created a legal basis for the funding of these programs and in 2014 we had 31 needle and syringe programs in the country. Actually most of the drug use in my country it's a very small country with 10 million people and 2 million people living in the capital Budapest and most of the injecting drug use is concentrating in the capital in Budapest and and so the two largest needle and syringe programs provided 55% of all the needles in the country and OST coverage was quite low in Hungary and HIV and hepatitis prevalence among the injecting drug users also remained relatively low compared to for example Eastern European countries so for example hepatitis C prevalence among injecting drug users before 2011 it was not much more than 20% and oops sorry, yeah, and what happened in 2009-2010 was there was this huge shift in the drug market in Hungary so before that heroin and amphetamine dominated the illicit drug market, especially the injecting drug use and in that year new psychotic substances came to Hungary from, you know, these drugs were produced in China and India and they almost completely replaced heroin and amphetamine, which is a quite unique phenomenon in Europe There is only one country Romania according to my knowledge where this happened so like heroin almost disappeared from the market and almost all users switched to from heroin and amphetamine they switched to catenones like methadrone and other synthetic stimulants, which were easily and cheap available and and you know that also meant that the drug market is in a constant change because these substances are changing you know as soon the government is banning one substance a new substance is coming so and you know these substances have different dosage and different use and different mechanism of of effects so that meant that this changing market in and itself was a risk for for drug users and the characteristics of this new psychotic substance injectors for example is that they use or they injected much more frequently than drug users before so it's not rare that people inject 15-20 times a day and that means that sharing of injecting equipment increased and there are the the risk of infections also increased among the new psychotic substance injectors and and There is also a trend to Injects in an unsafe environment more than heroin users so that you know new psychotic substances donate cooking for example so people can use them much more easily and We had much more cases of hospitalization due to paranoia and psychosis with in a new psychotic substance users In 2010 this change in the drug market corresponded with the political change So there was a change of government in anger in 2010 and maybe some of you know that we had a quiet conservative government with Prime Minister Orban with a populistic policy and and actually the the new government rejected The drug strategy that was approved by the previous administration, which was very much pro harm reduction national drug strategy, so they rejected that and They also restricted our criminal laws so they increased punishment for drug use and drug possession and They also had a new recovery oriented approach, which is it was more like abstinence based approach so they they were rejecting the concept of harm reduction and In 2013 they adopted a new national drug strategy, which actually aimed to create a drug-free Hungary by 2020 which is a very ambitious and very stupid Goal, of course and you know just Parallel to these changes the drug budget was Was was in the decline also you see on this graph So the when you know government had this rhetorics of of course we will stop drug use and making drug-free country but at the same time they dramatically drastically cut the budget of of recovery programs and harm reduction programs and and That means that in 2011 there was a huge decline in the availability of of Needles and The services the needle and syringe services were very very underfunded So there is a professional protocol for needle and syringe programs in Hungary and that requires that That's all programs have to employ three and half staff members for each program But actually, you know the the the programs don't get enough money from the government even to pay for the salary of the Social workers working at the Nilexons program not to mention, you know buying Equipment and and all other you know related social services so that that meant like a really bad they they get into a very difficult situation and And the government created a new action plan which didn't mention harm reduction at all and As I mentioned to you the the two largest needle and syringe programs were in Budapest and there is one part of Budapest the district 8 which is a quiet, you know District where many people live in poverty and their unemployment is quite high and There are thousands of injecting drug users in that only on in that district most of these people belong to the Roman minority who are you know discriminated and who are segregated in in the Hungarian society and And that there was a new mayor of course from the ruling party of this populist conservative party and He scapegoated the local needle and syringe programs for For the problems in the districts so he said that the needle and syringe program attracts drug users to his district and He said that he accused the million syringe programs to spreading drug litter on the streets and he you know Spread fear in the population that your children will jump into its needles and and And actually that you know that drug litter Issue was dominating the discourse on needle and syringe programs Even if there was not a single documented case when anyone was injured by needles But there was a many many documented case of getting infected by sharing needles. So The this mayor organized the demonstration in front of the needle and syringe program with some, you know misled local residents and And actually they he started the smear campaign against the new exchange program and in 2014 it had to shut down the program and Just shortly after that the other big needle and syringe programs also shut down in in another part of town because From that program you all the clients from that program moved to the other part of the city and the mayor there also said You know that oh we can't take that and and he just closed the the other program. So that means that more than 50% of Hungarian needle provision just stopped from one week to another in in Hungary and and So that that was a declining access to needles you can see in that graph that the distribution was like declining very sharply and You know that WHO recommends to have at least 200 clean needles per dark users per year while now in Hungary there is a There is like approximately 30 30 needles per person per year and at the same time the clients who visit Needle exchange programs are the number of clients are it's going up. So there are there is a more need for needles But less supply of needles So the consequence of this situation is a growing hepatitis C epidemic in Hungary So According to the National Center of Epidermal Geodata The prevalence of HHCV among injecting drug users rose from 34 percent to 60 percent in three years And you know when hep C is going up that's always a sign of a new HIV epidemic. So we are now pretty much afraid that Like in Romania and other countries we are facing a new HIV epidemic among injecting drug users The problem is that we were you know trying to convince the local and national government about you know to we have to fail to respond to this threat and There were many you know debates and there was even a political debate in the television It's for the televised debate where I was debating a government politician and why I mentioned it that You know sometimes scientific evidence is not enough to Support harm reduction because I was citing data of the National Epidemiological Center and the government politicians said that I don't believe your data I don't trust your data because that is collected through needle and syringe programs. So that I don't trust the needle and syringe program So that's why your data is not reliable So I don't care that so Even if we have the data in Hungary and you know hard facts, but but you know this this debate is so much emotional and We when we realize that we created the campaign because we realized that the key is to convince the local people You know who who are manipulated by the local mayor and we had an advocacy campaign that is called the room in the 8th campaign and the aim was to address local neighborhoods, you know people who live there and and actually We created messages which convinced this try to convince people that harm reduction is good for them It's not only good for drug users, but it's good for the the people who live around And live with drug users so that you know people who use drugs are part of the community and so we Like created the campaign movie And we were going to the streets and collecting signatures We had a campaign website so dude did it online offline different methods had some meetings with the local community we also get some money to have you know city lights advertisements on on the street and Actually even the ombudsman for civil liberties supported our campaign by stating that Harm reduction is beneficial for the whole society and it's it does not only About you know protecting the right to health, but it's also protecting the right to healthy environment, which is Very important when you try to convince people who are not drug users, but who are who live in areas where are affected by drug use so unfortunately Still you know we have this populist government and Unfortunately still the Netherlands finish programs are closed in Hungary What why the story is interesting is that Hungary is a case where the problem is not Mostly it's not the lack of financial resources or at least you know The government does not provide adequate resources, but that's not because they don't have the resources But it's purely an ideological Opposition to the idea of harm reduction and this is happening in the middle of the European Union you know where the European Union has a drug strategy that is Pro harm reduction and the Hungarian government even signed that but still they Don't really implement that so that shows that you know There is a limit of this international multilateral agreements and recommendations when it comes to implementation of these programs at the local level and Even if even if you know there is a the government does not say that We want to shut down needle and syringe programs But there is no political leadership in the in the national level and the local governments can stop harm reduction programs without any you know We not any support from the national government so there is no leadership for for that in Hungary and And I think it's also important to mention or it's a lesson learned is that harm reduction does not exist, you know Isolated from the larger political environment. So when for example in Hungary a civil society scapegoated and and We have now a law Discussed by the Hungarian Parliament that requires us NGOs receiving international funding to register as foreign agents and That that is exported from Russia and You know our government is saying that we are foreign agents And we are spreading, you know Some ideology coming from the West and we are not Part of the Hungarian nation and in this environment. It's really difficult to do any kind of advocacy. So Yeah, and yeah, thank you


Oh, what's up everybody? Once again, it's brand man Sean and I'm back with the type of video I haven't done in a long time. Today, I will be testing out a different marketing method. All right, I was asked to review repost exchange and I was like, I've never done it before. I've never used repost exchange so I can't really review it. So what I'm gonna do is I'm going to use it live, right, and let you guys go through my first time experiencing using it, trying to keep it real short about less than 10 minutes and I'm gonna let you see the phases and what I think about it in the process. Let's get into it. All right, so as you guys already know, I'm not an artist. So what I'm gonna do is take an artist profile that we work with. All right, her name is Hadassah, really dope music, definitely go check her out. And we're gonna push this track by the name of my funny Valentine. If you can see, this track was released two months ago, 4,529 followers, no, streams, and then seven comments. 188 likes, 14 reposts. Now I'm interested to see what we can get this thing to. And I'm gonna do it in phases because honestly, I've never used the platform before so there's just some of that apprehension like am I doing this wrong, am I wasting the money? How does this really go? I'm gonna go to 500 the first time around and just to do it like at this phase, then later on, I'm gonna probably try to just blow the rest of the budget but I wanna do it one time just to get a feel of it and we'll do an update with both portions of it. So for this first one, I'm not gonna get fancy use the budget to incentivize useful comments it's already selected. So I'll just leave it how it is. If I go down any genre, reposters must meet the following conditions, preferred genres must include. Nah, it doesn't seem to make sense to include any genre so I'm going to use the track genre. All right, she chose R&B and Soul so we're gonna have people whose preferred genre is R&B and Soul, all right, the genre of the song. The rest of this stuff, max followers, max number of repost, max number of repost per day, average. I'm not fully, you know, I don't know. I don't have any preferences. So I'll just leave the defaults on and this other thing up here, I kind of grazed by it but I did read it one time earlier. The campaign, no, actually everybody might not be able to have that and then they say they have. Again, now in terms of these other, now in terms of max number of followers repost or repost, now in terms of max number of followers repost or repost per day, I don't really have a preference and I don't really understand enough to know whether I should go higher or more. I can put some logic to it but again, this is the first time, so let's just do it, run it. Start with 500, do I have to do anything else? All right, reaches at zero. We're just getting this thing started. Here is video one, phase one. Let's see what happens. Here is phase one of my repost exchange test. Let's see where it goes. All right, so I think it's more effective to put part one and two in the same video for the first time around. So that's exactly what's about to happen but before I even get into the results, I wanna say, I actually love it already, enough. Two, go ahead and say, use the free version of this. It is a free version of it, you can have paid stuff if you wanna boost things faster but use the free version of it and you can get your stats up. I'll put a link in the description below because these stats look like this. I got a change of 227 streams, 22 likes, 24 repost and 11 comments. This is over a day and but I'll go deeper into it in my prerecorded video so you can see what I think about everything. These aren't real, right? And these are 11 comments that got made. I myself made some comments, not on this video but on other people's stuff. So I know how real it is. I've been a part of the process. You can get on the platform and test that out. You'll see how you can pretty much verify for the most part. This is happening real. I've gotten requests and earned credits and commenting on people's stuff and I'm not gonna get into the details of how they verify, make sure it's pretty quality, you know, authentic feedback. But let's get into some other details because you'll see on the backend all the comments that were made because of the campaign and through repost exchange. Your vocals are smooth and well-controlled. All right, there's all this cool stuff. I love this. I can't wait to hear more from you. There's some of these comments that are pretty funny but here's the thing for me. Get more credits. So when I say I spend 500 credits, 29.99 will buy you 1,000 credits. I spent $14.49 and a half cents and got those results. So we're not even talking about a lot of money. 500 credits sounds like a lot but we're breaking it down that I got 132 plays and 11 comments and authentic comments and some repost for $14. When we're talking about authentic, this is beautiful, right? I think it's something that a lot of people should really consider and keep in mind but I actually am running a second level campaign with Hadasa because I don't wanna just do it as a one-off situation. All right, we ran 500 one time. I'm gonna do 500 more credits. We'll run another campaign with Hadasa. Now, if you look at this, of course, you put a profile link in there. You click my funny Valentine, right? That's the song we're running but I wanna do things a little bit differently this time. Also ignore the Sean talking in the corner because that Sean talking in the corner is wrong. I had to re-require the video because I recorded the first time on me. So 500 credits, I'm gonna choose again. I'm gonna leave the enable comments to us on there and then I'm gonna take it back to R&D Soul, right? I wanna keep it on R&D Soul for a reason and that reason is the first time I tested it, I did it on R&D Soul. What I wanna try to figure out this time is what is the impact of changing the maximum number of followers? So yes, you guys know this platform works but is there a better reason or a better quality of campaign that you can get from doing a certain maximum number of followers in your filtering? A lot of that can lead back to simply the idea that if someone works more followers, you post yourself then you're gonna have a higher reach which we'll be back into but even with that being said, you still are gonna have to spread that same amount of credit. So people with more reach, they actually are more costly or can be more costly. That's it. I wanna wait and see what the second phase of Adasa's campaign looks like and I'm also gonna throw another track into the mix because it's not fair to just do Adasa's track. I think it's great, but I know some people might say, well, yo, she has a little bit of a following that y'all have been building on another platform maybe that spilled over into SoundCloud. If you look at the timing of the results, if you look at the timing of the results to the track on Spotify, then it's pretty clear that it came from repost exchange and not the other platforms because we market other platforms to go to Spotify, Apple Music. But I wanna start this with an artist who's starting pretty much from ground zero so y'all can see what that looks like. Stay tuned. All right, so that was my first experience with repost exchange. And as I said, I'm going to keep testing and I'm gonna keep doing these videos showing y'all what my results look like. So you can get that idea, especially for the ones who need to continue to see logic. Some of y'all are just gonna hop in and some of y'all are just going to continue to learn before you use. Either way is fine, but I'm telling you, I think it's worth it, especially since there's a free tier where it's more manual labor to get your music feedback and get other people to see it versus paying any kind of money at all. That's why I went ahead and suggested it. So soon, because there's a free tier where there's low risk, but paid campaigns, I think they're worth it as well on this platform. Go ahead and check it out. The link is in the description below. Repost exchange, I think we're on to something, but keep watching the test, all right? Let's see if I changed my mind. I doubt it, all right? But let's see, I'm gonna do several other videos to make sure y'all are tuning in as educated as possible before you make any kind of crazy mistakes. And as always, if you liked this video, go ahead and like button, if you like it, your mind's well-sharing. And if you're not subscribed, you know what to do. Be dead. Subscribe, boy.


Hi everyone Sean with jaspys case breaks comm here doing 2020 Panini playbook football eight box case break pick your team number six Where all card ship so no fillers no random number blocks.  Here is the list of customers and their corresponding teams last spot mojo Alfonso Mendoza with the New England Patriots and Our pick your team six inner case eight boxes Let's do this finalists. Good luck, everybody Just find some nice stuff in there There we go eight eight maxes Perfect Good luck everybody. It's good wit. How are you man? JJ Arcega Whiteside 54 out of 99 Philadelphia Eagles Jack Townsend Chase Claypool Mammoth materials eight out of 108 out of 199 Steelers Michael Galucci Debo Samuel seven out of ten Very nice goal line graphs Jersey and Otto for the 49ers Joseph Reiner How you been with and our first booklet Denzel Mims Come on Denzel you can use more of the canvas than that to sign Jersey Otto Number two two forty nine two oh four out of two forty nine I'm gonna set that over here until we get some more booklet holders or once after this I go grab some Tonight we had a nice Donovan Mitchell rookie RPA out of Impeccable I'm gonna find something really nice here for sure. Oh Look at those words rookie signature locker, that's good stuff. That's good stuff now Let's hope it has a good name DJ Chark 36 out of 149 Jacksonville Jaguars Damien Kovaleski Joe Mixon 106 out of 149 for the Bengals Anthony Miller, what team are you going for with? Joanne Jennings 49 out of 75 49ers Joseph Reiner and Boom Yeah Justin Herbert Randall Fitton Los Angeles Chargers Congratulations 10 out of 25 Jersey number hit 10 on the Jersey 10 on the booklet I'm on video I'm on stream right now. I go I go you listen.  Come here. Look at the patches this thing and it's this Jersey number 10 out of 25. Good equal Yikes We'll get into a better fitting one tomorrow, but in the meantime. There you go Nice card. It is Randy, right? Yes, a nice book Let alone to have it be Jersey number. You love it. You love to see it Jared Allen 26 out of 149 for the Minnesota Vikings Randy Lou and Tyler Johnson nice four-color patch 14 out of 25 He had some really nice catches today too Tampa Bay Bucket Brian Frank Nikhil Harry auto Minnesota.  We'll see who his quarterbacks gonna be next year and Deandre Swift Nice Jersey and auto Detroit Lions Grant Fusel 25 out of 199. So this will probably be our last break in the night. Ted, are you offline over there? What? Okay, this will probably be our last break of the night unless anybody wants to do any personal breaks And then we'll open it up for that, but we got a redemption Cortland Sutton 158 out of 299 for the Broncos Todd Miller and Clyde Edwards E. Lair 39 out of 199 for the Chiefs and Brian Frank take a picture that Herbert, huh? That's the Instagram worthy redemption Playbook Jersey autographs Brandon Ayuk That's San Francisco Joseph Reiner Boom pose with the Herbert. Should I put my hat in the background? Pulled by an actual Chargers fan. We do exist Kishan Vaughn Jersey auto gold Tampa Bay Bucket ears Brian Frank 65 out of 99 nice one there. He could be playing in the Super Bowl Well known next week Marquez Valdez scantling for the Packers Daniel Tim 81 out of 99 And Jerry Judy mammoth materials 105 out of 199 for the Broncos and Todd Miller Chris Godwin also Still alive in the playoffs 90 out of 199 Jersey and auto Tampa Bay Brian Frank, I hope so. I don't know. I mean, just don't know anything anymore Devin DuVernay Jersey auto blue. What's that number to like the blue 26 out of 49? nice Baltimore Ravens Mark Nation One of the last teams taken. Thank you very much mark Three boxes left. Why do I need to take it home? Can I just eat a piece? I'm gonna probably do the same. How much is left? Is there a lot? I didn't need any of that. Is it any good? Tristan worse 17 out of 25 rookie auto Again, Tampa Bay Bucket ears Brian Frank Nice rookie auto. It's five Tanner.  What is it any good? Paris Campbell, Jersey and auto 76 out of 199 for the Colts Matthew hedges When do I think probably tomorrow Tanner? I'm sure it'll fill tomorrow Nexus 2020 playbook 15 out of 25. Oh nice Cam Acres Jared Goff and van Jefferson two rookies and a guy who probably shouldn't be playing on that team next year Rams Laura Donlan, that's a nice looking card 15 out of 25 Honestly, I hope the Rams keep him like I said, I don't like him I'd like for them to keep him and then The other thing I heard was them possibly going after what's his name? Sean Watson Joe Reed 27 out of 49 Chargers Randall Fitton We got wild card points. That'll be randomized in the break to one person 35 out of 75 AJ Turrell Falcons Oliver Soria, well jerseys Gabriel Davis for the bills 69 out of 70 Buffalo Bills one Escobie, Pena and last box Good luck everybody Mike Kasicki 167 out of 299 for the Dolphins Randall Fitton Double moves double relic two out of 149 Calvin Ridley Falcons Oliver Soria Darius Slayton 195 out of 199 for the New York Giants Juan Escobie, Pena the last booklet our last hit Jacob Eason for the Colts Jersey and Otto Indianapolis Colts Matthew Hedges that is 141 out of 199 There you go Last thing to do is to randomize these wild card points to one person in the break They could be a couple hundred points. They could be a couple thousand points We won't know until later on so we're gonna copy the customer list here into a new randomizer There you go Back up dice roll name on top after Four and a two six times six times right six in the final time. Good luck Congratulations Joshua Gribble Who Had oh Washington football team. I don't think I really said your name very much at all So there you go Joshua. You've got these wild card points going your way and that was 2020 penini playbook football eight-fox case break pick your team number six from jasper's case breaks calm I'm Sean jasper's case breaks.com. Thanks for hanging out. We'll see you next time


Well I'm John Dowell. I'm an artist and I've been in Philadelphia most of my life. I've traveled a little bit but I've been back and I come back to this one place that I'm interested in because I'm interested in intimate public spaces and Philadelphia has the one.  So you can be there sometimes and I know you can feel them because I feel them. The project is going to be eight four by ten foot panels of photographs of written house square. They're going to be attached to stands on wheels and dancers are going to move them around and interact with them. And then the audience is going to be in this environment, this cathedral-like environment. It was important for me to have this project at the Barnes because about two or three years ago I saw that space and I was thinking about with some dancers and some sound and I realized that hall was perfect and I saw that open space and I said we could do something with that open space so that you can move and control and project into a number of things and also that the barge right now has a vibe that I think it's just it's there and I need that kind of vibe to produce this kind of project because it's unusual, it's different and people might go oh but their lives will never be the same because it'll be an experience. I've worked very closely with Zane Booker, the choreographer and recently in the last year or so I've started talking and dealing with Maya Johnson who is a senior student at the Curtis Institute. Zane can worry about the movement of the body and Maya is definitely going to take care of my contemporary Gregorian chant. This whole project has got more exciting as more involvement with the people and we start working things out to go. I've been striving to present to an audience something that they've had around them all their lives but haven't been aware of and that's for Philadelphia here that's written out square and the audience definitely will walk away with a more appreciation of it and a respect for the city and its thing with it. So on December 8th, please come to the barns and see the Curtis students and John Dowell, it will definitely be an evening you will remember.


And was that this unit. The charge of the board, the, the charge that the board gives to the superintendent around the district ends. So the district ends are we're set by the community during a very long process before I came on the board. And there are details, but I don't know how many of you have heard about the district ends, but they break down into four categories, a disposition for lifelong learning, academic proficiency, personal development and citizenship. And these really describe the things that we are hoping that our students possess by the time they leave our doors at the end of high school and are ready for their next steps. The 2022 budget for this school year was well supported by the community, despite the fact that there was a reappraisal in town, which changed property values quite significantly. And despite pandemic concerns. This budget really focuses on the needs that our students have to recover both social emotionally and academically from the effects of the pandemic, which is unfortunately still ongoing. It also supports administration's focus on preparing and being more resilient to pandemic challenges and other challenges that we might face over the next year, while we are still meeting these district ends. Thanks Bridget. Yeah. Hey, so I'll cover some of the factors that that impact impacted the development of the FY 23 budget. But on the expenditure side, some of the things that we considered when we were developing the recommended budget for the board was the significant increase, a little over 6% over a 12 month period. That's number 21 and the consumer price index and inflation and in short, that put a lot of upward pressure on everything that we do as a district all the consumables professional professional services supplies equipment that that we require to operate our schools. We also have a required response to the enrollment situations the increased enrollment at both Rick Marcott central school and orchard school. It's also good to note that the high school has has been slightly above capacity for for quite a long time now as well. We have to consider negotiating all three collective bargaining agreements teachers administrators and our union support staff. Those contracts are all expiring in fiscal year 2022, and they're in negotiations now for fiscal year 23 and beyond. And finally on the expenditure side. Like most of the most of the country and all of Vermont really there's a critical labor shortage. And you know it's kind of forced us to do some assessment and make some market adjustments to attract and retain our high quality employees. So we can continue to operate like we normally do. So as of November 1 our full time equivalent the number of people the board approves in the budget. For hiring during any fiscal year. For this year, the board adopted last, you know town meeting day it was approved of 498.18 full time equivalent employees. So far this year and I'll refer back to that labor shortage we've only been able to fill 485.75 of those authorized positions. And this budget as you'll see in a few slides, we propose to increase the local fiscal year 23 budget by three positions for 501.18 total full time equivalents on the revenue side. You know we, we, in this budget, we have an undesignated fund balance from fiscal year 2021. We had a strong financial management year and 21 unfortunately a lot of it was because there were a lot of things that we couldn't do because of the pandemic. So we are able to carry forward as revenue to offset expenses into fiscal year 23 $2 million. That was surplus. That's the general term but undesignated funds from FY fiscal year 21. We also are in the planning process of of how to how to apply and administer about $3.1 million and elementary and secondary school emergency relief funding from from the federal government. And the acronym is ESSER. In this case it's the American Rescue Plan SR three funding. And it's designed to offset pandemic related expenditures and support our recovery efforts. So we, we have been communicating with our stakeholders with the community with teachers and students on how best to apply and administer those funds, and they run through fiscal year 23 and 24. So that we have a close to two years to left to expend those funds. Our state factors, and we can kind of disregard the new because they're, they're almost a week old now. The common level of appraisal came in. The second reduction over fiscal year 22 is common level of appraisal. It dropped 11.04% down to 100.99. So that that's a measure that you know it tries to based on the appraisal cycle that you're in. And the high number that we had last year. So fiscal year 22 was really a direct result of the of the citywide reappraisal in South Burlington that was completed and went into effect in this fiscal year. So that's just a, it's a measurement that that takes actual home sales data and compares it to, to assess value. And that applies applies a factor to try to equal that out statewide are equalized pupils we. It's not quite finalized yet, but our initial projection is that we are going to go down 1.64 equalized pupils from last year it's an important factor in budgeting. It doesn't directly correlate to the number of students we have. So it's in effect level from FY 22 to FY 23. The property yield another major driver of property tax rates in Vermont that had a significant increase from 22 to fiscal year 23. These are projected numbers there the tax commissioners best guess they have not yet been approved by the legislature that will happen usually happens in April May timeframe somewhere in there. The property yields for both property and income yield increased quite a bit up to 12937 which is a conservative estimate and 15484 for fiscal year 23. And you'll kind of see some of the impacts of those a little later in the presentation. Can you, can you just sum up what those state factors mean I wish that I was. Yeah, so first in all of that but it's a little I'd like to say, I'd like to say yes I could do it in one sentence really easily but but not really. They're really the main budget drivers that determine property tax rates in all Vermont towns. So they are set other places but in your in your local, not in your local. In the local level they're set at the state level. And when you combine those with what a school board authorizes or adopts and proposes to spend, along with the, the revenue that's generated from various reasons those are the main factors that determine property tax rates. So last interrupt and learn Glenn when I get to my part of the presentation. I'll refer to the state factors again as we walk through how we get from our expense budget to a tax rate. So we'll touch on them again a little bit later in the presentation as well. Okay, so we have till 605 so we'll move on to the next screen very complex but here we go. So I'm going to talk us through some of the enrollment projections that we have right now. Enrollment has a significant impact on future planning as well as current budget implications. Right now we're seeing increases in enrollment at all five South Burlington schools with our elementary schools experiencing the highest enrollment increases. That puts a further strain on space constraints on Rick Marcott central school and orchard elementary school in particular, which are already at capacity. The board is currently evaluating options for space solutions for the future and is seeking some community output input on those options as well. So, is that 30 students overall total enrollment pre kid at 12. Total enrollment pre K to 12. Our current is 2,536 and projected for the fiscal year of 2023 is 2,566. So that's looking like increases. Let's see we have about seven at Chamberlain seven at Rick Marcott 13 at orchard. And then they drop down at two two and one as we move up into the other levels here. So, you know, really, the concern is that Rick Marcott central school and orchard school are already at capacity. And so we're looking at some options, whether that is redistricting trailers, potential construction for the future. And the school board is charged with working with the community to weigh the options based on some information we've received from a demographer which is where these projections are coming from. Thank you. My pleasure. So the question is now, you know, so what are our budget priorities and facilities mean needs really mean for proposed increases in the board approved fiscal year south Burlington school district budget. The approved budget proposes a 4.8 per 989% increase for the district budget with a 3.64% increase for net education spending. And to talk a little bit about, you know, what that actually means for our citizens in dollars and cents. So we're going to look here to two comparisons we've got on the left some information from fiscal year 2022 on the right for the proposed fiscal year 2023 budget. And at residential tax rates, we see this proposed increase of the 4.89% in budget, equating to a pretty modest $8 per appraised $100,000 of value on average for residential properties. And to note that that's off the back of a $309 reduction per appraised $100,000 of tax assessed value from the fiscal year 2022 budget. So a pretty, you know, significant dip with the approved FY 22 budget. And $8 would be the proposed change from the fiscal year of 2022 per every $100,000 of tax assessed value that taxpayers will see. And you know, what is that money, what is that money getting us in our district walk us through some of the proposed local additions to the fiscal year 2023 budget here. At the district level, we have one position being added. It's the executive director of equity. This is a position that has been in the works for a long time. There's been incredible board and community support, as well as support from students and staff at the same time in this position. This person will round out the executive team with myself as executive director of learning and our executive director of educational support systems. And of course our leader, our superintendent. This position will work together with our team to ensure that our educational systems and all of our programming is more equitable for our students, our staff and our community. So two other district expenses here recently the central office for the South Burlington School District moved out of the middle school building where it had been housed for some time, and has moved to 577 Dorset, which is of course right from the high school. There are some associated costs with that electricity heating for the district offices cleaning contracts being two of those expenses that one will find in the proposed FY23 budget. As for staffing, we have two final positions here. You'll see them on the slide listed as three. We have a proposed solution for adding some administrative support to our elementary schools which are, as we discussed really experiencing significant enrollment increases and have been continuing to do so over time for quite some time now. So there's a proposal for two positions for assistant principals will be shared among the three elementary schools, Chamberlain Orchard and Rick Marcott with a point four of one of those positions being at Gertrude Chamberlain, due to the smaller size of that facility. One final proposed cost is the playground upgrade. This is a long overdue at Gertrude Chamberlain. And the goal here is to improve the playground and you know really the safety and the structures to bring it to a comparable level with the other two elementary schools. I'm just going to remind people they could call us at 862-3966 if they have any questions about the South Burlington FY23 school budget. Thank you. Go ahead Violet. Thank you. I'm going to turn it over to Bridget here to talk to us about some master planning and visioning. In South Burlington when we talk about master planning and visioning we are talking about our facilities. The district is a leader in the state in terms of having a long term capital plan and making sure that we are doing stewardship as we need to on our buildings. But the fact is that all of our buildings are aging and have various problems amongst them. So we know that there are projects for unaddressed needs at all five schools but critically at four buildings at Rick Markott at Orchard at the middle school and at the high school. So Rick Markott and Orchard as we've discussed previously tonight have significant capacity challenges so they're not just at capacity they are way over capacity so the theoretical capacity of Rick Markott is about 350 students. We are up at 415 this year which means that special educators who need breakout spaces don't have those spaces to provide services to students in the way that they should be able to do. It means that we can't add teachers at those schools to address increasing enrollment in terms of classroom sizes and the classrooms are small enough that we can't just add students to a particular class. So we're really up against it at the elementary schools. There is an enrollment committee that includes folks from the community, it includes two current board members Brian Minier and myself, and Dave Hyatt at the middle school, Superintendent Young, and some teachers from across the district to really work out different options for how to address that capacity challenge, both in the short term and in the long term. Administration has earmarked some of the ESSER funding to allow trailers to be brought in at Rick Markott and Orchard. Those trailers would be used primarily to move offices out of the main school building and allow the students to expand into the spaces that are currently taken up by some of those offices. There may be services here or there that need to be provided in those trailers, but for now that is the short term solution to basically give us more time to really think through all the options and the pros and cons of them, and the potential costs and to communicate those to the community and have an even broader community discussion about those. The community will also remember the significant issues that were identified with regard to infrastructure at the middle and high schools during the master planning and vision efforts that culminated in the bond that was unsuccessful. Two years ago, none of those challenges have gone away. The middle school this year will get a new roof. And that was actually approved in a bond that was approved by voters last year. It was the main expense that we asked voters to approve last year. The work was delayed by COVID. There were just a lot of challenges around getting that work done. So that will happen in the coming school year, likely over the summer of this this coming summer. And then the middle school also over the long term we need to be still thinking about all the challenges outlined previously, as well as one of the ideas for potentially addressing the capacity challenges at the elementary schools is whether to bring the fifth graders to the middle school. That's just one of a number of ideas. If we were to do that, there would be a number of spaces that would need renovations or changes or additions at the middle school to make that possible. So the middle school is definitely on the docket for additional work in the coming years. The high school still has infrastructure problems and is over capacity so capacity at the high school is estimated at about 880 students were at 920 years. COVID flow, the growth that had been projected in terms of enrollment, but we are expecting to see an additional 100 or more students over the next few years, and we simply don't have the cafeteria spaces, the congregate spaces, and the classroom space to to meet the students at the high school. So we will need to talk to the community about that again. So to be clear with the community this year there is no bond on the ballot. We don't expect one for it. Well, we're we didn't put one on the ballot for this year. We do expect that there will be a smaller bond, much smaller than the one we were talking about previously on the ballot for next year to address the long term stewardship plan and then master planning will continue to be happening and we will be continuing to communicate with the community about it. Phase one, as we already mentioned will be elementary enrollment, what we're doing in the short term, what that long term solution is, followed by the high school, which is really labeled as the most critical next need, and then the middle school, and then over the long term the city has plans for much more development and we're seeing a lot of increasing enrollment driven by additional housing being opened in South Burlington and being built in South Burlington. And so we continue to talk to the city about making sure that there's space long term carved out in the city, in case there needs to be a site for a new school somewhere down the road, but that would be many years out so that sort of covers master planning and visioning. Gary, if you want to move to the next slide. I think Violet will talk about Esther and then I will go back to talk about tax impact. Thank you Bridget. So, it's important for us to discuss some of the other funding that we have available. You know, as, as the team here we've been really intentional in thinking about master planning and supporting current needs of students imposed by the pandemic. So I'd like to share with the community some of the ways that we're doing this at this time. Our recovery plan can be viewed on the South Burlington website. There is a there is a link here. And if you'd like to, you know, browse more resources we've got plenty of them. I'm going to hit the highlights of some of the spending, what resources are available, and a little bit about our priorities for spending. We know them as the educational and it's the elementary and secondary education relief spending so we, we have an acronym for everything of course in education so we lovingly call these grants the answer grants, and the allocation for the South Burlington school district is about $4.8 million in total. If you add up all three of these grants that will be awarded to us. Right now we're in the process of collecting feedback from the community regarding needs. We've got some proposed plans and we'd really love to hear from you all via the link here or you know, hit the South Burlington website under the tab. COVID and recovery you can find more information. I'll tell you the main pillars that we're trying to support in line with our district ends policy, and our educational recovery plan, our continuous improvement plans, the work that the district has been doing for years are focusing on the social emotional improvement planning for students on the continuation of learning so keeping our buildings up and running operational pieces, and finally academic proficiency, and no particular order is that is the executive director of learning I would never intentionally put academic proficiency at the end of that list were prioritized. Of course they all are linked together. So we'd love to hear from you. Please go ahead and submit feedback as a survey, or shoot us an email if you'd like to weigh in on any of the proposed plans. And with that I'm going to turn it over to Bridget to talk to us about protected tax impacts. So as Gary implied before one of the challenges of school funding in Vermont is that school districts can really only tell their voters on town meeting day what their estimated tax rate will be because two of the key pieces, at least, typically don't get completely nailed down until April or May, well after voters have voted. So I'll walk you through our calculation and our best estimates of what we expect this budget to produce in terms of a tax rate. So you start in this calculation with your expense budget this year, we are putting on the ballot, the board is asking for a 58.344 million dollar budget for fiscal 23. The difference of $2.7 million and an increase of 4.89% from fiscal 22. Then you subtract out offsetting revenue offsetting revenue includes that $2 million carry forward that Gary talked about the four. It includes in our district, a decent number I think we have in our budget right now an estimate of about 50 tuition students who come from other districts and those school districts pay for those students to come to South Burlington. Their tax dollars come to us to fund those students taking advantage of the education in South Burlington. And then there are other grant funds title one and title two there's a whole list of different grant funds for different programs and different types of education. And that makes up 13 about 13.6 million dollars this year, which is about $1.1 million from last year or an increase of 9.25%. And again that increases mostly driven from financial management and COVID impacts that allowed us to have that carry forward that gets you to your net educational spending and not educational spending is what the district is asking for from the Ed fund and the state Ed fund includes property taxes. It includes sales and use taxes. It includes lottery funding. It includes a number of different sources of revenue but this 44.7 million is what we're asking for from that Ed fund. That's up 1.57 million from last year or an increase of 3.64% and Gary if you want to move to the next slide. Thank you. And so you start with net Ed funding as you're trying to get to your property tax rate, because this is what local taxpayers are responsible for paying in property taxes as our portion of what goes into the state Ed fund. So we divide that net Ed spending by an equalized pupil number equalized pupil number is a number that is provided by the state based on data that we provide to them about how many seated resident pupils we have about what their needs are in terms of their poverty level as defined by nutrition benefits and who qualifies for them. They also give a heavier weight to students who have English as a second language. They give a heavier weight to high school students. They give a lower weight to preschool students. All of those numbers factor into this equalized pupil number that they send to us. So you divide net Ed spending by that equalized pupil number. And you divide that number by the state calculated yield number. And so that yield number sort of drives property tax significantly and that number is set by the legislature. There's a yield bill every year that gets approved along with the state budget. And that really depends on how much is in the state education fund, how many one time funds are put into the Ed fund. For example, this year there's about 90 million dollars in federal funding. And there's a big debate about whether that's going to be put into the Ed fund and you and that could potentially impact yield. In fact, we were given two different yield estimates normally we get one from the state in December we got to we use the more conservative the lower number. This one assumes that that 90 million is not applied to the Ed fund. So you divide Ed spending per equalized pupil by your yield to get a non CLA impacted tax rate. We left the CLA the common level of appraisal that Gary talked about before we left that off of this slide. Once you apply that CLA you divide that number by the CLA to get your homestead tax rate. We are expecting that our homestead tax rate will increase in South Burlington based on this budget by less than a penny so about 0.84 of a cent from 1.3249 to 1.3333 so an increase of 0.63%. The non homestead rate is set by the state and then the CLA for a given community as applied to it. So we estimate that the impact of this budget on our non homestead taxpayers. So businesses and owners of second homes and that kind of thing in South Burlington would be a 1.99% increase. And then we can go to the next slide please. And Gary I'll hand it over to Gary to talk about the income, the impact on folks who pay property tax based on income. Yeah, so the, I know we don't have much time but pretty complex system for income sensitized property tax payment. So let's just simplify and say that if you pay solely on income, that means, like, you don't pay partially on your home value and partially on your income, but if your home value meets the, the requirements to be fully income sensitized. The tax rate went down pretty significantly to 2.25% of your household income if you pay solely on income. That's a pretty significant. That's a lot of about 6568% of all Vermonters pay based on income. Very, very important. And the reduction here is very impactful to our community. This slide, this slide covers the homestead tax rate history. These are, these are just averages five and 10 year averages. The percentage of increase in spending over five years is 3.46% over 10 years is 3.33% that's on expenditures, the change in tax rate over five years is a negative almost 3% reduction in tax rate. And over 10 years it's a 0.31% negative reduction in tax rate over the last 10 years. Districts comparative districts that are, you know, in, in Northern Vermont, these are all districts with over 2,500 equalized pupils and this is kind of one of the gauges we use to see like, how responsible are we being are we, are we on target with with our budgeting process. We are we're, we're the third lowest for people spending among districts with 2,500 or more students, like districts are our closest peer districts by size. And we have just a couple more minutes but if you go back to that slide. Based on what you said, aren't those numbers affected, for example, by the number of children in poverty the number of people that need federal support. They are possibly the number of school buses that have to be paid for in a rural community I mean they're different factors that go into those numbers is that right. There are in the equalized people number themselves there. It's a weighted calculation. I think that the point that we are, we are trying to make with this slide is that we, when we look at at large districts in general we look at our closest contemporaries. You can see that they're all fairly close there's only. It looks like maybe about a $600 disparity in per pupil spending among all those districts, the larger districts that are kind of the ones we compare ourselves against. But we are, you know, we are kind of right in the middle of that equalized for people spending. Yeah, thanks Kerry. You're welcome. This is South Burlington for FY 23 compared to the statewide estimates. The state was projecting a 4.28% increase in in educational spending. South Burlington is proposing 3.64% increase. The state was expecting equalized pupils across the state to reduce by four tenths of 1%. We are projected to go down 6 100 7% in equalized people count and growth and spending per equalized people the state's estimating 4.74% growth and per people spending and we are projecting 3.7% increase in. The average equalized per people spending in the state is $18,023 and we are proposing with this budget to spend $17,419 and 41 cents. And just to recap and remind people this is looking like about $8 on every $100,000 of taxable property, assuming you don't get any. Yeah, property tax. Subsidies. So, and this follows FY 22 that had a pretty significant drop in your school budget expenses. Yeah, there's a lot of numbers. And I think it's kind of really important that I think demonstrate that that the South Burlington school district is being very responsible and careful in how you spend the money. And despite the constraints of the population growth that you have which is going to require some longer term investments. But I think when people go to the ballot box, they are really driven by what it means for their pocketbook. They are reflected in the numbers that you're presenting. So just to wrap up. Yeah, yeah, I guess, I guess we would wrap it up and I'll turn it over to Bridget but this is what would appear on the ballot, the three items as far as budget that would appear on the ballot. And this is what we want to make sure people know because there's often a confusion in the community about what the increase in expenses is versus what appears on the ballot, the increase in the expense budget that 4.89% does not appear on the ballot. What we ask people to approve is the total overall budget, the spend for equalized people, and the change in per pupil education funding. So our per pupil spend is going up by 3.68% rounded up to 3.7 here. So this is what people should expect to see when they, they either mail in their ballot or when they go to the voting booth on March 1. And when are ballots, do you know when ballots will first be available? Yes, so my understanding and Gary correct me if you have any newer information my understanding from the city clerk was that ballots should be available starting on February 9 at 180 Market Street which is where the new city hall is located. Folks can vote early at the new city hall. They can also of course request mail in ballots through the Secretary of State website. I don't believe there's any, any efforts on to mail ballots to everyone like we did last year during COVID. So if people want mail in ballots they don't need to have any special need or anything they can just go to Secretary of State website and request it. Those ballots need to be in the hands of the city clerk though, before March 1 so that they can be included in the full count. And of course polls will be open from 7am to 7pm on March 1 at the middle school for two of our districts at Chamberlain School and at Orchard School for folks to come and vote in person. Well, I want to thank you all very much for presenting the FY 23 Seth Brilinkan School District budget. Gary Makrez who works hard on operations and finances Violet Nichols who assures a high level of educational quality and Bridget Burkhardt who has to keep everybody together as the chair of the board and I know David Young the superintendent isn't here this evening but he has is working with a great team. Thank you so much for your time. And don't forget to vote on March 1 or before you can get your ballot to the South Brilinkan City Hall or request them from the Secretary of State. Thanks for watching and stay tuned to continuing coverage of town meeting 2022 here at town meeting TV.


All right, let's get started with the second portion on talking about Apache Hoodie and how it plays a role in a data lake house. So I'm Nadine. I am an Apache Hoodie contributor and I'm coming in from one house and I'm working with WEN today on showing you what you can do with the lake house. So let's go ahead and get started. So let's talk about the origins of Apache Hoodie. So Hoodie started at Uber in 2016 to kind of address inefficiencies across ingestion and ETL pipelines during its hypergrowth stage. So during this time, Hoodie was dealing with petabyte of data and if we walk through an example of an Uber ride, there is a life cycle of a rider. So a rider starts a ride, it goes through the trip and then it finally ends, the rider ends its ride. So there are multiple updates that can happen. So before Hoodie, there were large spark jobs that were used to periodically rewrite entire data sets and Apache HDFS to absorb upstream online table inserts and updates and deletes, reflecting changes of the trip status. So if we remember, HDSF is an immutable store, right? So this process was not only inefficient but also very hard to scale. So what does Hoodie bring to the data lake? Well, we kind of talked about this a little earlier but one of the main things it brings is transactional guarantees to the data lake. And this is really important when you're working with big data. So one of the other things that Hoodie really prides itself in and how it was natively built from the get go was to effectively work with streaming sources where you can handle bursty writes or late arriving data and so on. So this was literally the inspiration with Hoodie. So we talk about Hoodie and we get into the connectors and stuff. We'll showcase of this a little bit more. And this is this part here. So if we take a look at this kind of overview high level architecture diagram, Hoodie can ingest data from particularly any stores whether it's an OLTP database, any types of data lakes or data warehouses and streaming sources. So once you ingest data from their Hoodie will manage your Hoodie tables within the data lake, like for example, today we're gonna be working with S3 to perform specific services to either ingest or manage the data. So once you, for example, you clean the old data or you wanna perform clustering to be able to maintain your ingestions as well as maintain your query performance and so on, Hoodie can help do that within its platform. And from there, you can connect to any query engine of your choice that Hoodie supports to be able to get the data and then perform analytics or build some sort of data application that you want to build. And so with Hoodie, you can build near real time applications. So for example, you can build a personalization app so you can build a customer 360 app and so on and so forth. So we talked a lot about the different table formats and it's good to mention that Hoodie is not just a table format, but it's also a platform within itself where there are many services to ensure that you get write and read optimizations. So one of Hoodie has a set of table services for clustering, cleaning and so on. So for example, if we talk about the clustering you can schedule a clustering service and then you can create your clustering plan and then you can execute the service on top of it. We won't explore clustering today but these are the various examples of what Hoodie brings. We also, I think there was a question about indexing. Hoodie has indexes that support write optimizations as well as read optimizations and they're a whole suite of indexes that if we want to get into we can talk about. So using Hoodie, you can perform record level inserts, updates and deletes on S3 allowing you to comply for example with data privacy laws or you can consume real-time streams or you can work with change data captures or CDC. You can reinstate late arriving data and track history and rollbacks. Hoodie has a concept of a timeline and a timeline you can see everything that's happening to your table. So you create data sets and tables Hoodie manages the underlying format. Hoodie uses Apache Parquet which one touched about and also Apache Avro for data storage and includes built-in integrations with Spark, Hive and Presto and this allows you to query any Hoodie data set using some tools that you're familiar with and love to use today. So in Hoodie we're gonna cover consistent snapshots, point-in-time travel, incremental changes later on in the workshop. So we'll cover, we'll go over some of the table storages that Hoodie offers which is copy on write and merge on read and we'll go, one of the things we'll cover is how to do incremental updates on Hoodie and to query those updates to see what those changes are. So if you're interested in learning more and wanna get involved with Apache Hoodie community you can follow us on Slack. I'm usually pretty active on Slack and there's also blogs that are on the Hoodie site as well as videos on getting started and much more. So this is kind of a quick overview of Hoodie and then from here we can get started on the actual lab portion.  Okay, let's do this. So before we get into the actual notebooks I wanna go ahead and talk about some concepts really quick and then we'll get into the actual lab itself. So let me go ahead and put this on presenter view. So we're gonna talk about the different storage types that Hoodie has and then we're gonna walk through a little bit of the workshop and then we're gonna go into looking into the future with the connection with integration between Preston Hoodie. So this is kind of a high level architecture overview of what we're architecture diagram of what we're gonna go over. So what we have in the dataset today is we have some sort of like e-commerce example where people are checking their card or viewing item, adding item to cart, things like this. So we have a lot of updates and certs and kind of maybe things, people removing things from the items from their cart, so deletes happening and it's all happening and getting started into the S3 data lake. From there, we're gonna, on the Hoodie side we're gonna write the data and we're gonna query the data and then from, and we're gonna write the data to the Hoodie table and then from there we're gonna use Presto to query the data and we're gonna use the glue hive metastore and that's how we're gonna query the S3 data. So in the first part we're actually, in the Jupyter Notebook, we're actually gonna query through Spark and then at the end we're gonna show you how you can query through the Presto CLI which is what, when showed you when you SSH into the Presto EC2 instance. So I already talked about this. Okay, so the couple of things I wanna cover is the different storage types that are available on Hoodie. So Hoodie has what we call a copy on write storage type which is if you work with a data warehouse it's exactly the same thing and then the other storage type that Hoodie offers is what we called merge on read or M-O-R and we're gonna talk about a little bit about this. So a copy on write storage is really good if you want to have a higher write amplification by a very low read amplification and it's operationally on the Hoodie side less complex. So what I mean is if you're working with batch data sets and let's say you're every 15 minutes or every hour you're ingesting data you would probably would want to use a copy on write table for that and the copy on write table uses Apache Parquet. And then what happens though is every time you ingest data as you're ingesting data there's like kind of this merge operation happening where it's combining the new data with the data that already exists on the Parquet file and it creates a new version of that Parquet file. Because of this merge operation it has a slightly higher write amplification but when it comes to the query side it has a lower amplification for reading because you can just read directly in the Parquet files. And so this is what a copy on write is. We'll talk about what this difference is between a copy on write and a merge on read table is a later on. Well let's talk about what this screen is showing you. So with Hoodie you have two different types of queries you can run on a copy on write or COW table. And they're called a snapshot query and an incremental query. A snapshot query takes a it's basically like a current view of your whole table as it exists in that moment.  Doesn't give you the whole snapshot but it gives you just the changes that happen when you were ingesting data. So if we look at the blue boxes we have an insertion of A, B, C, D, E and the commit time of zero. And if you see the prefix is like file one underscore T zero dot par K, file two T zero dot par K and file three underscore T zero dot par K. We can see that these are basically A, B, C, D is in searching and these are the par K files that it's being inserted. So if you did a snapshot query it's gonna be the same thing A, B, C, D, E and if you did an incremental query you're gonna see the whole blue boxes what is because it's commit times zero and there hasn't been any changes and it's just the first insertion of data. Now if we go to the orange boxes now you see if you look at the orange boxes that commit time one you see A goes to A prime and B doesn't change. So A got updated basically, B nothing happened there's no updates on B. If you go on a second the file two you see the C data didn't change but D went to D prime so there was an update on the D data set and then E there was nothing happened there's no update. There is no new version of the par K. So if you see when there updates the par K version changes to a new version and this is where kind of the merges happened where you get the new data plus the existing data and there's like some merge logic that happens and then the new version of the file gets created. With E there's nothing happened so it's just still file three underscore two zero because there was no update happening. But if you ran a snapshot query on this you would see the current state of the table basically you will see A prime, B C D prime E because A prime and D prime got updated but the rest stay the same. But if you just wanted to run an incremental query and you wanted to see okay well what change between commit time zero and commit time one well really A prime got updated and D prime got updated. So you can just query what you want to what you want to see change and this is actually how you build an incremental ETL. You can just see get those changes and if we think about a compute efficiency right if you have to re-scan the whole data that causes increased compute resources to do that but if you can just query the changes this is how you save on compute resources. So this is what hoodie offers is incremental updates incremental queries things like this. Now if we go to the red box or a red orange box if you will we have an update where A prime goes to A double prime B didn't change, C D prime didn't change but we have a new insert well E got updated to E prime and then we have a new insert with F. So now if you ran a snapshot query on commit time two you can see that the current state of the table is A double prime, B C that didn't change D prime, E prime and F because F is a new insertion and then if you wanted to run an incremental query on this you get the changes between commit one and commit two. So you get A double prime, E prime and then we have a new insertion which is F, yes. Just wanna make a comment to connect some of the thoughts of the great slide. So there's a lot to follow here I think but I think the main takeaway is without hoodie then Presto is just working with files directly it has no concept of what are the changes it has no concept of how to optimize the file so that I can regrade. That's kind of the layer that hoodie is really adding here and the way that it does that it has other metadata that it knows how to work with that was kind of the hoodie file that I showed you or directory inside the data lake. So that's kind of the high level thing I wanna make sure you take away and she'll go with other table types but that's so you notice that they're all parquet but now the engine knows how to interpret these different parquet files and can do a lot more advanced kind of capabilities because of this format. And if we talk about these changes right these are updates that are happening right these are like changes that are happening so this is what's happening on the data lake but he provides that transactional guarantees.


Hi guys, welcome back to this channel. It's Meks from the Meks creation. Is it your first time please? Consider subscribing to this channel. By the way, don't forget to click that notification bell because it will be very important for you to be updated when we upload a new video. I got another question yet in the comment section and it's all about what you call, what is the role of a security guard during fire? Yes, that is the question. I think most of the time people have been demanding for me to give them the right answers. What is the role of a security guard during fire? Remember, when we are talking about a security guard, when we are looking at security and we are looking at the security guard, a security guard is just a person, may be hired by the government, this person may be hired by what you call an entity. It can be a private company to secure property, secure people's life, and also to secure information. That is what is the role of a security guard. And some of the responsibilities that we looked at earlier on, the responsibility of a security guard is supposed to be visible, is supposed to be there in times of emergency, good communication skills or could be able to communicate, should be able to protect information and should be able also to protect people's lives and property depending on where he is being posted to work. That is what you call a security guard. In today's video, let us look at the roles of a security guard looking at what does that person, what does that person is followed as a security guard do in case of fire. Remember, when we are talking about the role of fire, I want to talk about the fire. It is your responsibility as a security guard when you are doing patrol to check all the visible corners that you think can be hadas, can be disastrous, can cause dangers to what you call a client's property. So as you are patrolling, you make sure you take note of visible, you take note of all those areas. Be quite visible, be alert and look at all those areas that you think can facilitate what you call fire. And remember, it is your role as what you call a security guard to do the patrolling, to take the necessary notes and to inform the necessary or to inform the relevant authorities about that. And another thing that people forget as security guards if you are patrolling, it's all about the fire extinguishers. It's very important as a security guard to know the fire extinguishing. And know where the fire extinguishers are stationed in the building. It may not be in the building, it may be a particular allocation where you are placed to work. You should definitely know where the fire extinguisher is. That in case of an emergency, you definitely, if it is an emergency that you can attend to, it is you know where to start from. It's not all about knowing how to use the fire extinguisher but you do not know where the fire extinguisher is stationed. In buildings, in site places, in molds, in any building there must be a station for fire extinguishers. And something still I need to remind you, you should be able to know which is the function of fire extinguisher or which is how to function. You can identify by the colors. So it is your role as a security guard that in case of an emergency, in case of an emergency, you know what to do. You have a part to play in one way or the other. So we are going to look at what we call fire. What is your role in case of this fire? Remember, when we are talking about fire, we shall have to mention one word that is called race. It's called the fire action plan or the fire action which is called race. When we are talking about race, we are not meaning a human race. We are not differentiating ourselves regarding color. But in this time, we are talking about race in what you call a fire action. And each of these letters defines or it will define it will tell you what to do. It will give you an action. It is represented by an action. Let us go straight. First of all, look at letter C. Letter C is what you call rescue.  Remember, you need to alert. You also need to alert. That is letter A. You need to alert your supervisors. You need to alert the building management. You need to alert 99. You need to alert those people responsible. How do you do it by shouting? Fire, fire, fire, fire. You need to alert them. You need to let them know what is happening. That stands for letter A. You alert. You can pull what you call the alarm or what you call the, you can pull the alarm station. You can try to pull to let the building know there is fire in the building. To let people know where there is fire in the building. You are alerting. If there is need of evacuation, people start evacuating. If there is no need of evacuation, an announcement will be made three times and people will need to know there is no need to panic. There is no need to get out of the building. So you need to alert. You need to alert. It can be alert by either calling your control room, calling the immediate supervisor, calling the building management or even using what you call your radio. You use what you call the operation tools you given to you. That is why it is very important for you to move with the radio with you all the time. It is your operation tool by the way you shouldn't forget. Because in case of an emergency in that particular time, it will become very easier for you to communicate. It will become very easier for you to pass on the information. So that is your role and responsibility in case that emergency of fire comes out. Then letter C is what you call confine what you call fire. How do you confine? By closing all exit doors, try to close any door that you come across in case you can. In case you can, try to close any door that you can. Remember? It take note of this. In case you can close that to close it. Then letter C is what you call extinguish. You can either extinguish the fire. In case you feel you have enough confidence, if you feel you are confident enough to extinguish that fire, do so. If it is a minor fire and you can do it, do so. Still, if you are not confident, definitely the only way is to evacuate who you can evacuate at that particular time. Who you can help. Using the nearest case, using what you call the evacuation plan. All these buildings have what you call evacuation plans. So that is what I have to let you know. That is what you call a fire action. It is represented by risk. R meaning rescue, A meaning alert, C meaning confined, and E meaning to extinguish the fire in case you can do so. Thank you so much for coming back to this channel. Remember, it is MEX from the MEX creation. If it is your first time to come across this channel, please consider subscribing and supporting this channel. Remember? See you again in the next video. By the way, do not forget, I will put all the links in the description below. Thank you so much. See you again in the next video.


Hello there love us. This video is called the truth about my experience with birth control and much like my other truth about videos Anyways, fast forward What's important to mention that this experience that ended up having a sexual relationship with my boyfriend at the time And I was 17 you're doing the math now. That's four partners by in within a year I got like bro like I'm done with this like I'm done with interacting with with all that But it's still my experience is I'm allowed to express them how I want to and now I'm afraid to the store because I want people to come for me. It gets really raw Essentially, it is an intimate one-on-one conversation between you and I about a really intimate part of my life And there's 16 years of history for me to share on this particular topic So this video might be a little long but before we get to that I want to give a shout out to my partner on this video, which is simple help simple help essentially is an affordable Convenient as well as accessible way for people to get prescription birth control as well as home deliveries Simple helps product is not so much birth control itself It really is the hassle-free way in which you can get birth control regardless of your insurance situation Your income level or your location in layman's terms It is online prescriptions matched with free home delivery their doctors prescribe over a hundred different brands of birth control Depending on which one works for you or which one you and the doctor decide will be a best bet for you They can also prescribe the ring and the patch also if you want to know more about simple health right here right now You can just go in the info box, but I do hope you stay for the chat because I do think it will be a good one All right, so where do we start with my journey with birth control? Obviously we start at the beginning. I first had sex and used nothing No protection not from sexually transmitted infections not some from pregnancy Like a lot of people who don't know they're gonna have sex. I wasn't prepared for the moment I just found myself in a situation with someone that I was very attracted to my body had a lot of Messages a lot of urges at that present time that person felt the exact same way and it just happened now The experience itself I've detailed before in other videos was what it was But the aftermath of using nothing really was what haunted me. I didn't know where to go what to do I obviously thought I was pregnant right away So I spent the next month in complete turmoil checking my underwear constantly to see if there was going to be blood And then after I did get my period I had the still lingering stress of did I get a sexually transmitted infection from having an Unprotected intimate act with someone that I knew Relatively nothing about at the time. So after that happened I wish I could tell you that I got on the pill or I started to really like take control of my protection, but I still was that ignorant little girl who had womanly urges and I remember my mom finding a condom in my room So I went to some event where they handed them out for free and I like took that condom I put it somewhere private and for whatever reason my mom went under my bed and she found it and she pulled me aside And was like, why do you have this and I had to make up some lie about well I just got got it for free and I have it in case a friend needs it and so my singular act of I think trying to take control of my health and trying to protect myself was like heavily Discouraged and stigmatized and so I didn't look at condoms as something I should be keeping on me because the risk of getting in trouble It at a time that your teenager is actually greater than the risk of everything else that comes with it So I just kept my entire sex life a secret and birth control was a dead giveaway So I just didn't really have any part in it So the next time that I had sex was probably about a year later and it was the exact same thing It just kind of happened. I was alone with somebody who I was attracted to We started kissing and then one thing led to the other and then it just occurred now when I was younger I just really didn't understand why I was doing this, right? Like I knew Unprotected sex was bad.  It was that my body was just ready to start doing that and I wasn't prepared for that physically or I wasn't prepared for that emotionally, but that's just Why I truly believe young girls should be given the opportunity to go on birth control at that age Just because like there is another factor at play other than just sheer decision-making or logic There is something else a strong force within you and so it's just better to be safe It's whether or not you think you're ready You're supposed to be ready your body is and and that might be more of an Overwhelming feeling than you're really truly able to handle. So once again I just had sex with somebody We actually did use a condom that time that person had a condom on them But we didn't use it properly because we had never been given the education on either side how to do so as a result We were just like Unsure if it worked unsure how it's supposed to work and pretty sure that we were pregnant We had sex we finished up We looked at all of the evidence in front of us and thought I don't think we did this correctly And then went right to the clinic, which was like walking distance from my house So I knew I'm actually really grateful for that that I knew where the sexual health clinic in my neighborhood was and We do rock-paper-scissors outside for who should have to go in to get the pill like that's just how Emotionally immature and unprepared. I was at that time to deal with the consequences of being physical with somebody I Lost so I had to go by myself and he literally went home Like I lost okay now It's your responsibility and you know as a woman in many ways it truly the bulk of the responsibility Unfortunately does fall on you so when did I got the morning after pill that was the first time that I use that? Wasn't a positive experience for me. I don't remember taking it and thinking okay. I know I can do this at all times thankfully something happened Earlier in my life, which provided a lot of help for me I still struggle with this to this day, but looking back. I have also spoken to a lot of other women who feel the same way So I had acne. I have had acne since I was 14 years old I still struggle and so because I had acne I got to use birth control as Medication for that so I know I knew I needed to be on it for personal reasons But I wasn't yet at the place where I could discuss that with my family and that wasn't honest to goodness Like pretty good time in my life I still wasn't having great sex or great sexual partners like that part of things took a very long time for me to truly understand But being on the pill just provided a peace of mind That just can't put into words.  I was like, okay I am passionate about this thing and I looked forward to it for a long time and now that I'm doing it It sucks. What am I doing wrong and when I started to learn when I was doing wrong I became passionate about informing other people of the same. So during that year that I really got started in it I just wanted to be clear of mine. I didn't want any distractions And I wanted to like the next time I had sex for it to be positive so I stopped birth control and When I finally did get back on the pill again I was now in a committed relationship. The difficult thing with birth control is that like it's a process, right? You have to go to your family doctor. You have to get blood work done That can take a couple weeks to come back get your blood pressure even getting an appointment at my family doctor Like he's I've had the same doctor since I was born He doesn't like to work that much. He was an older guy. So he was in the office pretty infrequently like he took long-ass lunch breaks Like he just it's not like he was there 24-7 like a clinic So getting an appointment took some time So it's like you don't always get the birth control when you need it one of the downfalls I think of the pill is it can create a sense of false security When it comes to your health because you've taken care of the reproductive risks of being sexually active you can tend to forget about the sexual health side of things and majority of birth control aside from a condom does not cover you when it comes to sexually transmitted infections or Diseases and so you don't get to like Just let your hair down and blow in the breeze and live your best life like void of any other additional Protection like you get to be like few there's one half of things taken care of I still have to be mindful that there's a whole other important half That I also have to be mindful of so I was on birth control. I got into a relationship With someone to be honest with you guys had a reputation I was well aware of this individuals reputation But in my naivety and in my sense of like I'm different and because I know they would never try it with me like in all of those falsehoods I Very shortly after we got you know committed stopped Requesting that they use a condom and so we were just doing the do without a care in the world fast forward about Eight months afterwards. I found out that I contracted chlamydia through my monogamous relationship So that's just I've obviously told the story at great length before in other videos But just a reminder that birth control is wonderful at doing what it does You know 95 to 100% of the time if you if used correctly But that doesn't mean that it's taking care of you 100% and don't allow yourself to fall into the delusion That you've done all that you have to do so anyhow Still on birth control move out to LA now and when I moved to LA With my ex we still were you know doing the whole let's try this thing out dance But let's not be together thing, but don't see anyone else. It was just that whole confusing foolishness that occurs in Manipulative relationships to be frank about it. So I stopped being sexually active. I stopped having money more importantly I was like dead-ass broke. I had no insurance obviously in America In Canada, I wasn't under an insurance plan either and like there's this notion that everything is free in Canada Yes, if you go to the doctor, you don't pay anything But if the doctor prescribes you something there is a price tag that comes with that So birth control was not free for me and it the kind of birth control I was on wasn't the cheapest of brands So when I moved to America, I just decided to give that a hiatus and I wasn't on birth control for like two years I wasn't sexually active. I was sexually active with my ex whenever I went back to Canada Sometimes he came and visited me we were better about using condom at that time because I was fully less delusional I just it was almost one of those things were like I completely knew what it was but I wasn't ready to like remove myself from it But at least I had the smarts to protect myself in some capacity from it So when I finally got rid of that which took me a very long time to get out of the emotional entanglement of that relationship I knew I was ready for like a fresh start and I knew I was ready for like a healthy consenting awesome Relationship that made me feel as incredible as I did. I left that relationship Feeling I mean, there's not a video about that. So we'll just skip that part, but I met Jared about a month after like I completely called it quits there and we just really wanted to engage in a Healthy reciprocal sexual relationship at that time. That was a priority for both of us. We aligned on that We had incredible physical chemistry and so I feel really fortunate to have linked up with him at that time It's so funny because Jared was my first like official friends with benefits I think in the past I had been in friends with benefits situations that like weren't totally consensual like we were friends with benefits But like I was hoping for more where I was in the friends with benefits under the guise that eventually it would develop when me and Jared Connected we really wanted nothing else. There was really 100% from both angles like a complete Acceptance of like this is what it is and we're gonna make it the best that it possibly can be without expecting that to bloom into something more And so because the sex was so great and the connection was so great I just also really wanted to get rid of the reproductive stress side of things because it was friends and benefits like that's probably the worst situation in which In my perspective, I could enter into family planning with somebody So I did something that I'd wanted to do for a really long time, which was get an IUD And oh my gosh, I love my IUD. I wear my IUD necklace just in ode to like what a great addition to my life this was Because it just worked with me. I think birth control is a lot like a lot of other things in life You know career or romantic partners some things just go with you and some things just don't For a lot of people the IUD does not go with them And I'm sure I'll hear all about in the comment section But for me almost as soon as it was placed in like it was just a godsend to me Jared and I still use condoms because of the fact once again that We were not in a committed relationship and I learned from my past mistakes. Also, he is incredible about sexual health I will say that I've never met a man before who takes their health as seriously as he did He got checkups once every three months He was really like litigious about checking the condoms and about making sure that we had them And he also brought a lot of joy to my life with condom use like he would have different kinds and like invest in pleasure packs and so that was a really cool thing as well too where Sexual health became like a fun addition to our relationship for the male. I got a urine and a blood test Wash your hands with warm water for 30 seconds. Shake hands to get the blood flowing We just watched though We shake in 2016 Yeah, 2016 I'm on the IUD. I'm with Jared. We are in a really great flow sexual health And then for some reason My acne just starts exploding again So up until that time because I'd been on and off the pill For so long like my acne had become pretty manageable But with now me being off of it for two years and doing nothing I'm expecting because I'm in my 30s now like this is a thing of the past and then my skin is like Oh, definitely not so I start breaking out again Now mind you I've had acne since I was 14 years old that being said I have done it all So please all of the black soaps all of the dairy-free diets all the sugar-free diets All of the castor oil the oil pulling the different gel the acutane The oatmeal remedies I have done them all apple cider vinegar tea tree oil Literally nothing has worked for me other than acutane, which I would never do again I got great results from it awesome, but There's just so many potential side effects and using it a second time the side effects increase that much more So if that that trade-off is not worth it for me Birth control on the other hand that trade-off is worth it for me And that is what's worked for me every single time and I actually learned why I produce a lot of androgens my body is a little bit more rich with testosterone than the average woman As a result of that when I'm on birth control specifically birth controls that suppress androgens Um, I don't get the outbreaks in the same way And so at the time I was on two birth controls the iud which is non-hormonal because I use the paragard Which is the copper one and then I was back to being on sayestra Which was the hormonal uh birth control that allowed my skin to clear up And that's where I currently am right now the war against reproductive rights just seems crazy to me Because it's a basic human right to be able to decide and to be able to protect And to treat your body as you see fit of course to reflect what you want for your future and to Your potential family's future So I can't imagine why this is a war But it does exist and we can't ignore that and I'm always looking for ways to get involved And I'm grateful to be surrounded by organizations and companies like simple help who are doing something about it And so simple health is a really great option for anybody who has never done birth control before been on it And wants to find a discreet hassle free way to start somebody who is off birth control currently But has been on it before but hasn't gotten around to making that doctor's appointment Or to going through those extra steps and finally if you're on birth control right now And you have a pharmacy is all you know neatly tied up in a bow If you just want to cut out that extra step of having to drive and pick up your prescription Simple health again provides free home delivery so you can reroute it so that it's just being sent directly to you Again in discreet packaging right to your home So you never have those days where you should be on the pill but you're not because there is that extra barrier between you and You're right to decide what happens to your body And that's what i'm really passionate about Helping people to make the best most informed decision about their reproductive future and then finding tools that support that decision If this seems like the right tool for you Then here is an extra benefit to using it when you go to simple health com slash shan You can use a coupon there to get the free annual prescription Completely just for people who use that code So all you have to take care of after you put in that promotional code is the cost of the actual birth control Which again if you have an insurance provider is probably free for you So you don't have the annual fee You don't have to pay for the prescription if you have insurance if you do you just pay that And then the home delivery is free for everyone So if that is something that you would consider go in the info box to learn more about them And finally in the comment section below, I would love to hear What has been the truth about your birth control experience? What has been your journey and where are you currently on that path? You know, what is your system right now? And if you're still figuring it out Let me know how I can help you get to that space of complete joy Because this this truly should be a joyful part of our lives. I think