I have a problem trying to join up train station data from different sources. There seems to be a standard to use 3 letter codes to represent each station. However, everyone seems to be using different codes.
For example, Stratford station in London has the following codes:
- National rail: SRA
- DLR: STR
- TFL: SFD (or sometimes 1000226)
To add to the confusion, codes in one dataset can be used for different stations in other datasets (eg National Rail use STR to mean Stranraer).
Where would be the best place to find a mapping between all these different identifiers? Alternatively, if there is no such mapping, where would be a good place to begin building one, in a way that others can contribute to and use the data?