<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Jim, those are good points. <div class=""><br class=""></div><div class="">On the second point, though, I think even if the actual trend line ends up looking similar, there is a good story to be told:</div><div class=""><ul class="MailOutline"><li class="">City human services spending has risen in the context of cuts to human services spending at other levels of gov’t (per McGinn’s email), so cities like Seattle are shouldering more of that role.</li><li class="">Because of rising rents and income inequality over the past decade, there is way more work to be done in this area, and the spending hasn’t nearly kept up.</li><li class="">By contrast, crime has not been increasing appreciably. In fact, there’s a decades-long trend of falling crime.</li><li class="">Because we’re not funding appropriate responses to poverty and homelessness, we end up funding more police to deal with the social disorder that results from this failure. In other words, we criminalize poverty.</li></ul><div class=""><br class=""></div><div class="">But clearly this story is a little complicated, and you can’t tell it in a single graph.</div><div class=""><br class=""></div><div class="">I am working on writing something about the police budget and I would also like to start sharing some of our work with the defund SPD folks. Because we haven’t yet figured out the best way to present HSD numbers, <b class="">Jim, could you make a page just containing the SPD graph starting in 2012 (in whatever type of visual you think is most compelling)</b>, so I can link to it from my article and also share it with our allies? I think we should use 2012 as the starting point rather than 2008 or 2012 because it’s a low point for the inflation-adjusted and per capita numbers, and also 8 years is a nice round number in political terms. Spearking of per capita numbers, <b class="">could you also make a graph (maybe a bar graph?) showing the per capita figures from 2012 to 2020?</b> That could go on the same page I think.</div><div class=""><br class=""></div><div class="">- Katie</div><div class=""><br class=""><div class=""><div><blockquote type="cite" class=""><div class="">On Jun 11, 2020, at 5:49 PM, Jim Walseth <<a href="mailto:jim.walseth@gmail.com" class="">jim.walseth@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">Regarding the pass through line item, here are two considerations:</div><div class="">1. RIght now the data attribution is simply
<div style="margin: 0px; text-indent: 0px; white-space: pre-wrap;" class=""><span style="font-family:"Tableau Book";font-size:12pt;color:rgb(102,102,102)" class="">"From the CIty of Seattle budget archives </span><span style="font-family:"Benton Sans Book";font-size:12pt;text-decoration:underline;color:rgb(0,0,255)" class=""><a href="https://www.seattle.gov/city-budget-office/budget-archives" class="">https://www.seattle.gov/city-budget-office/budget-archives</a>, </span><span style="font-family:"Tableau Book";font-size:12pt;color:rgb(102,102,102)" class="">adjusted for inflation."</span></div>If we start tinkering with the numbers the attribution should explain what we did it and might appear to the casual reader that we are "juking the stats".</div><div class="">But in reality...<br class=""></div><div class="">2. If removing the pass through has the effect of removing the 'bump' in early years, the Human Services<b class=""> trend line </b>will look a lot more like the SPD one.<br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 11, 2020 at 5:16 PM Katie Wilson <<a href="mailto:katie@transitriders.org" class="">katie@transitriders.org</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: break-word;" class="">One more thought on the human services data, remembering what I found out before about the $26 million dip from 2011 to 2012, <a href="https://www.seattle.gov/Documents/Departments/FinanceDepartment/12adoptedbudget/HealthHumanServices_2012AdoptedBudget_000.pdf" target="_blank" class="">as explained here</a>:<div class=""><div class=""><div class=""><br class=""></div></div></div><blockquote style="margin:0px 0px 0px 40px;border:medium none;padding:0px" class=""><div class=""><div class=""><div class="">"While the 2012 Adopted Budget preserves and increases General Fund support for HSD, the Department is experiencing reductions in State and Federal funding. The 2012 Adopted Budget recognizes impacts from changes in State funding in the Aging and Disability Services Division. Beginning in October 2011, <b class="">pass-through funding for home care program health plan reimbursements is redirected to home care agencies and is no longer administered by HSD, resulting in a significant budget reduction to HSD but no impact on direct services, as it was a change to the method of payment.</b></div></div></div></blockquote><div class=""><div class=""><div class=""><div class=""></div><div class=""><br class=""></div><div class="">Given that this is an accounting thing, it seems like maybe we should try adjusting the 2008-2011 numbers so that they don’t include this line item, which (it sounds like) doesn’t appear in the later years (unless it was added back in at some point)?</div><div class=""><br class=""></div></div></div><div class=""><blockquote type="cite" class=""><div class="">On Jun 11, 2020, at 2:07 PM, Jim Walseth <<a href="mailto:jim.walseth@gmail.com" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:</div><br class=""><div class=""><div dir="ltr" class="">Tip: you can go to <a href="https://public.tableau.com/profile/katie.wilson8886#!/" target="_blank" class="">https://public.tableau.com/profile/katie.wilson8886#!/</a> to browse all the samples.<br class=""></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 11, 2020 at 1:51 PM Jim Walseth <<a href="mailto:jim.walseth@gmail.com" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" class=""><div class="">Here's another version. Personally I find the filled overlay a bit misleading in the sense that the Human Services polygon covers part of the SPD spend, making it visually smaller.</div><div class="">Here is the same viz just using lines.</div><div class=""><a href="https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample6/Dashboard3?publish=yes" target="_blank" class="">https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample6/Dashboard3?publish=yes</a></div><div class=""><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 11, 2020 at 1:03 PM Jim Walseth <<a href="mailto:jim.walseth@gmail.com" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" class=""><div class="">Katie, Taking a stab at your request:</div><div class=""><a href="https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample5/Dashboard3?publish=yes" target="_blank" class="">https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample5/Dashboard3?publish=yes</a></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 11, 2020 at 11:43 AM Katie Wilson <<a href="mailto:katie@transitriders.org" target="_blank" class="">katie@transitriders.org</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="">Looking good Jim! Visually I think I like the first graph better than the bar graph— is there a way to overlay the human services budget on that one in the same manner?<div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Jun 11, 2020, at 10:38 AM, Jim Walseth <<a href="mailto:jim.walseth@gmail.com" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:</div><br class=""><div class=""><div dir="ltr" class=""><div class="">I fussed with both of those some more. I'm going back to my day job now and will check in later for feedback.</div><div class="">Jim<br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 11, 2020 at 9:25 AM Jim Walseth <<a href="mailto:jim.walseth@gmail.com" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" class=""><div class="">Fantastic work on the spreadsheet. Here are updates to the two vizzes I made yesterday, using inflation-based numbers. <br class=""></div><div class="">I also added data attribution, fixed up labels and things like that. Happy to make any changes that I am able to make!<br class=""></div><div class=""><br class=""></div><div class=""><a href="https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample3/Dashboard1?publish=yes" target="_blank" class="">https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample3/Dashboard1?publish=yes</a></div><div class=""><br class=""></div><div class=""><a href="https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample4/SeattleCumulativeSpending?publish=yes" target="_blank" class="">https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample4/SeattleCumulativeSpending?publish=yes</a></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 11, 2020 at 7:30 AM Katie Wilson <<a href="mailto:katie@transitriders.org" target="_blank" class="">katie@transitriders.org</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=""><div class="">Re what police do with their time… This guy Bryan Kirschner who’s a tech employee (he’s the one organizing the Tech4Recovery group) used to do community policing work & he’s writing a series about policing/public safety. He sent me <a href="https://medium.com/@contact_28544/everything-you-know-about-policing-is-wrong-part-1-2639186e101e" target="_blank" class="">a link to this piece</a> which I found enlightening.</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On Jun 11, 2020, at 1:02 AM, Douglas Sexton <<a href="mailto:sextondouglas@comcast.net" target="_blank" class="">sextondouglas@comcast.net</a>> wrote:</div><br class=""><div class="">
<div class="">
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)" class="">
<span style="font-family:arial,helvetica,sans-serif" class="">Jumping off of Harry's last contribution.I tied to get homeless data for Seattle from 2008-2019 using the point in time count but there are years that only have data for King County and not specifically Seattle. Additionally as the years go on more areas are searched resulting in more thorough higher counts but I think the methodology in the last 3 years is relatively consistent. I added a column for King County # unsheltered homeless which was the only consistent measure I could find (though early years look very undercounted). A rough rule of thumb is ~60% of the count is Seattle. It's definitely unclear on if investment in housing helped with the deceleration of homelessness in the latest years but it sure is clear that police aren't helping.</span>
<br class="">
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)" class="">
<span style="font-family:arial,helvetica,sans-serif" class=""><br class=""></span>
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)" class="">
<span style="font-family:arial,helvetica,sans-serif" class="">The salary per cop stat is super compelling to me. Maybe a breakdown of what a cop gets paid as a percentage of how their time is actually spent would be interesting.Thinking about that confessions of a bastard cop post that has been going around recently (<a href="https://medium.com/@OfcrACab/confessions-of-a-former-bastard-cop-bb14d17bc759" target="_blank" class="">https://medium.com/@OfcrACab/confessions-of-a-former-bastard-cop-bb14d17bc759</a>). My understanding is a lot of the time these cops might be responding to crimes after they happen and not catching anyone and possibly creating unnecessary citations.You have to click the "all other crime" stats on the dashboard here (<a href="http://www.seattle.gov/police/information-and-data/crime-dashboard" target="_blank" class="">http://www.seattle.gov/police/information-and-data/crime-dashboard</a>) and one thing that jumps out is there are as almost as many trespassing crimes as violent crimes so far in 2020. That seems... odd (unless you already know cops exist to protect property interests). Maybe I can dig into that more later.<br class=""></span>
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)" class="">
<span style="font-family:arial,helvetica,sans-serif" class=""><br class=""></span>
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)" class="">
<span style="font-family:arial,helvetica,sans-serif" class="">Doug<br class=""></span>
</div>
<blockquote type="cite" class="">
On June 10, 2020 at 10:38 PM Harry Maher <<a href="mailto:harryb.maher@gmail.com" target="_blank" class="">harryb.maher@gmail.com</a>> wrote:
<br class="">
<br class="">
<div dir="ltr" class="">
Cool graphs, thanks, Jim! And yep, you're right re: inflation, Katie. I added that and the rest of the annual budgets.
<div class="">
<br class="">
</div>
<div class="">
I also looked at inflation adjusted $/population in another set of columns. I was thinking that, in addition to inflation, it might make sense to normalize things by population growth as well. To Jim's point, they are all experiencing the same population growth, but to Katie's point, the narrative can change/get a sense of clarity when you normalize the #s. (Or, at the very least, we can just report the amount that population has increased over the same period b/c there remains the open question if normalizing budget by population makes as much sense for all of these programs--if the cops are smart, they may argue that they "need to patrol" both ppl who live here as well as those visiting from surrounding areas for work/tourism/crime/etc., while housing and human services would mostly only serve Seattle residents.)
</div>
<div class="">
<br class="">
</div>
<div class="">
Anyway, when we look at inflation adjusted $ spent per resident, it looks like we were defunding human services for a while there and essentially barely changing funding for housing over the years while substantially increasing funding for the police. We can look at the # of folks experiencing homelessness in Seattle over the same period and the # of Seattlites estimated to be rent burdened or severely rent burdened (both I assume have increased substantially more than population growth) to add to a compelling story. That said, it's also a little misleading when we can't use 2020 numbers due to a lack of 2020 population estimates from the Census thus far (and 2020 is the year they increased funding for human services and housing).
</div>
<div class="">
<br class="">
</div>
<div class="">
Another thought on the fact that salaries make up ~80% of the budget and will need to get cut, or personnel will need to get laid off: we can likely get some good traction if we compare what cops earn to what human services and housing employees earn. Something like, "for each cop that we have to lay off, we can hire 2 essential housing employees" or whatever the actual number is.
</div>
<div class="">
<br class="">
</div>
<div class="">
<br class="">
</div>
</div>
<br class="">
<div class="">
<div dir="ltr" class="">
On Wed, Jun 10, 2020 at 9:16 PM Katie Wilson <
<a href="mailto:katie@transitriders.org" rel="noopener" target="_blank" class="">katie@transitriders.org</a>> wrote:
<br class="">
</div>
<blockquote class="">
<div class="">
One reason I’m interested is that I’m pretty sure once you adjust for inflation, human services spending is more or less flat between 2010 and 2018 (taking into account the 2011-2012 dip which is an accounting thing), and I think that’s a good story to tell.
<div class="">
<br class="">
</div>
<div class="">
<br class="">
<blockquote type="cite" class="">
<div class="">
On Jun 10, 2020, at 7:46 PM, Jim Walseth <
<a href="mailto:jim.walseth@gmail.com" rel="noopener" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:
</div>
<br class="">
<div class="">
<div class="">
<div dir="auto" class="">
Yes I filtered the data to start at 2013 because only the spd data exists from years before that in the spreadsheet. Once we have housing and services data for all years I can open it up.
</div>
</div>
<div dir="auto" class="">
<br class="">
</div>
<div dir="auto" class="">
I question whether inflation is needed when doing comparison since all would be affected. But yeah I always appreciate that effort.
</div>
<div dir="auto" class="">
<br class="">
</div>
<div dir="auto" class="">
Jim
</div>
<div class="">
<br class="">
<div class="">
<div dir="ltr" class="">
On Wed, Jun 10, 2020 at 7:19 PM Katie Wilson <
<a href="mailto:katie@transitriders.org" rel="noopener" target="_blank" class="">katie@transitriders.org</a>> wrote:
<br class="">
</div>
<blockquote class="">
<div class="">
Cool!!
<div class="">
<br class="">
</div>
<div class="">
Jim, on the bar graph in the first link, is there a reason you started with 2013 instead of 2008 or 2010?
<br class="">
<div class="">
<br class="">
</div>
<div class="">
I think we should play around with adjusting for inflation, too, perhaps using this:
<a href="https://www.usinflationcalculator.com/" rel="noopener" target="_blank" class="">https://www.usinflationcalculator.com</a>
<br class="">
</div>
<div class="">
</div>
<div class="">
I would be interested in seeing that bar graph starting in 2008 and adjusting for inflation (to 2020 dollars, I guess).
</div>
</div>
</div>
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<br class="">
</div>
<div class="">
<br class="">
<blockquote type="cite" class="">
<div class="">
On Jun 10, 2020, at 7:10 PM, Jim Walseth <
<a href="mailto:jim.walseth@gmail.com" rel="noopener" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:
</div>
<br class="">
<div class="">
<div dir="ltr" class="">
<div class="">
Ooh I'm liking this
</div>
<div class="">
<br class="">
</div>
<div class="">
Sample 2
</div>
<div class="">
<br class="">
</div>
<div class="">
<a href="https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample2/SeattleCumulativeSpending?publish=yes" rel="noopener" target="_blank" class="">https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample2/SeattleCumulativeSpending?publish=yes</a>
<br class="">
</div>
</div>
<br class="">
<div class="">
<div dir="ltr" class="">
On Wed, Jun 10, 2020 at 6:55 PM Jim Walseth <
<a href="mailto:jim.walseth@gmail.com" rel="noopener" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:
<br class="">
</div>
<blockquote class="">
<div dir="ltr" class="">
I made it "tall" so scroll down to see part 2. This seems to be the fashion with web stuff now, rather than tabs, for instance.
<br class="">
</div>
<br class="">
<div class="">
<div dir="ltr" class="">
On Wed, Jun 10, 2020 at 6:53 PM Jim Walseth <
<a href="mailto:jim.walseth@gmail.com" rel="noopener" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:
<br class="">
</div>
<blockquote class="">
<div dir="ltr" class="">
<div class="">
First sample viz
</div>
<div class="">
<br class="">
</div>
<div class="">
<a href="https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample1/Dashboard1?publish=yes" rel="noopener" target="_blank" class="">https://public.tableau.com/profile/katie.wilson8886#!/vizhome/SPDBudgetsample1/Dashboard1?publish=yes</a>
<br class="">
</div>
</div>
<br class="">
<div class="">
<div dir="ltr" class="">
On Wed, Jun 10, 2020 at 6:52 PM Harry Maher <
<a href="mailto:harryb.maher@gmail.com" rel="noopener" target="_blank" class="">harryb.maher@gmail.com</a>> wrote:
<br class="">
</div>
<blockquote class="">
<div dir="ltr" class="">
<div class="">
Omg Ben. WHAT?
</div>
<div class="">
<br class="">
</div>
<div class="">
And ok, I've been lazily plugging in numbers while listening to the radio and now preparing dinner, hope to be done at some point, but feel free to jump in anyone who wants this done more quickly...
<br class="">
</div>
<div class="">
<br class="">
</div>
<div class="">
And that's great, Jim!!
<div class="">
<br class="">
</div>
</div>
<div class="">
<div class="">
<br class="">
</div>
<div class="">
Some notes:
</div>
<div class="">
- These pdfs are still v. opaque and we may have to wait until we get more specific details from the city council. Definitely no line item for "military weapons" or other definite cuts...
</div>
<div class="">
- Personnel was 80% of the $398,561,697 budget in 2019 (I can't quickly find the % for 2020) and they report 2,172.35 FTE (with an asterisk that it's approximated, but...). That puts the average salary at $146,776 if I'm not mistaken. That's insane. I get that it's a hard job, but yeesh, also supposedly one of public service. Since they are city employees, I bet we'd be able to look at individual salaries and look at how overtime pay is allocated b/c I know that they get a huge chunk of their pay from overtime. I'm sure getting rid of overtime pay will go a very long way towards reducing the budget, but have no numbers to back that right now.
<br class="">
</div>
<div class="">
- Slightly in jest, but... maybe we can completely slash the budget for East Precinct in addition to overtime cuts and see where that gets us. Keep on the facilities/maintenance/custodial staff, see what the Black community wants to do with the building, and reallocate those workers to the appropriate division(s).
</div>
</div>
</div>
<br class="">
<div class="">
<div dir="ltr" class="">
On Wed, Jun 10, 2020 at 6:30 PM Jim Walseth <
<a href="mailto:jim.walseth@gmail.com" rel="noopener" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:
<br class="">
</div>
<blockquote class="">
<div dir="ltr" class="">
<div class="">
I am throwing this into Tableau Public and will make a few basic samples. I removed the first row which just said "adopted budget numbers" because it was confusing Tableau.
</div>
<div class="">
Jim
<br class="">
</div>
</div>
<br class="">
<div class="">
<div dir="ltr" class="">
On Wed, Jun 10, 2020 at 3:53 PM Katie Wilson <
<a href="mailto:katie@transitriders.org" rel="noopener" target="_blank" class="">katie@transitriders.org</a>> wrote:
<br class="">
</div>
<blockquote class="">
<div class="">
Hey folks,
<div class="">
<br class="">
</div>
<div class="">
Since the Open Data site is unreliable, it looks like our best bet for accurate budget data is the PDFs archived here:
<a href="https://www.seattle.gov/city-budget-office/budget-archives" rel="noopener" target="_blank" class="">https://www.seattle.gov/city-budget-office/budget-archives</a>
<br class="">
</div>
<div class="">
<br class="">
</div>
<div class="">
Here is a mini-project if anyone has time for it.
<a href="https://docs.google.com/spreadsheets/d/1uDjqVID4gkBFfatMTM-hUbO-OAzR70Zc1-3GJEFZask/edit?usp=sharing" rel="noopener" target="_blank" class="">I created a spreadsheet here</a>, where we can compile data from the
<strong class="">adopted budgets </strong>(not proposed or endorsed) for SPD, human services, housing, and any other areas of interest. I think the years 2010-2020 are key, but I’ve started the spreadsheet in 2008 just to match with the recession, in case that shows us anything interesting. Filling out this spreadsheet will enable us to make a graph like the ones we were making from the Open Data site, only correct this time.
</div>
<div class="">
<br class="">
</div>
<div class="">
I am in touch with some of the folks leading the Defund SPD effort and they would love our help digging up data and making graphs etc. that tell a good story to boost the case. So, rest assured our work on this will be useful and appreciated! For example, I was able to send along this bit earlier today, which I believe was then passed along to a councilmember via a council aide to be shared aloud during the council meeting this afternoon:
</div>
<div class="">
<br class="">
</div>
<blockquote class="">
<div class="">
<div class="">
The SPD budget has
<strong class="">increased by </strong>
<strong class="">43% since 2010</strong>,
<em class="">after</em> you account for inflation. (Not accounting for inflation, it’s a 68% increase.)
</div>
</div>
<div class="">
<div class="">
<br class="">
</div>
</div>
<div class="">
<div class="">
Here’s the math and sources:
</div>
</div>
<div class="">
<div class="">
<br class="">
</div>
</div>
<div class="">
<div class="">
2020 SPD adopted budget:
<strong class="">$409 million</strong> -
<a href="https://www.seattle.gov/Documents/Departments/FinanceDepartment/20adoptedbudget/SPD.pdf" rel="noopener" target="_blank" class="">https://www.seattle.gov/Documents/Departments/FinanceDepartment/20adoptedbudget/SPD.pdf</a>
<br class="">
</div>
</div>
<div class="">
<div class="">
<br class="">
</div>
</div>
<div class="">
<div class="">
2010 SPD adopted budget:
<strong class="">$243 million</strong> -
<a href="https://www.seattle.gov/Documents/Departments/FinanceDepartment/10adoptedbudget/PUBLIC_SAFETY.pdf" rel="noopener" target="_blank" class="">https://www.seattle.gov/Documents/Departments/FinanceDepartment/10adoptedbudget/PUBLIC_SAFETY.pdf</a>
<br class="">
</div>
</div>
<div class="">
<div class="">
<br class="">
</div>
</div>
<div class="">
<div class="">
2010 SPD adopted budget, injusted for inflation to 2020 dollars:
<strong class=""> $286 million</strong> -
<a href="https://www.usinflationcalculator.com/" rel="noopener" target="_blank" class="">https://www.usinflationcalculator.com</a>
<br class="">
</div>
</div>
<div class="">
<div class="">
<br class="">
</div>
</div>
<div class="">
<div class="">
Increase from 2010 to 2020, i.e. 286 to 409, is (409 - 286)/286 x 100 =
<strong class="">43%</strong>
</div>
</div>
</blockquote>
<div class="">
<br class="">
</div>
<div class="">
- Katie
</div>
<div class="">
<div class="">
<br class="">
</div>
<div class="">
<br class="">
<blockquote type="cite" class="">
<div class="">
On Jun 9, 2020, at 5:34 PM, Katie Wilson <
<a href="mailto:katie@transitriders.org" rel="noopener" target="_blank" class="">katie@transitriders.org</a>> wrote:
</div>
<br class="">
<div class="">
<div class="">
<div class="">
Budget office director to the rescue, kind of...
</div>
<div class="">
<br class="">
<blockquote type="cite" class="">
<div class="">
Begin forwarded message:
</div>
<br class="">
<div style="margin:0px" class="">
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class=""><strong class="">From: </strong></span>
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class="">"Noble, Ben" <<a href="mailto:Ben.Noble@seattle.gov" rel="noopener" target="_blank" class="">Ben.Noble@seattle.gov</a>><br class=""></span>
</div>
<div style="margin:0px" class="">
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class=""><strong class="">Subject: </strong></span>
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class=""><strong class="">RE: Discrepencies between Budget Archives and Open Data</strong><br class=""></span>
</div>
<div style="margin:0px" class="">
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class=""><strong class="">Date: </strong></span>
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class="">June 9, 2020 at 5:31:02 PM PDT<br class=""></span>
</div>
<div style="margin:0px" class="">
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class=""><strong class="">To: </strong></span>
<span style="font-family:-webkit-system-font,"Helvetica Neue",Helvetica,sans-serif" class="">Katie Wilson <<a href="mailto:katie@transitriders.org" rel="noopener" target="_blank" class="">katie@transitriders.org</a>><br class=""></span>
</div>
<br class="">
<div class="">
<div style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none" class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
Katie – long and painful story here, but the Open Data site is not accurate. I am frankly embarrassed by that reality. Short-term we may take down the site, but obviously that is not a positive step in terms of transparency. It was something that got set up in a rush a few years back and has been neglected since (and frankly has not been a priority in the last few months). I say that by way of explanation not excuse. In the term, the Budget Archives, while clunky, are the right source. Based on your flagging of the issue, I have just asked the team whether we can get something else up in the near-term. I will keep you posted.
<u class=""></u>
<u class=""></u>
</div>
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
-ben.
<u class=""></u>
<u class=""></u>
</div>
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
<div class="">
<div style="border-style:solid none none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in" class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<strong class="">From:</strong> Katie Wilson <
<a style="color:blue;text-decoration:underline" href="mailto:katie@transitriders.org" rel="noopener" target="_blank" class="">katie@transitriders.org</a>>
<br class="">
<strong class="">Sent:</strong> Tuesday, June 9, 2020 4:29 PM
<br class="">
<strong class="">To:</strong> Noble, Ben <
<a style="color:blue;text-decoration:underline" href="mailto:Ben.Noble@seattle.gov" rel="noopener" target="_blank" class="">Ben.Noble@seattle.gov</a>>
<br class="">
<strong class="">Subject:</strong> Discrepencies between Budget Archives and Open Data
<u class=""></u>
<u class=""></u>
</div>
</div>
</div>
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
<div style="border:1pt solid rgb(156,101,0);padding:2pt" class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif;text-align:center;line-height:12pt;background-color:rgb(255,235,156)" class="">
<strong class=""><span style="font-size:10pt;color:rgb(156,101,0)" class="">CAUTION: External Email<u class=""></u><u class=""></u></span></strong>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
Hi Ben,
<u class=""></u>
<u class=""></u>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
Sorry to bother you with this, but I emailed the Open Data people first and they told me to ask the City Budget Office. I’m wondering why there are significant discrepencies between the
<a style="color:blue;text-decoration:underline" href="https://www.seattle.gov/city-budget-office/budget-archives" rel="noopener" target="_blank" class="">Budget Archives</a> and the budget numbers on the
<a style="color:blue;text-decoration:underline" href="https://openbudget.seattle.gov/#!/year/default" rel="noopener" target="_blank" class="">Open Data site</a>.
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
To give one timely example,
<a style="color:blue;text-decoration:underline" href="https://openbudget.seattle.gov/#!/year/2020/operating/0/department/Police/0/service?vis=barChart" rel="noopener" target="_blank" class="">this Open Data page</a> puts the 2020 SPD budget at ~$357m, whereas the number in the
<a style="color:blue;text-decoration:underline" href="https://www.seattle.gov/Documents/Departments/FinanceDepartment/20adoptedbudget/SPD.pdf" rel="noopener" target="_blank" class="">2020 adopted budget</a> and reported in
<a style="color:blue;text-decoration:underline" href="https://www.seattletimes.com/seattle-news/crime/after-days-of-seattle-protests-city-will-withdraw-request-to-remove-police-force-from-federal-oversight/" rel="noopener" target="_blank" class="">various news articles</a> is $400m+. I have been digging around and making graphs and there are a lot of discrepencies like this. I understand that proposed and adopted and actual budgets are all different, but that doesn’t seem to account for it.
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
Please feel free to direct me elsewhere if there’s someone else I should be asking about this.
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
Thanks!
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
Katie
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<u class=""></u>
<u class=""></u>
</div>
<div class="">
<div class="">
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(102,102,102)" class="">Katie Wilson</span>
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(102,102,102)" class="">General Secretary</span>
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(102,102,102)" class="">Transit Riders Union</span>
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(102,102,102)" class=""><a style="color:blue;text-decoration:underline" href="https://protect2.fireeye.com/v1/url?k=23520a2f-7de29737-2352229f-86b2e136ff17-644b0fdb8c75a238&q=1&e=c19e905a-6ec5-4436-a6cd-f7acc13cf097&u=https%3A%2F%2Ftransitriders.org%2F" rel="noopener" target="_blank" class="">https://transitriders.org</a></span>
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(102,102,102)" class="">206-781-7204</span>
<u class=""></u>
<u class=""></u>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(34,34,34)" class=""><u class=""></u> <u class=""></u></span>
</div>
</div>
<div class="">
<div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" class="">
<em class=""><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(153,153,153)" class="">The Transit Riders Union is a democratic organization of working and poor people, including students, seniors, and people with disabilities, taking control over our own lives, and building up the power we need to change society for the good of humanity and of the planet. We will fight to preserve, expand, and improve the public transportation system in Seattle and beyond, so that every human being has access to safe, affordable, and reliable public transit.</span></em>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
<br class="">
</blockquote>
</div>
<br class="">
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</blockquote>
</div>
<br class="">
</blockquote>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)" class="">
<br class="">
</div>
</div>
</div></blockquote></div><br class=""></div><br class="">
</blockquote></div>
</blockquote></div>
</div></blockquote></div><br class=""></div></div></blockquote></div>
</blockquote></div>
</blockquote></div>
</div></blockquote></div><br class=""></div></div></blockquote></div>
</div></blockquote></div><br class=""></div></div></div></body></html>