[TRU Research] Research / data analysis group

Thu Jun 6 17:24:22 PDT 2019

My status: I have been in Montana this week, but should be available to
pick up tasks again next week.
Best regards, Jim

On Thu, Jun 6, 2019 at 4:48 PM Stephen DeSanto <rachidian at gmail.com> wrote:

> 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/835cc426/attachment.html>