Step 1 - Read in Travel Survey Trip Data
| HHPERSONID | HHID | ID | TRIPNO | TRIPID | HHSIZE | PROXY | ORIGIN | OTYPE | OCITY | OSTATE | OZIP | OACT | DESTINATION | DTYPE | DCITY | DSTATE | DZIP | DACT | TRPMODE | TRPMODEOTH | TRPROST | DRVRPASS | TOLL | TRIPDUR | ODATE | OTIME | DDATE | DTIME | STUDYDAY | STTRAVEL | DISTANCE | OTAZ | DTAZ | OLON_RANDOM | OLAT_RANDOM | DLON_RANDOM | DLAT_RANDOM | TRPMODE_DESC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20025201 | 200252 | 6653 | 1 | 20025201101 | 1 | 0 | 1 | 1 | Fort Lauderdale | FL | 33312 | 2 | 2 | 2 | Fort Lauderdale | FL | 33309 | 1 | 8 | NA | 996 | 997 | 997 | 1800 | 2017-04-03 | 1899-12-31 07:30:00 | 2017-04-03 | 1899-12-31 08:00:00 | 1 | 3 | 6.37 | 2251 | 2283 | -80.19930 | 26.11748 | -80.15065 | 26.19868 | Tri-Rail |
| 20025201 | 200252 | 6654 | 2 | 20025201102 | 1 | 0 | 2 | 2 | Fort Lauderdale | FL | 33309 | 1 | 99 | 99 | Fort Lauderdale | FL | 33309 | 5 | 11 | NA | 996 | 997 | 997 | 1800 | 2017-04-03 | 1899-12-31 17:30:00 | 2017-04-03 | 1899-12-31 18:00:00 | 1 | 0 | 1.75 | 2283 | 2332 | -80.14900 | 26.20342 | -80.15237 | 26.17857 | Bicycle |
| 20025201 | 200252 | 6652 | 3 | 20025201103 | 1 | 0 | 99 | 99 | Fort Lauderdale | FL | 33309 | 5 | 1 | 1 | Fort Lauderdale | FL | 33312 | 2 | 11 | NA | 996 | 997 | 997 | 2700 | 2017-04-03 | 1899-12-31 19:00:00 | 2017-04-03 | 1899-12-31 19:45:00 | 1 | 0 | 4.94 | 2332 | 2251 | -80.15354 | 26.17924 | -80.18852 | 26.11723 | Bicycle |
| 20025201 | 200252 | 19612 | 1 | 20025201201 | 1 | 0 | 1 | 1 | Fort Lauderdale | FL | 33312 | 2 | 2 | 2 | Fort Lauderdale | FL | 33309 | 1 | 1 | NA | 2 | 1 | 997 | 1500 | 2017-04-04 | 1899-12-31 07:45:00 | 2017-04-04 | 1899-12-31 08:10:00 | 2 | 3 | 6.37 | 2251 | 2283 | -80.19903 | 26.11514 | -80.15080 | 26.19787 | Car, truck, or van |
| 20025201 | 200252 | 19613 | 2 | 20025201202 | 1 | 0 | 2 | 2 | Fort Lauderdale | FL | 33309 | 1 | 99 | 99 | Margate | FL | 33063 | 15 | 1 | NA | 1 | 1 | 997 | 1800 | 2017-04-04 | 1899-12-31 17:30:00 | 2017-04-04 | 1899-12-31 18:00:00 | 2 | 0 | 4.53 | 2283 | 1991 | -80.15082 | 26.19812 | -80.20918 | 26.23884 | Car, truck, or van |
Step 2 - Generate Lines Between Trip Origins and Destinations & Calculate Distance in Miles
| HHID | ID | TRIPNO | TRIPID | OCITY | OTAZ | DTAZ | DISTANCE | length_miles |
|---|---|---|---|---|---|---|---|---|
| 200252 | 6653 | 1 | 20025201101 | Fort Lauderdale | 2251 | 2283 | 6.37 | 6.354913 |
| 200252 | 6654 | 2 | 20025201102 | Fort Lauderdale | 2283 | 2332 | 1.75 | 1.723536 |
| 200252 | 6652 | 3 | 20025201103 | Fort Lauderdale | 2332 | 2251 | 4.94 | 4.790412 |
| 200252 | 19612 | 1 | 20025201201 | Fort Lauderdale | 2251 | 2283 | 6.37 | 6.435589 |
| 200252 | 19613 | 2 | 20025201202 | Fort Lauderdale | 2283 | 1991 | 4.53 | 4.581651 |
Step 3 - Scatter plot of distance column versus calcuated distance (miles)
Step 4 - Explore differences between provided distance column and calcuated distance (miles)
Step 5 - Map All Trips - Symbolized by Mode
Renaissance Planning, jlehman@citiesthatwork.com↩︎