LocoTrack

Database fields:

There are six main databases, Locomotives, DMU's, EMU's, Coaches, Non Passenger Carrying Stock and Wagons, which contain tables for Historical Data, TOPS Data and data input by the User.

Locomotives:

Loco History - Number, Class, Old numbers, Pre TOPS numbers, Old Names, Seen?, Times Seen, Location, Date, Haulage?, Photo?, Preserved?,  Picture.

Loco TOPS - Status, Livery, Pool Code, Allocation Code, Current Name, TOPS Notes.

Sightings Input - Number, Date, Time, Location, Train Details, Seen Notes, Sighting Picture

Haulage Log – Number, Date, Start, End, Miles, Reporting Code, route, Train Start/Dest, Start Time, End Time, Coach, Total Distance, haulage Notes, haulage Picture, Sum Total Miles

Loco Photos Input – Number, Photo Code, Photo Location, Photo Date, Exposure Details, Photos Picture

All these tables are linked in the Overview and Summary Forms, for example to show Historical and TOPS data for each sighting.

All diesel and electric Locomotives and shunters, which have run on British railways, are included.

All data can be modified or new data added .  TOPS data can be updated by deleting current data and uploading with new data, without affecting an of the users’ records.

The Picture field in this and all other databases provides a permanent Hyperlink to a unique photo of the particular loco stored on your PC, for every record in the database.

Diesel Multiple Units;

DMU History - Coach Number, Set Number, Old numbers, Class, Type, General Notes, Seen?, Date Seen, Location, Times seen, Haulage?,  Photo?, Picture

DMU TOPS – Set, Status, Livery, Pool Code, Allocation Code, Name, TOPS Notes

DMU Sightings Input – Coach, set, Date, Time, Location, Train Details, Seen Notes, Sighting Picture

DMU Haulage Log – Coach, Set, Date, Start, End, Miles, Reporting Code, route, Train Start / Destination, Start Time, End Time, Total Distance, Haulage Notes, Sum Total Miles

DMU Photos Input – Coach, Set, Photo Code, Photo Date, Photo Location, Exposure Details, Photos Picture

DMU's can be sorted in Coach or Unit order.

All current and Heritage DMU's are included.

Electric Multiple Units;

EMU History - Coach Number, Set Number, Old numbers, Class, Type, General Notes, Seen?, Date Seen, Location, Times seen, Haulage?,  Photo?, Picture

EMU TOPS – Set, Status, Livery, Pool Code, Allocation Code, Name, TOPS Notes

EMU Sightings Input – Coach, set, Date, Time, Location, Train Details, Seen Notes, Sighting Picture

EMU Haulage Log – Coach, Set, Date, Start, End, Miles, Reporting Code, route, Train Start / Destination, Start Time, End Time, Total Distance, Haulage Notes, Sum Total Miles

EMU Photos Input – Coach, Set, Photo Code, Photo Date, Photo Location, Exposure Details, Photos Picture

EMU's can be sorted in Coach or Unit order.

Only current EMU's are included, but further units can be added by the user, if required.

Coaches;

Coach History - Number, Old number, Description, Code, TOPS Code, Type, Name, Seen, Date, Location, Times seen, Haulage, Times Hauled, Total Distance, Photo, Photo code, Link to Photo, and Notes.

Coach TOPS – Number, Status, Livery, Pool Code, Allocation Code, Picture

All Mark 1, 2, 3 and 4 coaches are included.

Non Passenger carrying Stock;

Non Passenger History - Number, Old number, Description, Code, TOPS Code, Type, Seen, Date, Location, Times seen, Photo, Photo code, Link to Photo,  Name and Notes.

Non Passenger TOPS – Number, Status, Livery, Pool Code, Allocation Code

All Mark 1 types are included (e.g. BG's and GUV's), including all the renumberings.

Wagons;

Wagons are split into two databases for UK Wagons and International Wagons which run in the UK .

For UK Wagons fields are;

UK wagons - Number, Old Numbers, Prefix, TOPS Code, Description, Capacity, Gross Weight, Status, Livery, Owner, Seen, Date, Location, Times Seen, Photo, Photo Code, Link to Photo, and Notes.

Sightings Input - Number, date, Time, Location, Train Details, Sighting Notes, Photo, Photo Code, Link to Photo.

For International Wagons the fields are;

International Wagons - Number, Old Numbers, Exchange Code, TOPS Code, British/Foreign, Description, Capacity, Gross Weight, Status, Livery, Owner, Seen, Date, Location, Times Seen, Photo, Photo Code, Link to Photo, and Notes.

Sightings Input - Number, Check Digit, Date, Time, Location, Train Details, Sighting Notes, Photo, Photo Code, Link to Photo.

Wagon data is not provided for Status, Livery and Owner fields.

Other databases;

LocoTrack  also includes reference databases for Pool Codes, Allocation Codes, Liveries,  Locomotive Data, Coach Codes and Wagon Codes.