Greenhills - Hairmyres Station - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:23:00	17:23:00	...	1
...	17:23:20	17:23:20	...	2
...	17:23:54	17:23:54	...	3
...	17:24:31	17:24:31	...	4
...	17:25:00	17:25:00	...	5
...	17:25:21	17:25:21	...	6
...	17:26:06	17:26:06	...	7
...	17:26:20	17:26:20	...	8
...	17:26:55	17:26:55	...	9
...	17:27:47	17:27:47	...	10
...	17:28:01	17:28:01	...	11
...	17:28:23	17:28:23	...	12
...	17:28:59	17:28:59	...	13
...	17:29:31	17:29:31	...	14
...	17:30:04	17:30:04	...	15
...	17:30:35	17:30:35	...	16
...	17:31:25	17:31:25	...	17
...	17:32:00	17:32:00	...	18
...	17:32:37	17:32:37	...	19
...	17:33:18	17:33:18	...	20
...	17:34:15	17:34:15	...	21
...	17:34:47	17:34:47	...	22
...	17:35:36	17:35:36	...	23
...	17:36:22	17:36:22	...	24
...	17:37:21	17:37:21	...	25
...	17:37:57	17:37:57	...	26
...	17:38:00	17:38:00	...	27
...	17:38:27	17:38:27	...	28
...	17:39:10	17:39:10	...	29
...	17:39:46	17:39:46	...	30
...	17:40:15	17:40:15	...	31
...	17:40:43	17:40:43	...	32
...	17:41:41	17:41:41	...	33
...	17:42:18	17:42:18	...	34
...	17:42:55	17:42:55	...	35
...	17:43:19	17:43:19	...	36
...	17:43:51	17:43:51	...	37
...	17:44:23	17:44:23	...	38
...	17:45:00	17:45: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