Great Western Coffee Shop

After being detrained on the last attempt to be on board an HST on the Cotswolds line, I spent a few hours in a very nice cafe in Oxford, laptop in full flight, coding an ingestion of the publicly available timetable data.

What's worse than my obsession with being on the advertised rolling stock ("Get over it"... I know :( )...

... is I can query the schedule at will now.

Here's Honeybourne to Paddington. They *do* exist. On the timetable.

DateFrom / DateTo / DaysRunning / Dep

2014-12-14   2015-01-04   0000001   15:55:00
2014-12-14   2015-01-04   0000001   16:56:00
2014-12-14   2015-01-04   0000001   17:59:00
2014-12-15   2015-01-01   1111000   21:28:00
2014-12-15   2015-01-01   1111000   23:08:00
2014-12-15   2015-01-02   1111100   05:34:00
2014-12-15   2015-01-02   1111100   06:56:00
2014-12-15   2015-01-02   1111100   07:58:00
2014-12-15   2015-01-02   1111100   14:35:00
2014-12-15   2015-01-02   1111100   16:30:00
2014-12-19   2015-01-02   0000100   21:28:00
2014-12-19   2015-01-02   0000100   23:08:00
2014-12-20   2015-01-03   0000010   07:33:00
2014-12-20   2015-01-03   0000010   08:32:00
2014-12-20   2015-01-03   0000010   09:36:00
2014-12-20   2015-01-03   0000010   13:34:00
2014-12-20   2015-01-03   0000010   16:28:00
2014-12-20   2015-01-03   0000010   20:31:00
2014-12-20   2015-01-03   0000010   21:40:00

For the data geeky minded...

select   bs.DateRunsFrom,
      bs.DateRunsTo,
      bs.DaysRun,
      l.PublicDeparture
   from Timetable.BasicSchedule bs
      join Timetable.Location l
         on l.BasicScheduleID = bs.BasicScheduleID
      join Timetable.CallingPattern3Alpha as ac
         on ac.CallingPattern3AlphaID = bs.CallingPattern3AlphaID
   where   bs.PowerType = 'HST' and
         l.TIPLOCCode = 'HONYBRN' and
         ac.LocationCodeEnd = 'PAD' and
         l.ScheduledDeparture is not null and
         getdate() between bs.DateRunsFrom and bs.DateRunsTo
   order by   DateRunsFrom,
            DateRunsTo,
            DaysRun,
            PublicDeparture

How are you finding working with the data? I've been experimenting with it for a while and some things seem really botched. No wonder the CIS doesn't always work...  ;D ::)

There's *alot* of things that need interpretation! I'm getting there but OMG.