Syracuse University
OP-17: Employee Commute Modal Split

Calculating Faculty Travel Mileage 1) Base Faculty/Staff data • Filter Faculty/Staff that have the same EMPLID and Same City (removing duplicates) • Calculate distance from “home” to campus • Join (left join) Parking Pass data provided by Parking Services 2) Separate Faculty/Staff we KNOW ARE driving • Filter to Faculty/Staff that have “Parking Pass” • If a Faculty/Staff member doesn’t have a distance from home to campus, or if that distance is greater than 100 miles, assign them a Commuting Distance of 7 o We’re assuming Faculty/Staff are not commuting >100 miles multiple times a week • Establish a Commuting number for each Faculty/Staff member o Faculty and Full Time – 4 o Faculty and Part Time – 2 o Staff and Full Time – 5 o Staff and Part Time – 3 • Calculate One Way Miles Per Week by multiplying Commuting Distance by Commuting Number 3) Sort Faculty/Staff whose commuting method we’re unsure of • Filter to Faculty/Staff that have “Parking Pass” • Regardless of Distance from campus, sort Faculty/Staff into these buckets o 36% Walk to work o 32% take the bus to work o 34% Drive to work • Based on the above, calculate a new Commuting Distance for them as follows o Walk – 1mile o Bus – 3miles o Driving – 8 Miles • Establish a Commuting number for each Faculty/Staff member o Faculty and Full Time – 4 o Faculty and Part Time – 2 o Staff and Full Time – 5 o Staff and Part Time – 3 • Calculate One Way Miles Per Week by multiplying Commuting Distance by Commuting Number 4) Combine the “Driving” and “Non Driving” Faculty/Staff data frames • If the employee is faculty assume they commute for 32 weeks a year o If the employee is staff, they commute for 52 weeks a year • Calculate “One Way Yearly Commute” by multiplying one way weekly miles by Fac/Staff Weeks o Driving – 8,120,796 o Bus – 232,740 o Walking – 89,032 5) Calculate Holiday commuting for Faculty/Staff • Use original unduplicated Faculty/Staff data frame • Filter to all faculty/staff who commute more than 100 miles (this number can be changed) • Calculate “To School” miles as miles (distance from home) • Calculate Thanksgiving miles as 2 x miles (distance from home) • Calculate Christmas miles as 2 x miles (distance from home) • Calculate Spring break miles as 2 x miles (distance from home) • Calculate “From School” miles as miles (distance from home) o 3,146,824 miles traveled for Holidays and Breaks 6) Calculate all staff miles • Join (left join) Commuting and Holiday Travel data frames • Calculate total miles per year per faculty/staff member o Total Miles Traveled – 11,390,944