List of European train stations and associated metadata

Re:List of European train stations and associated metadata by Symbiote on Thursday April 23, 2015 @08:28AM (#9426205)

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...

[ Parent | on HN ]

Re:List of European train stations and associated metadata by espadrine on Thursday April 23, 2015 @08:39AM (#9426253)

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.)

[ Parent | on HN ]

Re:List of European train stations and associated metadata by orless on Thursday April 23, 2015 @08:45AM (#9426279)

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

[ Parent | on HN ]

Re:List of European train stations and associated metadata by tristramg on Thursday April 23, 2015 @08:56AM (#9426323)

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

[ Parent | on HN ]

Re:List of European train stations and associated metadata by orless on Thursday April 23, 2015 @09:02AM (#9426355)

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...

[ Parent | on HN ]

Re:List of European train stations and associated metadata by tristramg on Thursday April 23, 2015 @09:15AM (#9426412)

Welcome to my world ;)

[ Parent | on HN ]

Re:List of European train stations and associated metadata by _stk on Thursday April 23, 2015 @09:58AM (#9426666)

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/

[ Parent | on HN ]

Re:List of European train stations and associated metadata by tristramg on Thursday April 23, 2015 @12:47PM (#9428006)

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 ;)

[ Parent | on HN ]

Re:List of European train stations and associated metadata by _stk on Saturday April 25, 2015 @12:58PM (#9438845)

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.

[ Parent | on HN ]