<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="">Awesome, thanks Doug! Yes, we have a field in the current form for Seattle City Council district, though it’s not filled in for everyone. (For example, I just checked my profile, and although my address is there the district field is blank.) But at this point we will want to add fields for county district and state leg district. In the upcoming session, it will be that last one that counts. (And I guess it wouldn’t hurt to throw congressional in there for good measure.)<div class=""><br class=""></div><div class="">Katie<br class=""><div class=""><br class=""><div class=""><div><blockquote type="cite" class=""><div class="">On Jan 7, 2021, at 2:20 PM, sextondouglas <<a href="mailto:sextondouglas@comcast.net" class="">sextondouglas@comcast.net</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class=""><div dir="auto" class=""><div dir="auto" class="">Hey Katie</div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">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" class=""><br class=""></div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">Doug</div><div dir="auto" class=""><br class=""></div><div class=""><br class=""></div><div align="left" dir="auto" style="font-size: 100%;" class=""><div class="">-------- Original message --------</div><div class="">From: Katie Wilson <<a href="mailto:katie@transitriders.org" class="">katie@transitriders.org</a>> </div><div class="">Date: 1/7/21 1:52 PM (GMT-08:00) </div><div class="">To: <a href="mailto:research@transitriders.org" class="">research@transitriders.org</a> </div><div class="">Subject: [TRU Research] District mapping question </div><div class=""><br class=""></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); 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="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="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;" class=""><span class="" style="color: rgb(102, 102, 102); font-family: arial, sans-serif; font-size: 13px;">Katie Wilson</span></div><div style="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;" class=""><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></div></div></blockquote></div><br class=""></div></div></div></body></html>