Hacker News Reader

Comment by Symbiote | Hacker News Reader

Adding national identifiers could be useful. "SMG" is St Margarets in London, "SMT" is St Margarets in Hertfordshire, and commuters using either probably know the code — it's exposed on official websites.

Here are the national three-letter codes for stations in Great Britain, available in CSV format: http://www.nationalrail.co.uk/stations_destinations/48541.as...

View on HN

There is a field called sncf_id that includes SNCF-specific codes (and similar ones for other carriers); there could be a nationalrail_id field as well. Great suggestion! You totally should create an issue on GitHub.

(Disclaimer, here I speak for myself but work at Capitaine Train.)

"National IDs" for the Germain stations would be so-called RL100: http://fahrweg.dbnetze.com/file/fahrweg-de/2394144/vHBDX5Ond...

Wow! I didn’t know about those ids, thank you. However it would be some work to match the stations. What call the db_id is called IBNR as Internationaler Bahnhofs Nummer

Few weeks ago failed to find public IBNR/RL100 mappings. So we ended up typing 200 main stations per hand (basis was Wikipedia).

DB has the data in systems (for instance, ETN), it's just, well, not open...

Welcome to my world ;)

If you feel like exchanging information on this veeeeery specialized topic, check the open-transport mailing list run by OKFN: https://lists.okfn.org/pipermail/open-transport/

I am on that list since a while :) We met at the Okfn-conf in Geneva.

I am waiting until we translate the blogpost and our page in English before talking about that on the list. Pieter Colpaert alreday complained about uri/linked data ;)

Sorry, Tristram, I didn't mean to address this hint to you – I know you're on there already :D This was meant more as a general hint to anybody interested.

Reply on news.ycombinator.com