Which TOCS serve each station.

[Phillip Vessey]

Hi

Is there a list kept anywhere or that anyone has of which TOC's serve each station?

E.g. Doncaster Station served by trains from Virgin Trains East Coast (GR), TransPennine Express (TP) etc

Thanks

[Peter Hicks (Poggs)]

Hello

On 23 Sep 2017, at 08:43, Phillip Vessey <phillip...@gmail.com> wrote:

Is there a list kept anywhere or that anyone has of which TOC's serve each station?

E.g. Doncaster Station served by trains from Virgin Trains East Coast (GR), TransPennine Express (TP) etc

I’m not sure there’s an industry version, but you could build one yourself based on a few days worth of timetables from Darwin.

Peter

[NRE Online Services]

Hi,

As Peter says, this is a fairly easy query with a few days of timetable data. As it happens we provide an ad-hoc report on this internally so I've attached for September to date...

Andrew

[Thomas Wood]

Interestingly, there's apparently one Southern service calling at Penzance in that dataset, which seems highly unlikely!

Thomas

--
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-talk+unsubscribe@googlegroups.com.
To post to this group, send email to openraildata-talk@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[petermount]

I've just run a query on my Darwin DB and only show Cross Country & Great Western for Penzance

rail=> select distinct s.toc,t.* from darwin.schedule_entry e inner join darwin.schedule s on e.schedule=s.id inner join darwin.toc t on s.toc=t.code inner join darwin.location l on e.tpl=l.tpl inner join darwin.crs c on l.crs=c.id  where c.crs='PNZ';

 toc | id | code |         name          |                         url                          

-----+----+------+-----------------------+------------------------------------------------------

 XC  | 33 | XC   | CrossCountry          | http://www.nationalrail.co.uk/tocs_maps/tocs/XC.aspx

 GW  | 10 | GW   | Great Western Railway | http://www.nationalrail.co.uk/tocs_maps/tocs/GW.aspx

(2 rows)

On Monday, 25 September 2017 17:32:13 UTC+1, Thomas Wood wrote:

Interestingly, there's apparently one Southern service calling at Penzance in that dataset, which seems highly unlikely!

Thomas

On 25 September 2017 at 10:45, 'NRE Online Services' via A gathering place for the Open Rail Data community <openrail...@googlegroups.com> wrote:

Hi,

As Peter says, this is a fairly easy query with a few days of timetable data. As it happens we provide an ad-hoc report on this internally so I've attached for September to date...

Andrew

--
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.

[Rail Delivery Group]

Hmmm, it seems that there is a bug in the report in that deleted services are not being excluded as they should be. This record comes from a schedule which was added on 15/9 and then subsequently deleted 10 mins later. Looking at it I suspect because someone created a test schedule in the production system...tut, tut, tut!

<?xml version="1.0" encoding="UTF-8"?><Pport xmlns="http://www.thalesgroup.com/rtti/PushPort/v12" xmlns:ns2="http://www.thalesgroup.com/rtti/PushPort/Schedules/v1" ts="2017-09-15T19:19:00.533874+01:00" version="12.0"><uR updateOrigin="Workstation"><schedule rid="201709167902928" ssd="2017-09-16" toc="SN" trainId="1Z75" uid="O02928"><ns2:OR act="TB" ptd="23:00" tpl="BRGHTN" wtd="23:00"/><ns2:IP act="T " pta="23:15" ptd="23:15" tpl="KLYNN" wta="23:15" wtd="23:15"/><ns2:DT act="TF" pta="23:25" tpl="PENZNCE" wta="23:25"/></schedule></uR></Pport>

<?xml version="1.0" encoding="UTF-8"?><Pport xmlns="http://www.thalesgroup.com/rtti/PushPort/v12" xmlns:ns2="http://www.thalesgroup.com/rtti/PushPort/Schedules/v1" ts="2017-09-15T19:31:45.9594472+01:00" version="12.0"><uR updateOrigin="Workstation"><schedule deleted="true" rid="201709167902928" ssd="2017-09-16" toc="SN" trainId="1Z75" uid="O02928"><ns2:OR act="TB" ptd="23:00" tpl="BRGHTN" wtd="23:00"/><ns2:IP act="T " pta="23:15" ptd="23:15" tpl="KLYNN" wta="23:15" wtd="23:15"/><ns2:DT act="TF" pta="23:25" tpl="PENZNCE" wta="23:25"/></schedule></uR></Pport>

I'll arrange for the bug to be fixed.