[TRU Research] PSRC data project

[Stephen DeSanto]

Computers are really good at doing tedious work. I've uploaded the chamber
of commerce board of directors and WA Roundtable members. I've also made a
new page showing the intersection of these lists:

   1. Companies in the Potential CTR Targets list
   2. Companies in the "City of Seattle CTR Companies April 2019" list that
   were not in the "CTR Champions" list
   3. Companies with members on the Washington Roundtable
   4. Companies with members in the Seattle Chamber.

If a company is in list #1 or #2 (our targets), AND also in one of list #3
and 4 (board members), THEN they're in this list:

https://seattletransitpasses-research.pbworks.com/w/file/134085168/CTR%20intersect%20Business%20Groups.csv

N.B.: I'm lazy and made a computer do the work for me, so I might've missed
one or two if the company name was very different between lists, if they're
actually located outside Seattle (e.g. Microsoft, Nintendo), etc.




On Thu, Jun 13, 2019 at 10:33 AM Katie Wilson <katie at transitriders.org>
wrote:

> And another: Cross-reference our “Potential CTR targets”
> <https://seattletransitpasses-research.pbworks.com/w/page/133437828/Potential%20CTR%20Targets> list
> with the “Unranked” employers in these lists Stephen compiled
> <https://seattletransitpasses-research.pbworks.com/w/page/133894899/CTR%20Champions%202018> to
> identify employers that are on both lists. This will give us a short-list
> of employers that may not be providing transit benefits AND may not be
> meeting drive-alone rate goals.
>
> I can provide a csv of the potential CTR targets if you’re working on this
> & have any trouble pulling that from the table in the wiki.
>
> On Jun 13, 2019, at 10:20 AM, Katie Wilson <katie at transitriders.org>
> wrote:
>
> Two more somewhat-tedious mini-projects:
>
>
>    1. Make a list of the employers that are represented on the board of
>    the Seattle Metropolitan Chamber of Commerce:
>    https://www.seattlechamber.com/home/about/people
>    2. Do the same for the Washington Roundtable:
>    https://www.waroundtable.com/about/
>
>
> This will help us in our strategic thinking about targets.
>
> Katie
>
> On Jun 12, 2019, at 8:08 AM, Katie Wilson <katie at transitriders.org> wrote:
>
> Hi folks,
>
> On Monday I met with the Port of Seattle's Environmental Program manager
> working on ground transportation policy for SeaTac airport— which
> apparently has a horrendous drive-alone rate, by the way. He mentioned that
> the Puget Sound Regional Council’s survey data shows that lower-wage
> workers are less likely to get transit benefits through work. It would be a
> good mini-project someone could take on to look at PSRC’s 2017 Travel
> Survey data <https://www.psrc.org/household-travel-survey-program> to try
> to find that, plus any other info we think is relevant to our project.
>
> It’s probably useful for more than one person to look at the data, but if
> you’re going to pursue the transit benefits piece in particular, say
> something so we don’t duplicate efforts.
>
> Cheers,
> Katie
>
> Katie Wilson
> General Secretary
> Transit Riders Union
> https://transitriders.org
> 206-781-7204
>
> *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.*
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.transitriders.org/pipermail/research/attachments/20190613/cf2deae6/attachment.html>