Stations served by electric trains

82 views
Skip to first unread message

Marcus Young

unread,
Mar 25, 2017, 2:40:43 PM3/25/17
to A gathering place for the Open Rail Data community
Hi,

Does anyone know a source for identifying which GB railway stations are served by electric trains. Needs to be this specific, rather than just knowing that the line throught the station is electrified (but may be served by diesel).

Thanks

Marcus

Shaun McDonald

unread,
Mar 25, 2017, 8:40:54 PM3/25/17
to Marcus Young, A gathering place for the Open Rail Data community
Hi Marcus,

Although I’m not aware of a ready made list of stations served by electric trains, this should be able to be calculated by going through the schedule data, which includes the “power type” which is documented on the wiki. http://wiki.openraildata.com/index.php/CIF_Codes#Power_Type

For more information about the schedules see:

You’ll also have passes in the data too, which you’ll need to take account of.

Shaun

--
You received this message because you are subscribed to the Google Groups "A gathering place for the Open Rail Data community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openraildata-t...@googlegroups.com.
To post to this group, send email to openrail...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Rail Ale Fan

unread,
Mar 26, 2017, 6:23:04 AM3/26/17
to A gathering place for the Open Rail Data community
Hi Marcus,

I can run the query suggested by Shaun easily, referring to the Power Type values ( http://wiki.openraildata.com/index.php/CIF_Codes#Power_Type ) what would be the subset required in this case?

Cheers

Rail Ale Fan

unread,
Mar 26, 2017, 8:43:58 AM3/26/17
to A gathering place for the Open Rail Data community
I made a DISTINCT query and the only power types in the current timetable appear to be DMU, EMU, HST, E and D; so assuming EMU and E as the query, this should be close...

https://live-departures.info/rail/trivia/StationsServedByElectricTrains

Cheers!

Phil Wieland

unread,
Mar 26, 2017, 10:49:54 AM3/26/17
to A gathering place for the Open Rail Data community
Sorry to spoil things but on my local lines which were electrified two years ago, the trains are still timed as DMU in the schedule database.  So that unfortunately breaks Rail Ale Fan's nifty database query.

Phil


On Saturday, March 25, 2017 at 6:40:43 PM UTC, Marcus Young wrote:

Marcus Young

unread,
Mar 27, 2017, 1:16:34 PM3/27/17
to A gathering place for the Open Rail Data community
Hi,

That's fantastic, thanks so much!


Marcus

Marcus Young

unread,
Mar 27, 2017, 1:24:02 PM3/27/17
to A gathering place for the Open Rail Data community
Hi Phil,

I'm not that concerned. Unfortunately I've discovered that much rail industry data I've looked at is inaccurate (the NRE Knowledgebase comes to mind ...). This is probably the best I'm going to get.

Marcus
Reply all
Reply to author
Forward
0 new messages