[TRU Research] Fwd: CTR data request

Thu Jun 27 17:10:50 PDT 2019

Okay, I have a list of companies which:

   - Are on our CTR Targets list
   - Were not listed as Seattle CTR Champions

and adds this 2017/2018 WSDOT survey data for each:

   - drive-alone rate (as dat_rate)
   - total weekly trips reported
   - weekly drive alone trips

This list is here:
https://seattletransitpasses-research.pbworks.com/w/file/134329350/ctr_champions_2018_unranked_vs_wsdot_drive_alone.csv

Keep in mind some companies might not be Seattle CTR Champions because
they're elsewhere in King County. If someone has an idea to connect these
places with network/location, I can add that in.

My employer (ExtraHop Networks) reported a drive-alone rate of 10%, is
located in the Downtown network (target 20%) but we're not CTR Champions?
Feels bad, man.

If anyone wants to check my work, or build on these results, I can share my
Jupyter Notebook (python).

On Tue, Jun 18, 2019 at 10:11 PM Katie Wilson <katie at transitriders.org>
wrote:

> Hi All,
>
> Turns out WSDOT is much more forthcoming with employers’ CTR report data
> than SDOT is— see below and attached. One useful project would be to make a
> table or spreadsheet listing the “unranked” employers in this list
> Stephen made
> <https://seattletransitpasses-research.pbworks.com/w/page/133894899/CTR%20Champions%202018>,
> with a column for the drive-alone rate reported in their 2017/2018 survey
> (gleaned from the attached data) and another column with the target
> drive-alone rate for their “network”
> <http://www.seattle.gov/transportation/projects-and-programs/programs/transportation-options-program/commute-trip-reduction-program/2013-2018-networks-and-targets>.
> This will allow us to see which companies actually fell short of meeting
> their target, and by how much.
>
> Unfortunately I don’t know of an efficient way to identify each employer’s
> network. I just emailed my SDOT contact, who gave me the list of Seattle
> CTR companies, to ask whether he can share a version that lists their
> networks. So maybe let’s give him a day or two to respond before we do it
> the slow way and look each one up.
>
> Mike and I are going to chat Thursday morning about our survey data, so we
> should be able to get some analysis going soon after that. Stay tuned.
> Maybe we could try to meet up sometime in the next few weeks to assess our
> progress etc.
>
> - Katie
>
> Begin forwarded message:
>
> *From: *"Wandler, Michael" <WandleM at wsdot.wa.gov>
> *Subject: **RE: CTR data request*
> *Date: *June 18, 2019 at 8:49:57 PM PDT
> *To: *"katie at transitriders.org" <katie at transitriders.org>
> *Cc: *"Gotla, Ricardo" <GotlaR at wsdot.wa.gov>, "Nguyen, Amber" <
> NguyenAm at wsdot.wa.gov>
>
> Hi, Katie,
>
> I am attaching our CTR aggregate report.  I believe it has the information
> you need.  If you look on the Worksites_CountTowardsGoal sheet, each row
> represents one survey’s results for the listed worksite.  Each employer
> surveys once every two-year cycle, so some worksites have up to six survey
> results since 2007-08.
>
> For each survey, we have information on vehicle miles traveled, non-drive
> alone rate, greenhouse gas emissions, total trips by mode type, and
> percentage of total trips by mode type.
>
> If you would like to know more about how we do some of the calculations,
> please check out this website:
> https://www.wsdot.wa.gov/transit/ctr/surveying-employees.  It has many
> things you will potentially find helpful, like a blank copy of the survey,
> how VMT and GHG are calculated, FAQs, our policy for response rate, et
> cetera.
>
> I hope this helps!
>
> Michael S. Wandler* |* 206.464.*1215*
>
> *From:* Gotla, Ricardo <GotlaR at wsdot.wa.gov>
> *Sent:* Tuesday, June 18, 2019 2:25 PM
> *To:* Wandler, Michael <WandleM at wsdot.wa.gov>; Nguyen, Amber <
> NguyenAm at wsdot.wa.gov>
> *Subject:* FW: CTR data request
>
> See CTR data inquiry below. Happy to hand this off to either one of you or
> follow up myself. You’re call. If either of you do respond, please Cc me.
> --
> Ricardo Gotla (*he/him pronouns*)
> O: 206.716.1114
> C: 360.867-8308
>
> *From:* Katie Wilson <katie at transitriders.org>
> *Sent:* Tuesday, June 18, 2019 2:07 PM
> *To:* Gotla, Ricardo <GotlaR at wsdot.wa.gov>
> *Subject:* CTR data request
>
> Hi Ricardo,
>
> Thanks for the call just now— the request is below. We’re particularly
> interested in reported drive-alone rates, but if there is other shareable
> info that would be great too.
>
> Thanks!
> Katie
> 206-781-7204
>
>
> Begin forwarded message:
>
> *From: *Katie Wilson <katie at transitriders.org>
> *Subject: CTR data request*
> *Date: *June 12, 2019 at 8:14:20 AM PDT
> *To: *ctrsurvey at wsdot.wa.gov
>
> Hello,
>
> I’m doing some research on CTR efforts in Seattle and King County. I’m
> wondering whether I can obtain drive-alone rates reported by CTR-affected
> employers, and any other easily-shareable information that WSDOT collects
> about their CTR programs.
>
> Happy to chat by phone if that’s helpful— 206-781-7204.
>
> Thanks!
> 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/20190627/af301927/attachment.html>