[TRU Research] Research / data analysis group

[Stephen DeSanto]

rough draft here:
https://seattletransitpasses-research.pbworks.com/w/page/133894899/CTR%20Champions%202018

On Fri, May 31, 2019 at 3:38 PM Katie Wilson <katie at transitriders.org>
wrote:

> Hey all!
>
> Here’s a well-defined task that could be done. I just found this CTR
> Champions page
> <https://www.seattle.gov/transportation/projects-and-programs/programs/transportation-options-program/commute-trip-reduction-program/ctr-awards/ctr-champions-winners#2018ctrchampions>.
> If we can put these in a spreadsheet and then check them against the overall
> list of CTR companies
> <https://seattletransitpasses-research.pbworks.com/w/file/133438056/City%20of%20Seattle%20CTR%20Companies%20as%20of%20April%202019%202.xlsx>,
> we can generate a list of CTR companies that aren’t “champions” i.e. may
> not be meeting the drive-alone targets for their zone. There are some other
> reasons why an employer might not make the champion list— some don’t
> report, or they report on a different schedule, so we can’t take this as
> conclusive, but it will be some good info to work with as we’re choosing
> targets.
>
> Do you all want to try to meet up again sometime in the next week or two?
> Mike is out of town this week but when he gets back I want to try to
> jumpstart our survey data analysis.
>
> - Katie
>
> On May 23, 2019, at 2:02 PM, Stephen DeSanto <rachidian at gmail.com> wrote:
>
> 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/20190601/98d06fe3/attachment.html>