Lerwick - town service - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:20:00	08:20:00	...	1
...	08:21:00	08:21:00	...	2
...	08:22:00	08:22:00	...	3
...	08:23:00	08:23:00	...	4
...	08:23:00	08:23:00	...	5
...	08:25:00	08:25:00	...	6
...	08:26:00	08:26:00	...	7
...	08:26:00	08:26:00	...	8
...	08:26:00	08:26:00	...	9
...	08:27:00	08:27:00	...	10
...	08:28:00	08:28:00	...	11
...	08:30:00	08:30:00	...	12
...	08:31:00	08:31:00	...	13
...	08:31:00	08:31:00	...	14
...	08:31:00	08:31:00	...	15
...	08:32:00	08:32:00	...	16
...	08:32:00	08:32:00	...	17
...	08:33:00	08:33:00	...	18

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
45823684	Swarthoull	60.142843973	-1.1728368392
45823698	Gilbert Bain Hospital	60.1506489204	-1.1546481771
45823723	Bell's Road	60.1517177478	-1.1518830287
45823724	Funeral Director	60.1518783717	-1.1489250229
45823685	Sound Hall	60.1443921666	-1.1705650743
45823742	North Road	60.1591649723	-1.158050661
45823743	North Road	60.1627205052	-1.1608425132
45823745	Gremista Brae	60.1634783085	-1.1642465661
45823686	Kantersted Rd	60.1446595244	-1.1645258599
45823747	Unicorn Court	60.1599564473	-1.1739563797
45823687	Tesco	60.1472899918	-1.1601910542
45823428	Toll Clock Shopping Centre	60.1572427669	-1.1551274407
45823285	Nedersund Road	60.1453195334	-1.166670058
45823589	Unicorn Court	60.1592953408	-1.1744954101
45823594	Ferry Terminal	60.1546883629	-1.1432683984
45823678	Quoys Road	60.1409920378	-1.1768084991
45823679	Staney Hill Hall	60.1620827632	-1.1693627682
45823859	Annsbrae Gardens	60.1516739335	-1.1422841343