[TRU Research] Fwd: CTR data request

Tue Jun 18 22:08:13 PDT 2019

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 <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 <mailto:GotlaR at wsdot.wa.gov>> 
> Sent: Tuesday, June 18, 2019 2:25 PM
> To: Wandler, Michael <WandleM at wsdot.wa.gov <mailto:WandleM at wsdot.wa.gov>>; Nguyen, Amber <NguyenAm at wsdot.wa.gov <mailto: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 <mailto:katie at transitriders.org>> 
> Sent: Tuesday, June 18, 2019 2:07 PM
> To: Gotla, Ricardo <GotlaR at wsdot.wa.gov <mailto: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 <mailto:katie at transitriders.org>>
> Subject: CTR data request
> Date: June 12, 2019 at 8:14:20 AM PDT
> To: ctrsurvey at wsdot.wa.gov <mailto: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 <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/20190618/01e2747c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2019-04-17_2017-2018_FINAL_Statewide_CTR_Aggregate_Report_from_WSDOT_Microsoft_Update.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 5163227 bytes
Desc: not available
URL: <http://lists.transitriders.org/pipermail/research/attachments/20190618/01e2747c/attachment.xlsx>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.transitriders.org/pipermail/research/attachments/20190618/01e2747c/attachment-0001.html>