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