Glespin - Lanark - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:20:00	07:20:00	...	1
...	07:20:35	07:20:35	...	2
...	07:20:58	07:20:58	...	3
...	07:21:33	07:21:33	...	4
...	07:24:01	07:24:01	...	5
...	07:24:48	07:24:48	...	6
...	07:25:15	07:25:15	...	7
...	07:35:00	07:35:00	...	8
...	07:35:19	07:35:19	...	9
...	07:36:06	07:36:06	...	10
...	07:39:00	07:39:00	...	11
...	07:41:40	07:41:40	...	12
...	07:42:41	07:42:41	...	13
...	07:43:13	07:43:13	...	14
...	07:43:34	07:43:34	...	15
...	07:43:56	07:43:56	...	16
...	07:44:18	07:44:18	...	17
...	07:44:32	07:44:32	...	18
...	07:44:46	07:44:46	...	19
...	07:45:00	07:45:00	...	20
...	07:45:21	07:45:21	...	21
...	07:52:01	07:52:01	...	22
...	07:52:28	07:52:28	...	23
...	07:53:00	07:53:00	...	24

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
24/09/2012 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
75234984	Bus Station	55.6731852363	-3.7720307397
75236382	Auctioneers Way	55.67036861	-3.7673079619
75236586	Home Street	55.6694661767	-3.7631966761
75234748	Lake Avenue	55.6676521293	-3.7574705722
75234938	Hyndford Lodge	55.6608256515	-3.7319516198
75234365	Hyndford Grange	55.656339684	-3.7276048071
75234876	Holmview	55.6537487213	-3.7252495798
75235234	Mountstuart Avenue	55.5984987972	-3.7792958585
75234525	Beechgrove Street	55.5966141705	-3.7815912339
75235356	Old School	55.5943949929	-3.7901876437
75234238	Millbank Wood	55.5774716525	-3.8092309675
75235256	Springhill Road	55.5569889885	-3.8448837901
75232534	Dale Street	55.5548915674	-3.8427243769
75234364	Brownhill Avenue	55.5506403691	-3.8445387177
75234856	Gateside Road	55.5521031432	-3.8470645583
75236839	Manse View Terrace	55.5535817973	-3.8461509799
75235646	Ayr Road	55.5547929412	-3.8480786323
75232734	Hillview Crescent	55.5340578063	-3.8888609691
75234954	Stablestone Pr School	55.5318467715	-3.8958537741
75235328	Hagshaw View	55.5524666874	-3.8414218406
75236526	Ayr Road	55.5330894916	-3.8922055981
75258236	Eggerton Bridge	55.5628147073	-3.8291563248
75238376	Lady Home Cottage Hospital	55.5586043213	-3.8390610101
75238384	Springhill Crescent	55.5504475959	-3.8471929737