• Our booking engine at tickets.railforums.co.uk (powered by TrainSplit) helps support the running of the forum with every ticket purchase! Find out more and ask any questions/give us feedback in this thread!

Fares parser?

Status
Not open for further replies.

Doctor Fegg

Established Member
Joined
9 Nov 2010
Messages
1,814
What open-source parsers exist that can take the ATOC fare database and munge it into a more-or-less queryable form?

Ideally something that can be installed on a *nix box, rather than Windows. I've seen Matthew Somerville's code at https://github.com/dracos/split-ticket but wonder if there are others.
 
Sponsor Post - registered members do not see these adverts; click here to register, or click here to log in
R

RailUK Forums

Doctor Fegg

Established Member
Joined
9 Nov 2010
Messages
1,814
Not yn Gymraeg then?

It's one of those questions where "if you know the answer, you understand the question", but if you insist... :)

I am looking for some computer code, with liberal copyright restrictions, that can take the fares data published by the Association of Train Operating Companies, and adapt it into a format where you can ask it to "tell me the fares from London to Birmingham". This computer code should run on a computer based on the Unix family of operating systems, principally Linux and Mac.
 

RJ

Established Member
Joined
25 Jun 2005
Messages
8,383
Location
Back office
I don't know, but I get on well with it being imported into a SQL database. "soil" provided the means to do this a couple of years ago, for which I am ever grateful. Unfortunately, it's no longer as simple as importing new fare datasets in - I had to make some amendments in order to get it working for more recent fare rounds.
 
Last edited:

Doctor Fegg

Established Member
Joined
9 Nov 2010
Messages
1,814
That looks great - but Windows-only, sadly. Worth knowing though, thanks!
 

yorkie

Forum Staff
Staff Member
Administrator
Joined
6 Jun 2005
Messages
67,429
Location
Yorkshire
I'm not sure if we'll run any more or not, but if we do, would you (or anyone else) be interested in our software development & open data fares workshops?

By the way have you seen http://www.farehistory.info/ ?
 

Doctor Fegg

Established Member
Joined
9 Nov 2010
Messages
1,814
I'm not sure if we'll run any more or not, but if we do, would you (or anyone else) be interested in our software development & open data fares workshops?

Could be - my weekends tend to be fairly booked up but do let me know if/when another one is organised.


Oooh, no, I hadn't. That's very neat.

I've been experimenting with making very basic maps out of fare data (as parsed by Matthew Somerville's train split code), for example showing points for each station colour-coded by SOR price - from light grey for cheap up to black for expensive. Quite an good way to spot peculiarities and anomalies...
 

headshot119

Established Member
Joined
31 Dec 2010
Messages
2,052
Location
Dubai
Status
Not open for further replies.

Top