Lerwick - town service
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 17:21:00 | 17:21:00 | ... | 1 |
|
| ... | 17:22:00 | 17:22:00 | ... | 2 |
|
| ... | 17:24:00 | 17:24:00 | ... | 3 |
|
| ... | 17:24:00 | 17:24:00 | ... | 4 |
|
| ... | 17:25:00 | 17:25:00 | ... | 5 |
|
| ... | 17:26:00 | 17:26:00 | ... | 6 |
|
| ... | 17:27:00 | 17:27:00 | ... | 7 |
|
| ... | 17:28:00 | 17:28:00 | ... | 8 |
|
| ... | 17:29:00 | 17:29:00 | ... | 9 |
|
| ... | 17:32:00 | 17:32:00 | ... | 10 |
|
| ... | 17:33:00 | 17:33:00 | ... | 11 |
|
| ... | 17:33:00 | 17:33:00 | ... | 12 |
|
| ... | 17:34:00 | 17:34:00 | ... | 13 |
|
| ... | 17:35:00 | 17:35:00 | ... | 14 |
|
| ... | 17:37:00 | 17:37:00 | ... | 15 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 18/08/2014 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 45823729 | South Lochside | 60.1509248711 | -1.1599182791 | |
| 45823734 | Robertson Crescent | 60.1543006468 | -1.159850191 | |
| 45823736 | North Lochside | 60.1574558695 | -1.1575719375 | |
| 45823689 | Murrayston | 60.1460589532 | -1.1685962399 | |
| 45823693 | Sound Primary School | 60.1447296618 | -1.1728435241 | |
| 45823435 | Norstane | 60.162441364 | -1.1678402818 | |
| 45823286 | Sound Service Station | 60.1472860472 | -1.1652516452 | |
| 45823284 | Ackrigarth | 60.1433867477 | -1.1778110708 | |
| 45823289 | Clickimin Road | 60.1497395744 | -1.1570848817 | |
| 45823287 | Tesco | 60.1483678163 | -1.161658364 | |
| 45823589 | Unicorn Court | 60.1592953408 | -1.1744954101 | |
| 45823592 | Shetland Hotel | 60.1623222439 | -1.1589248341 | |
| 45823673 | Co-Op | 60.1595075504 | -1.156852875 | |
| 45823678 | Quoys Road | 60.1409920378 | -1.1768084991 | |
| 45823695 | Clickimin Rd | 60.1494983787 | -1.1586939507 |