Boddam - Peterhead Academy - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	14:55:00	14:55:00	...	1
...	14:57:00	14:57:00	...	2
...	14:57:00	14:57:00	...	3
...	14:59:00	14:59:00	...	4
...	15:01:00	15:01:00	...	5
...	15:02:00	15:02:00	...	6
...	15:03:00	15:03:00	...	7
...	15:04:00	15:04:00	...	8
...	15:05:00	15:05:00	...	9
...	15:06:00	15:06:00	...	10
...	15:06:00	15:06:00	...	11
...	15:09:00	15:09:00	...	12
...	15:10:00	15:10:00	...	13
...	15:11:00	15:11:00	...	14
...	15:12:00	15:12:00	...	15
...	15:13:00	15:13:00	...	16
...	15:14:00	15:14:00	...	17
...	15:15:00	15:15:00	...	18
...	15:15:00	15:15:00	...	19
...	15:17:00	15:17:00	...	20

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

stop_code	stop_name	stop_lat	stop_lon
23627694	Gordon Avenue	57.4715848436	-1.7853103442
23627849	Manse Terrace	57.4716149168	-1.781892303
23627848	Sandford Place	57.4730875241	-1.7815834231
23627832	View Gardens	57.4738654939	-1.7795612889
23627837	Harbour Street	57.4728572094	-1.7782835256
23627845	Harbour Street	57.4716975031	-1.7777403462
23627854	Queen's Road	57.4707302317	-1.779363406
23627649	HM Prison	57.4911978338	-1.7931357632
23634636	Business Centre	57.4868626535	-1.8008327905
23627639	Mackenzie Crescent	57.4927541123	-1.794544956
23627625	Monument Close	57.4943018232	-1.7962212417
23627597	Skerry Drive	57.4969799095	-1.7970238597
23627628	Baylands Crescent	57.4990873085	-1.7948598104
23627656	Links Terrace	57.5023164875	-1.7920884459
23627852	Weavers Lane	57.5054295547	-1.7897511454
23627823	Gordon Avenue	57.472041587	-1.7845073792
23627659	Cairntrodlie	57.5057289885	-1.7915684244
23629759	Station Road	57.4709989335	-1.7894318166
23632945	Roundabout	57.4859487473	-1.8023055135
23627672	Academy	57.5095810444	-1.7906953097