Skip to content

Instantly share code, notes, and snippets.

@scascketta
Created September 15, 2015 16:50
Show Gist options
  • Save scascketta/3c2ad9a3fd797d681a26 to your computer and use it in GitHub Desktop.
Save scascketta/3c2ad9a3fd797d681a26 to your computer and use it in GitHub Desktop.
Raw vehicle position data for CapMetro vehicle 2207 from 6:41pm to 9:07pm on 2015-09-14.
vehicle_id dist_traveled speed lon route_id trip_headsign timestamp lat trip_id
2207 0.00010795798364588702 0 -97.76786 1 1-Metric/South Congress-NB 2015-09-14T18:41:25-05:00 30.189432 1474790
2207 0.00010795798364588702 0 -97.76786 1 1-Metric/South Congress-NB 2015-09-14T18:43:25-05:00 30.189432 1474790
2207 0.00010795798364588702 0 -97.76786 1 1-Metric/South Congress-NB 2015-09-14T18:45:24-05:00 30.189432 1474790
2207 0.00010795798364588702 0 -97.76786 1 1-Metric/South Congress-NB 2015-09-14T18:47:24-05:00 30.189432 1474790
2207 0.00010795798364588702 0 -97.76786 1 1-Metric/South Congress-NB 2015-09-14T18:49:24-05:00 30.189432 1474790
2207 0.00010795798364588702 0 -97.76786 1 1-Metric/South Congress-NB 2015-09-14T18:51:24-05:00 30.189432 1474790
2207 0.00010795798364588702 0 -97.76786 1 1-Metric/South Congress-NB 2015-09-14T18:53:24-05:00 30.189432 1474790
2207 0.00012320448112642976 0 -97.76789 1 1-Metric/South Congress-NB 2015-09-14T18:55:24-05:00 30.189432 1474790
2207 0.0020776656795382918 0.6000000238418579 -97.76941 1 1-Metric/South Congress-NB 2015-09-14T18:57:24-05:00 30.189928 1474790
2207 0.01084992170383008 16.079999923706055 -97.77739 1 1-Metric/South Congress-NB 2015-09-14T18:59:24-05:00 30.193476 1474790
2207 0.022406663342438616 21.100000381469727 -97.77524 1 1-Metric/South Congress-NB 2015-09-14T19:01:24-05:00 30.203485 1474790
2207 0.023976839974186804 3.190000057220459 -97.774765 1 1-Metric/South Congress-NB 2015-09-14T19:03:24-05:00 30.20497 1474790
2207 0.038442469669410104 28.920000076293945 -97.76732 1 1-Metric/South Congress-NB 2015-09-14T19:05:24-05:00 30.217344 1474790
2207 0.04678953142477274 12.449999809265137 -97.766815 1 1-Metric/South Congress-NB 2015-09-14T19:07:23-05:00 30.223286 1474790
2207 0.04697477726259322 0.36000001430511475 -97.766685 1 1-Metric/South Congress-NB 2015-09-14T19:09:23-05:00 30.223423 1474790
2207 0.05144945290644382 10.8100004196167 -97.764786 1 1-Metric/South Congress-NB 2015-09-14T19:11:23-05:00 30.221443 1474790
2207 0.05504898950064469 7.199999809265137 -97.76292 1 1-Metric/South Congress-NB 2015-09-14T19:13:23-05:00 30.224522 1474790
2207 0.06116326964449093 12.279999732971191 -97.76 1 1-Metric/South Congress-NB 2015-09-14T19:15:23-05:00 30.229885 1474790
2207 0.07193109650151533 21.260000228881836 -97.7537 1 1-Metric/South Congress-NB 2015-09-14T19:17:23-05:00 30.238575 1474790
2207 0.07462230325901203 5.25 -97.75253 1 1-Metric/South Congress-NB 2015-09-14T19:19:26-05:00 30.240967 1474790
2207 0.08200064636411471 16.350000381469727 -97.75009 1 1-Metric/South Congress-NB 2015-09-14T19:21:23-05:00 30.248365 1474790
2207 0.08814574346914893 11.550000190734863 -97.74813 1 1-Metric/South Congress-NB 2015-09-14T19:23:23-05:00 30.253672 1474790
2207 0.0948990961490775 11.9399995803833 -97.749016 1 1-Metric/South Congress-NB 2015-09-14T19:25:22-05:00 30.259338 1474790
2207 0.10247092356632712 14.979999542236328 -97.74617 1 1-Metric/South Congress-NB 2015-09-14T19:27:22-05:00 30.26613 1474790
2207 0.10707085266155941 8.920000076293945 -97.744644 1 1-Metric/South Congress-NB 2015-09-14T19:29:22-05:00 30.270227 1474790
2207 0.11108972072577546 8.09000015258789 -97.743225 1 1-Metric/South Congress-NB 2015-09-14T19:31:23-05:00 30.273968 1474790
2207 0.11540073036324416 8.859999656677246 -97.74173 1 1-Metric/South Congress-NB 2015-09-14T19:33:22-05:00 30.27801 1474790
2207 0.11630650039768382 1.850000023841858 -97.74142 1 1-Metric/South Congress-NB 2015-09-14T19:35:22-05:00 30.278862 1474790
2207 0.11722056976582734 3.6500000953674316 -97.741165 1 1-Metric/South Congress-NB 2015-09-14T19:36:24-05:00 30.279743 1474790
2207 0.1204605554918563 9.15999984741211 -97.74192 1 1-Metric/South Congress-NB 2015-09-14T19:37:22-05:00 30.281778 1474790
2207 0.1260982418109816 11.59000015258789 -97.74155 1 1-Metric/South Congress-NB 2015-09-14T19:39:22-05:00 30.28736 1474790
2207 0.12929864524275703 6.619999885559082 -97.74129 1 1-Metric/South Congress-NB 2015-09-14T19:41:22-05:00 30.29055 1474790
2207 0.13579745484130876 12.229999542236328 -97.74211 1 1-Metric/South Congress-NB 2015-09-14T19:43:22-05:00 30.296408 1474790
2207 0.14057095817826923 9.579999923706055 -97.73955 1 1-Metric/South Congress-NB 2015-09-14T19:45:21-05:00 30.300423 1474790
2207 0.1517808353892199 22.350000381469727 -97.73357 1 1-Metric/South Congress-NB 2015-09-14T19:47:21-05:00 30.309883 1474790
2207 0.1569534805280307 24.149999618530273 -97.73233 1 1-Metric/South Congress-NB 2015-09-14T19:49:21-05:00 30.314777 1474790
2207 0.16290822783012465 11.770000457763672 -97.72989 1 1-Metric/South Congress-NB 2015-09-14T19:51:21-05:00 30.320057 1474790
2207 0.16948188767167782 13.140000343322754 -97.72647 1 1-Metric/South Congress-NB 2015-09-14T19:53:21-05:00 30.325668 1474790
2207 0.17095673015089402 6.190000057220459 -97.72562 1 1-Metric/South Congress-NB 2015-09-14T19:54:18-05:00 30.326878 1474790
2207 0.17485673868120916 14.84000015258789 -97.72359 1 1-Metric/South Congress-NB 2015-09-14T19:55:21-05:00 30.330206 1474790
2207 0.18235595825413153 14.979999542236328 -97.7196 1 1-Metric/South Congress-NB 2015-09-14T19:57:21-05:00 30.336557 1474790
2207 0.19119704839554874 17.420000076293945 -97.71491 1 1-Metric/South Congress-NB 2015-09-14T19:59:21-05:00 30.343927 1474790
2207 0.199423627034773 13.65999984741211 -97.71238 1 1-Metric/South Congress-NB 2015-09-14T20:01:21-05:00 30.350143 1474790
2207 0.19986694678562736 0.800000011920929 -97.71194 1 1-Metric/South Congress-NB 2015-09-14T20:03:20-05:00 30.350088 1474790
2207 0.20074470136415545 9.220000267028809 -97.711205 1 1-Metric/South Congress-NB 2015-09-14T20:03:40-05:00 30.349703 1474790
2207 0.20851503462555335 2.799999952316284 -97.70997 1 1-Metric/South Congress-NB 2015-09-14T20:05:20-05:00 30.35006 1474790
2207 0.21733076761568906 16.559999465942383 -97.70291 1 1-Metric/South Congress-NB 2015-09-14T20:07:20-05:00 30.35523 1474790
2207 0.22707687336924057 18.950000762939453 -97.69714 1 1-Metric/South Congress-NB 2015-09-14T20:09:20-05:00 30.362902 1474790
2207 0.22734450157718783 0.5600000023841858 -97.69702 1 1-Metric/South Congress-NB 2015-09-14T20:11:20-05:00 30.36315 1474790
2207 0.23060154999366841 5.78000020980835 -97.69987 1 1-Metric/South Congress-NB 2015-09-14T20:13:21-05:00 30.364525 1474790
2207 0.23918069400536857 15.609999656677246 -97.707504 1 1-Metric/South Congress-NB 2015-09-14T20:15:20-05:00 30.368046 1474790
2207 0.24829645518679572 16.43000030517578 -97.715485 1 1-Metric/South Congress-NB 2015-09-14T20:17:20-05:00 30.371977 1474790
2207 0.2602592558817934 15.430000305175781 -97.71646 1 1-Metric/South Congress-NB 2015-09-14T20:19:20-05:00 30.379375 1474790
2207 0.2713550507933707 21.690000534057617 -97.71057 1 1-Metric/South Congress-NB 2015-09-14T20:21:19-05:00 30.388422 1474790
2207 0.2753544129162358 7.860000133514404 -97.70858 1 1-Metric/South Congress-NB 2015-09-14T20:23:19-05:00 30.391806 1474790
2207 0.2781681778577159 14.649999618530273 -97.70696 1 1-Metric/South Congress-NB 2015-09-14T20:24:04-05:00 30.39406 1474790
2207 0.2843751932134529 18.940000534057617 -97.70383 1 1-Metric/South Congress-NB 2015-09-14T20:25:19-05:00 30.399092 1474790
2207 0.2861883753270037 3.5199999809265137 -97.70307 1 1-Metric/South Congress-NB 2015-09-14T20:27:19-05:00 30.40066 1474790
2207 0.2910846201158904 5.820000171661377 -97.70509 1 1-Metric/South Congress-NB 2015-09-14T20:29:19-05:00 30.40286 1474790
2207 0.3005389153745094 11.350000381469727 -97.69886 1 1-Metric/South Congress-NB 2015-09-14T20:31:19-05:00 30.403933 1474790
2207 0.3070097577979755 12.579999923706055 -97.69651 1 1-Metric/South Congress-NB 2015-09-14T20:33:19-05:00 30.409653 1474790
2207 0.309395922127134 4.269999980926514 -97.69465 1 1-Metric/South Congress-NB 2015-09-14T20:35:19-05:00 30.410946 1474790
2207 0.3111188237985191 3.0299999713897705 -97.69297 1 1-Metric/South Congress-NB 2015-09-14T20:37:19-05:00 30.411165 1474790
2207 0.3117725952370757 1.159999966621399 -97.69234 1 1-Metric/South Congress-NB 2015-09-14T20:39:19-05:00 30.411303 1474790
2207 0.312930666763033 2.059999942779541 -97.691444 1 1-Metric/South Congress-NB 2015-09-14T20:41:19-05:00 30.411936 1474790
2207 0.31393917214733685 1.9900000095367432 -97.69088 1 1-Metric/South Congress-NB 2015-09-14T20:43:18-05:00 30.41276 1474790
2207 0.3165974996820134 13.800000190734863 -97.68929 1 1-Metric/South Congress-NB 2015-09-14T20:44:01-05:00 30.414713 1474790
2207 0.32807715556085315 31.809999465942383 -97.6823 1 1-Metric/South Congress-NB 2015-09-14T20:45:18-05:00 30.422495 1474790
2207 0.3358884494694878 17.1200008392334 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:47:00-05:00 30.42651 1474790
2207 0.3358884494694878 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:48:00-05:00 30.42651 1474790
2207 0.33590005981203286 0.07999999821186066 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:49:18-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:51:18-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:53:11-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:55:18-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:57:18-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T20:59:18-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T21:01:17-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T21:03:17-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T21:05:17-05:00 30.426483 1474790
2207 0.33590005981203286 0 -97.67631 1 1-Metric/South Congress-NB 2015-09-14T21:07:17-05:00 30.426483 1474790
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment