Train GraphicClick on the map to explore geographics
 
I need help
FAQ
Emergency
About .
No recent travel & transport from BBC stories as at 03:15 29 Apr 2024
Read about the forum [here].
Register [here] - it's free.
What do I gain from registering? [here]
 22/05/24 - WWRUG / TransWilts update
02/06/24 - Summer Timetable starts
17/08/24 - Bus to Imber
27/09/25 - 200 years of passenger trains

On this day
29th Apr (1973)
Patent award for Janney (Buckeye) coupling (*)

Train RunningNo cancellations or delays
PollsThere are no open or recent polls
Abbreviation pageAcronymns and abbreviations
Stn ComparatorStation Comparator
Rail newsNews Now - live rail news feed
Site Style 1 2 3 4
Next departures • Bristol Temple MeadsBath SpaChippenhamSwindonDidcot ParkwayReadingLondon PaddingtonMelksham
Exeter St DavidsTauntonWestburyTrowbridgeBristol ParkwayCardiff CentralOxfordCheltenham SpaBirmingham New Street
April 29, 2024, 03:25:36 *
Welcome, Guest. Please login or register.

Login with username, password and session length
Forgotten your username or password? - get a reminder
Most recently liked subjects
[110] Clan Line - by Clan Line !
[76] Visiting the pub on the way home.
[28] South Western Railways Waterloo - Bristol services axed
[27] access for all at Devon stations report
[17] Labour to nationalise railways within five years of coming to ...
[14] Misleading advertising?
 
News: the Great Western Coffee Shop ... keeping you up to date with travel around the South West
 
   Home   Help Search Calendar Login Register  
Pages: [1]
  Print  
Author Topic: HSTs...  (Read 7053 times)
paulo999
Jr. Member
**
Posts: 17


View Profile Email
« on: December 30, 2014, 01:27:49 »

After being detrained on the last attempt to be on board an HST (High Speed Train) 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 Sad )...

... 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
Logged
paulo999
Jr. Member
**
Posts: 17


View Profile Email
« Reply #1 on: December 30, 2014, 01:30:55 »

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 (High Speed Train)' and
         l.TIPLOCCode = 'HONYBRN' and
         ac.LocationCodeEnd = 'PAD» (Paddington (London) - next trains)' and
         l.ScheduledDeparture is not null and
         getdate() between bs.DateRunsFrom and bs.DateRunsTo
   order by   DateRunsFrom,
            DateRunsTo,
            DaysRun,
            PublicDeparture
Logged
tomL
Transport Scholar
Sr. Member
******
Posts: 212


View Profile
« Reply #2 on: December 31, 2014, 22:26:25 »

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 (Customer Information System) doesn't always work...  Grin Roll Eyes
Logged

paulo999
Jr. Member
**
Posts: 17


View Profile Email
« Reply #3 on: January 05, 2015, 05:52:20 »

There's *alot* of things that need interpretation! I'm getting there but OMG (Oh My doG ).
Logged
Do you have something you would like to add to this thread, or would you like to raise a new question at the Coffee Shop? Please [register] (it is free) if you have not done so before, or login (at the top of this page) if you already have an account - we would love to read what you have to say!

You can find out more about how this forum works [here] - that will link you to a copy of the forum agreement that you can read before you join, and tell you very much more about how we operate. We are an independent forum, provided and run by customers of Great Western Railway, for customers of Great Western Railway and we welcome railway professionals as members too, in either a personal or official capacity. Views expressed in posts are not necessarily the views of the operators of the forum.

As well as posting messages onto existing threads, and starting new subjects, members can communicate with each other through personal messages if they wish. And once members have made a certain number of posts, they will automatically be admitted to the "frequent posters club", where subjects not-for-public-domain are discussed; anything from the occasional rant to meetups we may be having ...

 
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
This forum is provided by customers of Great Western Railway (formerly First Great Western), and the views expressed are those of the individual posters concerned. Visit www.gwr.com for the official Great Western Railway website. Please contact the administrators of this site if you feel that the content provided by one of our posters contravenes our posting rules (email link to report). Forum hosted by Well House Consultants

Jump to top of pageJump to Forum Home Page