Pt Glasgow or Greenock - IRH or McInroys Pt
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 18:20:00 | 18:20:00 | ... | 1 |
|
| ... | 18:20:25 | 18:20:25 | ... | 2 |
|
| ... | 18:20:47 | 18:20:47 | ... | 3 |
|
| ... | 18:21:39 | 18:21:39 | ... | 4 |
|
| ... | 18:22:52 | 18:22:52 | ... | 5 |
|
| ... | 18:23:10 | 18:23:10 | ... | 6 |
|
| ... | 18:23:45 | 18:23:45 | ... | 7 |
|
| ... | 18:24:15 | 18:24:15 | ... | 8 |
|
| ... | 18:25:00 | 18:25:00 | ... | 9 |
|
| ... | 18:25:35 | 18:25:35 | ... | 10 |
|
| ... | 18:26:04 | 18:26:04 | ... | 11 |
|
| ... | 18:26:40 | 18:26:40 | ... | 12 |
|
| ... | 18:27:02 | 18:27:02 | ... | 13 |
|
| ... | 18:27:11 | 18:27:11 | ... | 14 |
|
| ... | 18:27:48 | 18:27:48 | ... | 15 |
|
| ... | 18:28:11 | 18:28:11 | ... | 16 |
|
| ... | 18:28:34 | 18:28:34 | ... | 17 |
|
| ... | 18:29:00 | 18:29:00 | ... | 18 |
|
| ... | 18:29:41 | 18:29:41 | ... | 19 |
|
| ... | 18:30:28 | 18:30:28 | ... | 20 |
|
| ... | 18:31:41 | 18:31:41 | ... | 21 |
|
| ... | 18:32:52 | 18:32:52 | ... | 22 |
|
| ... | 18:34:54 | 18:34:54 | ... | 23 |
|
| ... | 18:36:10 | 18:36:10 | ... | 24 |
|
| ... | 18:37:08 | 18:37:08 | ... | 25 |
|
| ... | 18:38:09 | 18:38:09 | ... | 26 |
|
| ... | 18:40:00 | 18:40:00 | ... | 27 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 18/05/2009 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 46823246 | Cartsburn Street | 55.9410924508 | -4.748424587 | |
| 46823782 | Hawick Court | 55.9401256171 | -4.745024834 | |
| 46823469 | Belville Avenue | 55.9409614154 | -4.7414003418 | |
| 46823296 | East William Street | 55.9416315482 | -4.7391574059 | |
| 46824365 | St Lawrence Street | 55.942117885 | -4.7370936185 | |
| 46823758 | Bawhirley Road | 55.9418429383 | -4.7340951985 | |
| 46823786 | Grosvenor Road | 55.9389728159 | -4.732195274 | |
| 46823695 | Border Street | 55.9403472892 | -4.7334452261 | |
| 46823843 | Lansbury Street | 55.9361522694 | -4.718304794 | |
| 46824353 | Roxburgh Street | 55.9458864106 | -4.7619471852 | |
| 46824326 | Shaw Place | 55.9458159591 | -4.7586745007 | |
| 46824296 | Well Park | 55.9451890371 | -4.7557627295 | |
| 46823657 | Dellingburn Street | 55.9441563365 | -4.7521014717 | |
| 46824269 | Poplar Street | 55.9358139065 | -4.7140855139 | |
| 46823597 | Bus Station | 55.9354207386 | -4.6885807133 | |
| 46892926 | John Wilson Street | 55.9376428549 | -4.7248790772 | |
| 46892928 | Gibshill Road | 55.937611977 | -4.7205850507 | |
| 46858625 | Highholm Street | 55.9347002707 | -4.6972738997 | |
| 46858943 | Bus Station | 55.9491476822 | -4.7632207783 | |
| 46824575 | Sinclair Street | 55.9384487093 | -4.7270496407 | |
| 46824579 | Sinclair Street | 55.9389005103 | -4.7277540361 | |
| 46823652 | Birkmyre Avenue | 55.9351150187 | -4.7037720927 | |
| 46823595 | Whitelees Road | 55.9350064251 | -4.7103459647 | |
| 46823638 | Braemar House | 55.9348656245 | -4.7077580031 | |
| 46824523 | Broadstone Gardens | 55.9343752639 | -4.7047133351 | |
| 46823293 | Balfour Street | 55.9349346423 | -4.6927264487 | |
| 46823936 | Princes Street | 55.935308312 | -4.6908468065 |