-
Notifications
You must be signed in to change notification settings - Fork 0
Trip Linking
Joanne edited this page Jul 21, 2025
·
2 revisions
This content is copied from Rulesy overview.docx [Needs update!!]
-
Concatenate 4 modes into a single text field (also concatenate transit_systems together, and transit_lines together); used in STEP 5.
-
Remove trip components into another table:
- prior record does not end at home or work
- trip purpose is either the same, or 'change modes'
- duration between legs is either less than 15 minutes, or if purpose 'change modes', less than 30 minutes.
- either there is a mode change, or both modes are transit
-
denote trip component which have aggregate properties that disqualify them as a single trip:
- two instances of pool start, parking, park & ride, change vehicles
- over 5 components
- non-adjacent repeating transit lines (i.e. loop)
-
for legitimate linked trips, replace the initial component with the aggregate linked trip data
-
Recharacterize mode (including access/egress modes)
- Eliminate adjacent repeated values
- Characterize access and egress trips, separately for 1) transit trips and 2) auto trips. (Bike/Ped trips have no access/egress)
- Remove access/egress modes from 1) transit and 2) auto trip strings--not only at the ends, but also the middle.
- Split the concatenated field into separate mode fields
-
Split transit_lines and transit_systems into separate fields
The wiki describes the data cleaning process for the PSRC Household Travel Survey Program.