Syracuse University
OP-16: Student Commute Modal Split

Greenhouse Gas Emission Calculations Calculating Student Travel Mileage 1) Housing data • Filter to relevant terms (Fall 2014/Spring 2015) • Remove duplicate entries by filtering to their maximum length of stay • If student is present in the data frame they’re deemed to be an “On Campus” student 2) Class data (use all classes) • Filter to relevant terms (Fall 2014/Spring 2015) • Filter to only classes taken on “Main Campus” or the various study abroad centers (China, England, France, Hong Kong, Italy, Chile, Spain, Turkey) • Filter to classes taken “in person” • Filter to status “enrolled” • Filter to grades that result in some type of grade (Pass/Fail, A-F, etc) • Count/total the number of classes each student is taking 3) Study Abroad data • Filter to relevant terms (Fall 2014/Spring 2015) • Geocode missing lat/lons • Calculate distance from home address to study abroad destination o Total Study Abroad Travel Miles – 6,520,148 4) Students who take Classes on Campus • Bring in Class data frame (with count of the number of classes a student is taking) • Join (left join) student data containing home address, home state, home country 5) Student Commuting Habits • Use data frame of student class counts and home address data • Join (left join) parking data provided by Parking Services • Join (left join) previously altered housing data (indicating if student lived on campus or not) • Assume that if student is in the data frame and IS NOT living on campus, they’re living off campus o Students taking on-line classes and classes not on campus were previously removed • Assume if a student is in the data frame and DOES NOT have a parking pass, they don’t have a parking pass • Establish a commuting distance for each student o If the student’s home to campus distance is less than 50 and they having a parking pass, they travel “x” distance o If the student’s home to campus distance is more than 50 and they have a parking pass, they live closer than indicated. Assign them a distance of 8 (mean distance from home) o If the student’s home to campus distance is less than 50 and they do not have a parking pass, assign them a distance of 0 (they commute some other way or are on campus) o If the student’s home to campus distance is more than 50 and they do not have a parking pass, assign them a distance of 8 (they commute some other way or drive but park elsewhere) 6) Separate students who we KNOW ARE driving • Filter to students with “Parking Pass” and live “Off Campus” • If the student doesn’t have a US address assign them a commute distance of 8 miles • Establish Commuting number - Divide the number of classes they take by 2 o Assuming they don’t make separate trips for each class • Establish One Way Weekly Miles - Multiply Commuting number (above) by (Commuting Distance) • Establish One Way Yearly Miles – Multiply Weekly Miles by 32 (number of weeks of classes) 7) Sort students who we don’t know their commuting method • Filter to students with NO “Parking Pass” and live “Off Campus” • Calculate a row number for each student in the data frame • Regardless of where or how far away they live, sort students into these buckets o 32% Walk to class o 8% Bike to Class o 28% take the bus to class o 34% Drive to class  We can make the above assumption based on all classes are “in person”, “on campus”, classes. They should be getting to campus on a semi-regular basis. • Based on the above, calculate a new Commuting Distance for them as follows o Walk – 1mile o Bike – 1mile o Bus – 3miles o Driving – 8 Miles • Establish Commuting number - Divide the number of classes they take by 2 o Assuming they don’t make separate trips for each class • Establish One Way Weekly Miles - Multiply Commuting number (above) by (Commuting Distance) • Establish One Way Yearly Miles – Multiply Weekly Miles by 32 (number of weeks of classes) 8) Calculate different student commuting numbers • Bind data from data frame 6 and data frame 7 to rejoin all students into one data frame • Total Yearly miles per method of Transportation o Driving – 3,206,272 o Bus – 740,640 o Walk – 252,544 o Bike – 54,944 9) Calculate all student Holiday/Vacation Travel • Note: This data frame should contain all students • Calculate miles students travel to school for the first day of class (DO not calculate this distance for students who are “off Campus” and live less than 50 miles from campus) • Calculate miles for students traveling to school and back for thanksgiving (DO not calculate this distance for students who are “off Campus” and live less than 50 miles from campus and for international students) • Calculate miles for students traveling to school and back for Christmas (DO not calculate this distance for students who are “off Campus” and live less than 50 miles) • Calculate miles for students traveling to school and back for Spring Break (DO not calculate this distance for students who are “off Campus” and live less than 50 miles from campus and for international students) • Calculate miles students travel home on the last day of class (DO not calculate this distance for students who are “off Campus” and live less than 50 miles from campus) 10) Bring Study Abroad Miles back into the data frame • Note: Use data frame from 9 • Join (left join) data from previously calculate study abroad data frame • If a student studied abroad in the Fall make their holiday travel numbers 0 for Thanksgiving and Christmas • If a student studied abroad in the Spring make their holiday travel number 0 for spring break o To School Miles – 29,122,207 o Thanksgiving – 13,133,076 o Christmas – 56,979,996 o Spring Break – 13,339,786 o Back Home – 29,122,207 11) Calculate Total Miles Per Student • Note: Use data frame from 10 • Sum all the holiday miles (To school, Thanksgiving, Christmas, Spring Break, Back home) for each student • Sum study abroad miles for each student • If a student has “Study Abroad Miles” that are > 0, cut their One Way Yearly Commute Miles in half (they weren’t commuting to campus for half the year) o Total miles attributed to students – 151,220,635

We lowered the campus shuttle 7 points due to the fact that some of the students we area assuming are riding the bus, could be walking or biking.