[TRU Research] Research / data analysis group

Thu Jun 6 16:48:14 PDT 2019

I can't make the meeting tonight, but look forward to hearing more about
the campaign.

On Tue, Jun 4, 2019 at 8:40 AM Katie Wilson <katie at transitriders.org> wrote:

> Nice, thanks Stephen!!
>
> This *Thursday, 5:30pm at the Owl ’N Thistle* I’m going to meet with
> another person who wants to help out with research/data analysis, Julian.
> We could totally make this into a larger meeting if any of you are able to
> join. I have a somewhat more developed campaign timeline to share and also
> some thoughts about how we might want to display some of the info we’re
> gathering on a campaign website.
>
> Katie
>
> On Jun 1, 2019, at 2:20 PM, Stephen DeSanto <rachidian at gmail.com> wrote:
>
> 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/20190606/d1b78bee/attachment.html>