Johnstone Castle circular - Johnstone
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 11:00:00 | 11:00:00 | ... | 1 |
|
| ... | 11:01:18 | 11:01:18 | ... | 2 |
|
| ... | 11:02:04 | 11:02:04 | ... | 3 |
|
| ... | 11:02:55 | 11:02:55 | ... | 4 |
|
| ... | 11:03:57 | 11:03:57 | ... | 5 |
|
| ... | 11:04:28 | 11:04:28 | ... | 6 |
|
| ... | 11:05:43 | 11:05:43 | ... | 7 |
|
| ... | 11:06:22 | 11:06:22 | ... | 8 |
|
| ... | 11:07:29 | 11:07:29 | ... | 9 |
|
| ... | 11:08:19 | 11:08:19 | ... | 10 |
|
| ... | 11:09:00 | 11:09:00 | ... | 11 |
|
| ... | 11:09:26 | 11:09:26 | ... | 12 |
|
| ... | 11:09:50 | 11:09:50 | ... | 13 |
|
| ... | 11:10:19 | 11:10:19 | ... | 14 |
|
| ... | 11:10:40 | 11:10:40 | ... | 15 |
|
| ... | 11:11:35 | 11:11:35 | ... | 16 |
|
| ... | 11:12:04 | 11:12:04 | ... | 17 |
|
| ... | 11:12:21 | 11:12:21 | ... | 18 |
|
| ... | 11:13:26 | 11:13:26 | ... | 19 |
|
| ... | 11:13:47 | 11:13:47 | ... | 20 |
|
| ... | 11:14:30 | 11:14:30 | ... | 21 |
|
| ... | 11:14:43 | 11:14:43 | ... | 22 |
|
| ... | 11:15:56 | 11:15:56 | ... | 23 |
|
| ... | 11:16:16 | 11:16:16 | ... | 24 |
|
| ... | 11:16:48 | 11:16:48 | ... | 25 |
|
| ... | 11:17:34 | 11:17:34 | ... | 26 |
|
| ... | 11:18:00 | 11:18: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 |