Johnstone Castle circular - Johnstone
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:00:00 | 14:00:00 | ... | 1 |
|
| ... | 14:01:27 | 14:01:27 | ... | 2 |
|
| ... | 14:02:17 | 14:02:17 | ... | 3 |
|
| ... | 14:03:14 | 14:03:14 | ... | 4 |
|
| ... | 14:04:24 | 14:04:24 | ... | 5 |
|
| ... | 14:04:58 | 14:04:58 | ... | 6 |
|
| ... | 14:06:21 | 14:06:21 | ... | 7 |
|
| ... | 14:07:04 | 14:07:04 | ... | 8 |
|
| ... | 14:08:19 | 14:08:19 | ... | 9 |
|
| ... | 14:09:14 | 14:09:14 | ... | 10 |
|
| ... | 14:10:00 | 14:10:00 | ... | 11 |
|
| ... | 14:10:26 | 14:10:26 | ... | 12 |
|
| ... | 14:10:50 | 14:10:50 | ... | 13 |
|
| ... | 14:11:19 | 14:11:19 | ... | 14 |
|
| ... | 14:11:40 | 14:11:40 | ... | 15 |
|
| ... | 14:12:35 | 14:12:35 | ... | 16 |
|
| ... | 14:13:04 | 14:13:04 | ... | 17 |
|
| ... | 14:13:21 | 14:13:21 | ... | 18 |
|
| ... | 14:14:26 | 14:14:26 | ... | 19 |
|
| ... | 14:14:47 | 14:14:47 | ... | 20 |
|
| ... | 14:15:30 | 14:15:30 | ... | 21 |
|
| ... | 14:15:43 | 14:15:43 | ... | 22 |
|
| ... | 14:16:56 | 14:16:56 | ... | 23 |
|
| ... | 14:17:16 | 14:17:16 | ... | 24 |
|
| ... | 14:17:48 | 14:17:48 | ... | 25 |
|
| ... | 14:18:34 | 14:18:34 | ... | 26 |
|
| ... | 14:19:00 | 14:19:00 | ... | 27 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 30/01/2009 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 73926369 | Collier Street | 55.8380636083 | -4.5123343147 | |
| 73925838 | Farrier Court | 55.8368942547 | -4.5088568471 | |
| 73925269 | Thorn Court | 55.8341522725 | -4.4991775868 | |
| 73923284 | Overton Crescent | 55.8343573296 | -4.4997018132 | |
| 73925365 | Johnstone Station | 55.8350371451 | -4.5029556459 | |
| 73925479 | John Lang Street | 55.8354122544 | -4.5052796211 | |
| 73924929 | John Lang Street | 55.8355849554 | -4.5056261307 | |
| 73924673 | Canal St | 55.8357198682 | -4.5069444679 | |
| 73924784 | Laighcartside Street | 55.8360391736 | -4.5080351191 | |
| 73923949 | Houston Square | 55.8367720028 | -4.5122030623 | |
| 73923748 | Williamson Place | 55.8335499838 | -4.4987396723 | |
| 73925292 | Williamson Place | 55.8335152747 | -4.4991207367 | |
| 73923846 | Auchenlodment Road | 55.8320133165 | -4.5018190821 | |
| 73924783 | Auchenlodment Road | 55.8318127017 | -4.5015187385 | |
| 73923875 | Willow Drive | 55.8309472914 | -4.5020859617 | |
| 73924834 | Fir Place | 55.8306661033 | -4.5022116212 | |
| 73924689 | Hazel Avenue | 55.8283867927 | -4.5055622734 | |
| 73923764 | Willow Drive | 55.8261388094 | -4.5056092877 | |
| 73923952 | Maple Drive | 55.8250367924 | -4.5049955265 | |
| 73923674 | Larch place | 55.8243278136 | -4.5067062787 | |
| 73924897 | Larch Place | 55.8243652019 | -4.5092793338 | |
| 73924657 | Aspen Place | 55.8285756971 | -4.5015823068 | |
| 73923769 | Alder Place | 55.827055337 | -4.5020914443 | |
| 73924652 | Cherry Place | 55.8261681696 | -4.5037270123 | |
| 73924398 | Maple Drive | 55.8252542299 | -4.5101988256 | |
| 73923593 | Hazel Avenue | 55.8275765229 | -4.5060690351 |