Sandridge - St Albans - Tyttenhanger / Welham Green
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 11:42:00 | 11:42:00 | ... | 1 |
|
| ... | 11:44:00 | 11:44:00 | ... | 2 |
|
| ... | 11:44:00 | 11:44:00 | ... | 3 |
|
| ... | 11:45:00 | 11:45:00 | ... | 4 |
|
| ... | 11:46:00 | 11:46:00 | ... | 5 |
|
| ... | 11:47:00 | 11:47:00 | ... | 6 |
|
| ... | 11:48:00 | 11:48:00 | ... | 7 |
|
| ... | 11:49:00 | 11:49:00 | ... | 8 |
|
| ... | 11:50:00 | 11:50:00 | ... | 9 |
|
| ... | 11:53:00 | 11:53:00 | ... | 10 |
|
| ... | 11:53:00 | 11:53:00 | ... | 11 |
|
| ... | 11:54:00 | 11:54:00 | ... | 12 |
|
| ... | 11:56:00 | 11:56:00 | ... | 13 |
|
| ... | 11:58:00 | 11:58:00 | ... | 14 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 16/10/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| hrtdagpd | St Leonard's Church | 51.7814374635 | -0.3046623568 | |
| hrtdagdm | Village Hall | 51.7788679505 | -0.307310009 | |
| hrtdagdp | Reynolds Crescent | 51.7767232682 | -0.3101154308 | |
| hrtdagdw | Sandringham Crescent | 51.7727170687 | -0.3160482928 | |
| hrtdagja | Sandridge Gate Business Centre | 51.7696372953 | -0.3188731586 | |
| hrtdadgp | King William IV PH | 51.7670292362 | -0.3238829901 | |
| hrtdadgt | Lancaster Road | 51.7651191985 | -0.3236204216 | |
| hrtdadgw | Firbank Road | 51.7675771735 | -0.3276307738 | |
| hrtdadja | Seymour Road | 51.7629375402 | -0.3263820904 | |
| hrtdadjd | Boundary Road | 51.760763154 | -0.3290272976 | |
| hrtdadjg | Chime Square | 51.756969352 | -0.3341516271 | |
| hrtawtdw | St Peter's Street | 51.7539142338 | -0.3368429467 | |
| hrtatpdt | Valley Road | 51.7678337465 | -0.3235488439 | |
| hrtatmpj | Lyndon Mead | 51.7816612142 | -0.2996089547 |