<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body dir="auto"><div dir="auto">Hey Katie</div><div dir="auto"><br></div><div dir="auto">Did a cursory look and this seems like it should be pretty doable and I could write a script after work today. I see my tru profile already has my seattle city council district though so is this not info we already have?</div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Doug</div><div dir="auto"><br></div><div><br></div><div align="left" dir="auto" style="font-size:100%;color:#000000"><div>-------- Original message --------</div><div>From: Katie Wilson <katie@transitriders.org> </div><div>Date: 1/7/21 1:52 PM (GMT-08:00) </div><div>To: research@transitriders.org </div><div>Subject: [TRU Research] District mapping question </div><div><br></div></div>Hi all,<div class=""><br class=""></div><div class="">Happy new year, research & data team! I have a question I thought someone in this group might be able to help with. In preparation for the state legislative session, we’re trying to group TRU’s membership by legislative district, so that we can more effectively advocate with individual legislators. We have up-to-date address information for most TRU members, I think. But we haven’t mapped this onto districts yet.</div><div class=""><br class=""></div><div class="">King County has <a class="" href="https://www.kingcounty.gov/depts/elections/elections/maps/find-my-districts.aspx">a district finder here</a> where you can put in your address and it will spit out your state, county and city districts. We can do this manually for each member, but it will be a bit of a chore. Is there a faster / more automatic way to get this done? It would be awesome to be able to feed in bulk address data and end up with a .csv or something with columns for state, county and city district.</div><div class=""><br class=""></div><div class="">Katie</div><div class=""><br class=""><div class="">
<div class="" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" dir="auto"><div class="" style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><span class="" style="color: rgb(102, 102, 102); font-family: arial, sans-serif; font-size: 13px;">Katie Wilson</span></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><font class="" color="#666666">General Secretary</font></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><font class="" color="#666666">Transit Riders Union</font></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><font class="" color="#666666"><a class="" href="https://transitriders.org">https://transitriders.org</a></font></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><span class=""><font class="" color="#666666">206-781-7204</font></span></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><font class="" color="#999999"><br class=""></font></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><i class=""><font class="" color="#999999">The Transit Riders Union is a democratic organization of working and poor </font></i><i class=""><font class="" color="#999999">people, including students, seniors, and people with disabilities, taking control over our own lives, and building up the power we </font></i><i class=""><font class="" color="#999999">need to change society for the good of humanity and of the planet. We will </font></i><i class=""><font class="" color="#999999">fight to preserve, expand, and improve the public transportation system in </font></i><i class=""><font class="" color="#999999">Seattle and beyond, so that every human being has access to safe, </font></i><i class=""><font class="" color="#999999">affordable, and reliable public transit.</font></i></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><i class=""><font class="" color="#999999"><br class=""></font></i></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;" class=""><i class=""><font class="" color="#999999"><span class="" style="caret-color: rgb(0, 0, 0); font-style: normal;">I also write </span><a class="" style="caret-color: rgb(0, 0, 0); font-style: normal;" href="https://crosscut.com/author/katie-wilson">opinions</a><span class="" style="caret-color: rgb(0, 0, 0); font-style: normal;"> for Crosscut. </span></font></i><i style="caret-color: rgb(34, 34, 34);" class=""><font class="" color="#999999"><span style="caret-color: rgb(0, 0, 0); font-style: normal;" class="">Sign up for my newsletter </span><a style="caret-color: rgb(0, 0, 0); font-style: normal;" class="" href="http://eepurl.com/g_D3nf">here</a>.</font></i></div></div></div></div></div>
</div>
<br class=""></div></body></html>