[TRU Research] Research / data analysis group

[Stephen DeSanto]

That is pretty funny. I had been looking at GlassDoor for transit benefit
data and hadn't found much, especially for large corporate entities with
multiple locations. Good catch. :)

On Thu, May 23, 2019 at 1:38 PM Katie Wilson <katie at transitriders.org>
wrote:

> This is pretty funny. Stephen added locations and industries for all our
> potential CTR targets and I noticed one is a PR firm located downtown. I
> thought it would be fun to go after a PR firm so I looked them up— Edelman—
> and found two reviews on Glassdoor complaining about no bus passes, e.g.:
>
> It is disappointing how many hours people would work for little
> compensation. At the very least offer a bus pass discount, as a majority of
> Seattle employees commute to work by bus. The work culture is uptight and
> stuffy to the point where I consistently felt like I was walking on
> eggshells.
>
> Anyway, to top that off, it looks like Edelman does PR for Starbucks
> <https://www.edelman.com/offices/seattle>!
>
> On May 23, 2019, at 8:32 AM, Katie Wilson <katie at transitriders.org> wrote:
>
> Hi All,
>
> Mike merged the google forms responses with the larger data set and
> removed PII— I’ve uploaded the file to the wiki here
> <https://seattletransitpasses-research.pbworks.com/w/file/133754394/Merged%20TRU%20survey%20no%20PII.xlsx>
> .
>
> I think the main cleaning that needs to be done before we can answer most
> of the questions we’ve discussed so far is to remove responses from people
> who don’t commute to a job. I’ve described that task above the data
> analysis tables here
> <https://seattletransitpasses-research.pbworks.com/w/page/133613826/Commute%20Survey%201>
> .
>
> I listed a couple more things people could do with the data now on the
> Research Tasks page here
> <https://seattletransitpasses-research.pbworks.com/w/page/133438026/Research%20Questions>.
> If you’re going to work on something please put your name in the table so
> we don’t duplicate efforts.
>
> I’m going to be out of town tonight through Monday night but then will be
> back in action.
>
> - Katie
>
> p.s. In case it’s not clear, this is a listserv so if you reply to
> research at transitriders.org it goes to everyone in the group.
>
> On May 16, 2019, at 10:41 AM, Katie Wilson <katie at transitriders.org>
> wrote:
>
> Hi All,
>
> Thanks for meeting at Optimism on Tuesday! On this email group are Mike,
> Harry, Stephen, Jim, and Tom. You should all have access to our wiki tool,
> PBworks. If you didn’t get an invitation or weren’t able to access the
> site, let me know.
>
> I started making some tables that I thought might be a good way to
> display our survey data analysis
> <https://seattletransitpasses-research.pbworks.com/w/page/133613826/Commute%20Survey%201>.
> But, I’m not an expert on this stuff, so please take a look and let me know
> what you think. Mike is going to work on merging the data, removing PII,
> and either cleaning or identifying the cleaning tasks that need to be done.
>
> Harry was able to scrape all the info we need and more
> <https://seattletransitpasses-research.pbworks.com/w/file/133642833/scraped_sbux_loc.xlsx> about
> Starbucks locations, so we’re good on that front!
>
> Here’s the table for collecting info about CTR-affected employers
> <https://seattletransitpasses-research.pbworks.com/w/page/133437828/Potential%20CTR%20Targets> that
> don’t contract directly with Metro for ORCA programs. Feel free to fill
> stuff in. I just added a few columns that weren’t there before. Basically,
> we’re trying to decide whether these could be good targets. (And by the
> way, if you’re interested in reading about the Commute Trip Reduction law, you
> can do that here
> <https://www.seattle.gov/transportation/projects-and-programs/programs/transportation-options-program/commute-trip-reduction-program/ctr-requirements>
> .)
>
> Finally, here’s where we can list tasks that need to be done
> <https://seattletransitpasses-research.pbworks.com/w/page/133438026/Research%20Questions:>.
> I’m hoping all these pages are pretty easy to navigate to and between, just
> wanted to send some links to start things off.
>
> If you have some time & aren’t sure what to work on, email me and we’ll
> figure something out!
>
> - 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/20190523/52381565/attachment.html>