Salisbury - Burgate School - Transport Data Hub

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

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
15/10/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
hamadjpd	Burgate Cross	50.9463226051	-1.7819354146
hamadmda	Police Cottages	50.9568764516	-1.7755218786
hamadmdj	Village Hall	50.96129109	-1.7752158531
hamadmpm	Breamore House Turn	50.96653146	-1.7694943737
hamadmtp	South Charford Crossing	50.9724669255	-1.7652492883
hamadmwa	Lions Lodge	50.9778242994	-1.7642394711
hamjawjm	Burgate School	50.9379486584	-1.7856748063
wildwjdg	Greentrees Primary School	51.0890845683	-1.7827076851
wildwpgp	Endless Street	51.0701684958	-1.7945280174
wildwpdw	Downton Road	51.0522799502	-1.7828226823
wildgjma	Car Park	51.0674582314	-1.7924706352
wildgjaj	St Osmunds School	51.0627046718	-1.7943326958
wildgjag	Britford Lane	51.0591079633	-1.7944199547
wildgdat	Butts Road	51.0769349615	-1.7970389339
wildgjta	Dorset Road	51.0793933486	-1.7939162066
wildgmad	Arts Centre	51.0717635045	-1.7913666712
wildgmpm	College Street	51.0726034552	-1.7884083727
wildgtdm	Crematorium	51.0813673259	-1.7816302835
wildgtap	Denison Rise	51.0824752339	-1.7826386782
wildgpja	Link Way	51.082128842	-1.7849672887
wildgpdj	Denison Rise	51.0828679429	-1.7859203742
wildgwtm	St Judes Close	51.0871654993	-1.7759491028
wildgwdg	St James Close	51.08695377	-1.7780917487
wildgtgw	St Teresas Close	51.0876602331	-1.7807868597
wildgtmt	Cheverell Avenue	51.0817319585	-1.7794729102
wildgjdt	Shell Garage	51.0566503559	-1.7928613245
wildgpam	Milton Road	51.0547881606	-1.787390864
wildgwap	Bus Shelter	51.049987452	-1.7782967629
wildjdja	Bodenham Turn	51.0356622447	-1.7686670692
wildjdpa	Bus Shelterl	51.0347656379	-1.7654627011
wildjdtd	Matrimony Farmhouse	51.0226396123	-1.7632140673
wildjgda	The Stag	51.0149985243	-1.7599314326
wildjgjt	Warrens Lane	51.0115598285	-1.7581531193
wildjgjp	Industrial Estate	50.9972455615	-1.7588259505
wildjgmd	The Bull	50.9925407756	-1.7579384037
wildjdpd	Roundabout	51.0869818984	-1.7739939708
wildpwtd	Roundabout	51.0880927277	-1.7718326089