• Our new ticketing site is now live! Using either this or the original site (both 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!

ATOC Open Data Update

Status
Not open for further replies.
Paul Kelly

Paul Kelly

Verified Rep - BR Fares
Joined
16 Apr 2010
Messages
4,224
Location
Reading
The fares data download on data.atoc.org has been updated today (with a data extract from last Tuesday!). Maybe useful for anybody who likes loading the data into their own database to look for interesting changes. BR Fares has been updated with the new data and is now showing "PRIV" Off-Peak fares at last...
 
Sponsor Post - registered members do not see these adverts; click here to register, or click here to log in
R

RailUK Forums

RJ

RJ

Established Member
Joined
25 Jun 2005
Messages
8,811
Location
Back office
Excellent stuff - I'll get to work on it tomorrow. This open data is great, makes it so easy to identify "useful" fares :)
 
I

infobleep

On Moderation
Joined
27 Feb 2011
Messages
13,451
What software do you use RJ? Does anyone know if the fates database loads into Microsoft Access 2003?
 
RJ

RJ

Established Member
Joined
25 Jun 2005
Messages
8,811
Location
Back office
I use soil's program to import the data then the SQL server Studio to perform the queries. It has worked for the last few releases, but ATOC have changed something in the latest release, something to do with the TOCs assigned to the "FCC" code so it might need a slight change to be made this time around.
 
Status
Not open for further replies.

Top