Greenhills - Hairmyres Station - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:53:00	17:53:00	...	1
...	17:53:20	17:53:20	...	2
...	17:53:54	17:53:54	...	3
...	17:54:31	17:54:31	...	4
...	17:55:00	17:55:00	...	5
...	17:55:21	17:55:21	...	6
...	17:56:06	17:56:06	...	7
...	17:56:20	17:56:20	...	8
...	17:56:55	17:56:55	...	9
...	17:57:47	17:57:47	...	10
...	17:58:01	17:58:01	...	11
...	17:58:23	17:58:23	...	12
...	17:58:59	17:58:59	...	13
...	17:59:31	17:59:31	...	14
...	18:00:04	18:00:04	...	15
...	18:00:35	18:00:35	...	16
...	18:01:25	18:01:25	...	17
...	18:02:00	18:02:00	...	18
...	18:02:37	18:02:37	...	19
...	18:03:18	18:03:18	...	20
...	18:04:15	18:04:15	...	21
...	18:04:47	18:04:47	...	22
...	18:05:36	18:05:36	...	23
...	18:06:22	18:06:22	...	24
...	18:07:21	18:07:21	...	25
...	18:07:57	18:07:57	...	26
...	18:08:00	18:08:00	...	27
...	18:08:27	18:08:27	...	28
...	18:09:10	18:09:10	...	29
...	18:09:46	18:09:46	...	30
...	18:10:15	18:10:15	...	31
...	18:10:43	18:10:43	...	32
...	18:11:41	18:11:41	...	33
...	18:12:18	18:12:18	...	34
...	18:12:55	18:12:55	...	35
...	18:13:19	18:13:19	...	36
...	18:13:51	18:13:51	...	37
...	18:14:23	18:14:23	...	38
...	18:15:00	18:15:00	...	39

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
19/03/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
75232376	Rosa Burn Avenue	55.7410859846	-4.200121154
75234275	Rosa Burn Avenue	55.7412702545	-4.2003704995
75234926	Durban Avenue	55.7393764465	-4.2037367848
75234725	Durban Avenue	55.7394891673	-4.2039661711
75232849	Lomond	55.7433389256	-4.1801254945
75234684	Ardochrig	55.743988073	-4.1759555239
75236283	Fortieth Avenue	55.7424319767	-4.1719655785
75235843	Ladysmith Drive	55.7382256089	-4.2092634284
75236585	Cheviot Crescent	55.7380906469	-4.2092717306
75236279	Clarkin Avenue	55.7389086372	-4.2127589686
75236798	Clarkin Avenue	55.73878208	-4.2127995956
75272425	Strathnairn Avenue	55.7597126142	-4.2268003365
75237979	Larch Drive	55.7433174825	-4.1989721931
75239359	Strathtay Avenue	55.7579455304	-4.2305726242
75234376	Greenhills Way	55.7482256418	-4.1923807179
75235474	Greenhills Sports Centre	55.745459333	-4.1983119917
75232456	Auchengilloch	55.7444379809	-4.1840265916
75237254	High Whitehills Road	55.7454616751	-4.1866012418
75232863	Sycamore Crescent	55.7482420833	-4.1874260742
75232437	Lickprivick Road	55.7433070229	-4.2030662126
75236528	Shopping centre	55.7448662086	-4.2048270745
75236843	Oak Avenue	55.7481016146	-4.2038304998
75234975	Troon Avenue	55.7502157306	-4.2057185514
75235295	Canberra Drive	55.7540072482	-4.1937410616
75232978	Owen Avenue	55.7529508993	-4.2000403047
75235325	Westwood Playing Fields	55.7522357962	-4.2043346191
75236953	Mossneuk Road	55.7571179637	-4.2082280548
75236748	Westwoodhill Road	55.7565413652	-4.2098051715
75234369	Pitcairn Place	55.7558291765	-4.216410812
75234593	Pitcairn Crescent	55.7557376631	-4.2209796728
75232923	Firlee	55.755435484	-4.2227793504
75236426	Tay Court	55.754969903	-4.2286336779
75236235	Mossneuk Avenue	55.7558194423	-4.2308496535
75232864	Hairmyres Station	55.7613394223	-4.2203418475
75236384	Hairmyres Hospital	55.7606321243	-4.2226766181
75234859	Columbia Way	55.7578640466	-4.2057201086
75235753	Westwood Square	55.757742081	-4.2009955063
75236346	Red Deer Road	55.7576832195	-4.1967526325
75235394	Murrayhill	55.7562800521	-4.1932949498