6 ms·

List of European train stations and associated metadata

thibaut_barrere 12y ago
Context (french): https://blog.capitainetrain.com/8619-capitaine-train-libere-les-gares https://blog.capitainetrain.com/8619-capitaine-train-libere-...
- deleted 12y ago
  [deleted]
  - thibaut_barrere 12y ago
    I'm not working at CapitaineTrain - but user @tristramg who replied below apparently does. You should get both in touch!
    - orless 12y ago
      Thanks, moved the comment there. :)
aquilax 12y ago
It's a good start, but a lot of countries are missing from the list.
- tristramg 12y ago
  (I work at Capitaine Train who published this data) It is true. This database has not the pretension to have all the stations in Europe. It has all the stations where we can sell tickets to. As we connect to more carriers, the database will expand. But it is a long process.
  - orless 12y ago
    I'd be glad if you drop me a message so that we could establish a contact. xing.to/va or valikov-at-gmx.net (Disclaimer: working for the Deutsche Bahn.)
  - thibaut_barrere 12y ago
    See https://news.ycombinator.com/item?id=9426153 https://news.ycombinator.com/item?id=9426153 - apparently trying to get in touch with CapitaineTrain. Hope this helps.
  - jkot 12y ago
    There is list of Czech stations on wiki, I think you could find other countries too. https://cs.wikipedia.org/wiki/Seznam_%C5%BEelezni%C4%8Dn%C3%ADch_stanic_v_%C4%8Cesku https://cs.wikipedia.org/wiki/Seznam_%C5%BEelezni%C4%8Dn%C3%...
  - christop 12y ago
    > It has all the stations where we can sell tickets to. This list seems to have a lot more stations than the website or Android app allows. e.g. I can't book a ticket to/from London Charing Cross, or Cambridge, yet those are in the CSV file.
orless 12y ago
In this context absolutely worth mentioning is the Public Transport Enabler (https://github.com/schildbach/public-transport-enabler https://github.com/schildbach/public-transport-enabler). This is what we used to create this prototype: https://medium.com/@highsource/reliable-train-connections-app-wins-the-first-deutsche-bahn-hackathon-3419ef275bfc https://medium.com/@highsource/reliable-train-connections-ap... Disclaimer: I'm working for the Deutsche Bahn (German Railways) and try do some persuasion work towards Open Data here internally.
- _stk 12y ago
  Systel? Been at the Hackathon recently? :)
  - orless 12y ago
    Won it. :)
    - _stk 12y ago
      Ah, A.V., w/ Falco from our group in Ulm? The world is small ;)
    - sdoering 12y ago
      Just read the posting and have to say, I really would dig the Chrome extension - and having a lot of traveling colleagues here in Hamburg, they would too. Also the app - this would really be a great app to have. Kudos!
      - orless 12y ago
        Thank you for the feedback. The Chrome extension is meaningless without the service providing the data. And the data isn't set free, unfortunately. We're talking to DB Vertrieb about this app next week.
- mafribe 12y ago
  Could you explain why a railway operator might not want their data to be opened? After all, better availability of data might convince more people to use trains.
Symbiote 12y ago
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.aspx http://www.nationalrail.co.uk/stations_destinations/48541.as...
- espadrine 12y ago
  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.)
  - orless 12y ago
    "National IDs" for the Germain stations would be so-called RL100: http://fahrweg.dbnetze.com/file/fahrweg-de/2394144/vHBDX5OndmGwv-JTA9EzuNArX1E/2361656/data/betriebsstellen.pdf http://fahrweg.dbnetze.com/file/fahrweg-de/2394144/vHBDX5Ond...
    - tristramg 12y ago
      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
      - orless 12y ago
        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...
        tristramg 12y ago
jphallain 12y ago
Bien joué ;)
amelius 12y ago
Nice project idea: collect gps data from cell-phone users that are on a train, and based on this data (lots of users moving at the same speed across known tracks), get an overview of where trains are located.
- Cthulhu_ 12y ago
  You'd have to convince the users to allow you to track their position though. It's easier to install a GPS module (or similar) onto a train, and publish it in a public API.
- orless 12y ago
  Most trains already have GNSS capabilities, we (DB) get quite exact positions every 30 seconds (going down to 10 soon).
- pfunk 12y ago
  There may be no need soon - most EU countries have very accurate data that theyve traditionally kept to themselves, but are now being mandated to make available. Its very slow, but getting there: http://www.era.europa.eu/Core-Activities/Interoperability/Pages/RINF.aspx http://www.era.europa.eu/Core-Activities/Interoperability/Pa... http://tap-tsi.uic.org/ http://tap-tsi.uic.org/
- orless 12y ago
  Here's our "train radar": http://www.apps-bahn.de/bin/livemap/query-livemap.exe/dn?L=vs_livefahrplan&livemap=yes http://www.apps-bahn.de/bin/livemap/query-livemap.exe/dn?L=v... Disclaimer: this is NOT realtime GNSS data. New project coming in that direction soon.
  - AlbertoGP 12y ago
    That's neat. The train from Trier to Homburg just passed by so I checked its accuracy, and it was showing it one kilometre ahead of the actual train position, then the indicator moved backwards to match the actual location. I guess this is because of the interpolation you do as it's not real time data yet. I'm a great fan of your (DB's) work and use your apps/website daily. Keep up the good work!
nathell 12y ago
Some station names are incorrect. For example, the file lists a UK station named "Yeovil", while there is no such station -- it should probably be "Yeovil Junction".
- Spone 12y ago
  Submit a PR :)
christop 12y ago
This is really nice, though the documentation is a bit lacking in parts (there's already a pull request to make things a bit nicer :) For example, I can see a station is missing, but is there any way to find its UIC code (or other identifiers) so I can add an entry? It's not clear what `is_suggestable` actually means, so I wouldn't know what to input. Also, while there are info:* columns for miscellaneous info, there doesn't seem to be multiple name:* columns for the localised station name (a lot of this data may already be in OpenStreetMap)?
- tristramg 12y ago
  Thank you. Indeed the data is incomplete yet. Bear in mind that the data comes from a specific use on https://www.capitainetrain.com https://www.capitainetrain.com That is why many countries are poorly covered (yet! we plan to eventually cover whole Europe). There is no magic to find the UIC code, sorry… Sometimes it is in OpenStreetMap, sometimes we get it from a rail operator… But it is not a required value, so you can add it with out the station. `is_suggestable` means that the user can input the station on capitainetrain.com. Leave it false for now ;) The idea behind the name vs. info is that name is the station as it is locally known. Info adds any information extra information to help to find which station it is (that includes translations, “Central Station” for people not understanding „Hbf“, disambiguation between similar names…)
  - christop 12y ago
    > Info adds any information extra information to help to find which station it is [translations, disambiguation] These are two separate use cases, which should have their own structured fields. The current uses of info:* seem to be very free-form at the moment. If I want to travel to Cologne Trade Fair, I should be able to start typing "colo" and find it, without knowing that it's called "Köln Messe" in German. Whereas the info:* fields should separately have useful info, e.g. "Trains transfer from Cologne Main Station every few minutes." Much like on OpenStreetMap, doing a name search should match against all name:* fields. Info fields should be for info.
seszett 12y ago
Great, I wish I had that when I did this visualisation: http://ssz.fr/territoire/ http://ssz.fr/territoire/ Instead, I had to do hack upon hack to match SNCF's station names (like say "Valence (France - toutes gares)") to OSM nodes, or failing that to city names, and in the end fix the remaining ones manually.
- tristramg 12y ago
  Very nice representation! I hope that this data will allow more innovative representations to exist!
aselzer 12y ago
It's quite incomplete in (at least) Austria. While some stations in the bigger cities and in Vienna are included, I could not find any stations in lower austria. They are all listed in OpenStreetMap, and the inofficial ÖBB API (kinda documented here: https://github.com/internetztube/oebb-api https://github.com/internetztube/oebb-api) could be used to get the correct names. :)
- tristramg 12y ago
  Indeed. For now Capitaine Train the only carriers we are connected to that stop in Austrian stations are Deutsche Bahn and Trenitalia. Only those stations are in the database. Once we connect to ÖBB and Westbahn, we will need a more important cover. Until then, we are open for pull requests ;)
  - aselzer 12y ago
    I might actually give it a try. Hope they don't rate limit much :)
- ArturSoler 12y ago
  Around Barcelona there are also many missing stations.

Context (french): https://blog.capitainetrain.com/8619-capitaine-train-libere-les-gares https://blog.capitainetrain.com/8619-capitaine-train-libere-...

deleted 12y ago
[deleted]
- thibaut_barrere 12y ago
  I'm not working at CapitaineTrain - but user @tristramg who replied below apparently does. You should get both in touch!
  - orless 12y ago
    Thanks, moved the comment there. :)

aquilax 12y ago

It's a good start, but a lot of countries are missing from the list.

tristramg 12y ago
(I work at Capitaine Train who published this data) It is true. This database has not the pretension to have all the stations in Europe. It has all the stations where we can sell tickets to. As we connect to more carriers, the database will expand. But it is a long process.
- orless 12y ago
  I'd be glad if you drop me a message so that we could establish a contact. xing.to/va or valikov-at-gmx.net (Disclaimer: working for the Deutsche Bahn.)
- thibaut_barrere 12y ago
  See https://news.ycombinator.com/item?id=9426153 https://news.ycombinator.com/item?id=9426153 - apparently trying to get in touch with CapitaineTrain. Hope this helps.
- jkot 12y ago
  There is list of Czech stations on wiki, I think you could find other countries too. https://cs.wikipedia.org/wiki/Seznam_%C5%BEelezni%C4%8Dn%C3%ADch_stanic_v_%C4%8Cesku https://cs.wikipedia.org/wiki/Seznam_%C5%BEelezni%C4%8Dn%C3%...
- christop 12y ago
  > It has all the stations where we can sell tickets to. This list seems to have a lot more stations than the website or Android app allows. e.g. I can't book a ticket to/from London Charing Cross, or Cambridge, yet those are in the CSV file.

orless 12y ago

In this context absolutely worth mentioning is the Public Transport Enabler (https://github.com/schildbach/public-transport-enabler https://github.com/schildbach/public-transport-enabler). This is what we used to create this prototype: https://medium.com/@highsource/reliable-train-connections-app-wins-the-first-deutsche-bahn-hackathon-3419ef275bfc https://medium.com/@highsource/reliable-train-connections-ap... Disclaimer: I'm working for the Deutsche Bahn (German Railways) and try do some persuasion work towards Open Data here internally.

_stk 12y ago
Systel? Been at the Hackathon recently? :)
- orless 12y ago
  Won it. :)
  - _stk 12y ago
    Ah, A.V., w/ Falco from our group in Ulm? The world is small ;)
  - sdoering 12y ago
    Just read the posting and have to say, I really would dig the Chrome extension - and having a lot of traveling colleagues here in Hamburg, they would too. Also the app - this would really be a great app to have. Kudos!
    - orless 12y ago
      Thank you for the feedback. The Chrome extension is meaningless without the service providing the data. And the data isn't set free, unfortunately. We're talking to DB Vertrieb about this app next week.
mafribe 12y ago
Could you explain why a railway operator might not want their data to be opened? After all, better availability of data might convince more people to use trains.

Symbiote 12y ago

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.aspx http://www.nationalrail.co.uk/stations_destinations/48541.as...

espadrine 12y ago
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.)
- orless 12y ago
  "National IDs" for the Germain stations would be so-called RL100: http://fahrweg.dbnetze.com/file/fahrweg-de/2394144/vHBDX5OndmGwv-JTA9EzuNArX1E/2361656/data/betriebsstellen.pdf http://fahrweg.dbnetze.com/file/fahrweg-de/2394144/vHBDX5Ond...
  - tristramg 12y ago
    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
    - orless 12y ago
      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...
      - tristramg 12y ago

jphallain 12y ago

Bien joué ;)

amelius 12y ago

Nice project idea: collect gps data from cell-phone users that are on a train, and based on this data (lots of users moving at the same speed across known tracks), get an overview of where trains are located.

Cthulhu_ 12y ago
You'd have to convince the users to allow you to track their position though. It's easier to install a GPS module (or similar) onto a train, and publish it in a public API.
orless 12y ago
Most trains already have GNSS capabilities, we (DB) get quite exact positions every 30 seconds (going down to 10 soon).
pfunk 12y ago
There may be no need soon - most EU countries have very accurate data that theyve traditionally kept to themselves, but are now being mandated to make available. Its very slow, but getting there: http://www.era.europa.eu/Core-Activities/Interoperability/Pages/RINF.aspx http://www.era.europa.eu/Core-Activities/Interoperability/Pa... http://tap-tsi.uic.org/ http://tap-tsi.uic.org/
orless 12y ago
Here's our "train radar": http://www.apps-bahn.de/bin/livemap/query-livemap.exe/dn?L=vs_livefahrplan&livemap=yes http://www.apps-bahn.de/bin/livemap/query-livemap.exe/dn?L=v... Disclaimer: this is NOT realtime GNSS data. New project coming in that direction soon.
- AlbertoGP 12y ago
  That's neat. The train from Trier to Homburg just passed by so I checked its accuracy, and it was showing it one kilometre ahead of the actual train position, then the indicator moved backwards to match the actual location. I guess this is because of the interpolation you do as it's not real time data yet. I'm a great fan of your (DB's) work and use your apps/website daily. Keep up the good work!

nathell 12y ago

Some station names are incorrect. For example, the file lists a UK station named "Yeovil", while there is no such station -- it should probably be "Yeovil Junction".

Spone 12y ago
Submit a PR :)

christop 12y ago

This is really nice, though the documentation is a bit lacking in parts (there's already a pull request to make things a bit nicer :) For example, I can see a station is missing, but is there any way to find its UIC code (or other identifiers) so I can add an entry? It's not clear what `is_suggestable` actually means, so I wouldn't know what to input. Also, while there are info:* columns for miscellaneous info, there doesn't seem to be multiple name:* columns for the localised station name (a lot of this data may already be in OpenStreetMap)?

tristramg 12y ago
Thank you. Indeed the data is incomplete yet. Bear in mind that the data comes from a specific use on https://www.capitainetrain.com https://www.capitainetrain.com That is why many countries are poorly covered (yet! we plan to eventually cover whole Europe). There is no magic to find the UIC code, sorry… Sometimes it is in OpenStreetMap, sometimes we get it from a rail operator… But it is not a required value, so you can add it with out the station. `is_suggestable` means that the user can input the station on capitainetrain.com. Leave it false for now ;) The idea behind the name vs. info is that name is the station as it is locally known. Info adds any information extra information to help to find which station it is (that includes translations, “Central Station” for people not understanding „Hbf“, disambiguation between similar names…)
- christop 12y ago
  > Info adds any information extra information to help to find which station it is [translations, disambiguation] These are two separate use cases, which should have their own structured fields. The current uses of info:* seem to be very free-form at the moment. If I want to travel to Cologne Trade Fair, I should be able to start typing "colo" and find it, without knowing that it's called "Köln Messe" in German. Whereas the info:* fields should separately have useful info, e.g. "Trains transfer from Cologne Main Station every few minutes." Much like on OpenStreetMap, doing a name search should match against all name:* fields. Info fields should be for info.

seszett 12y ago

Great, I wish I had that when I did this visualisation: http://ssz.fr/territoire/ http://ssz.fr/territoire/ Instead, I had to do hack upon hack to match SNCF's station names (like say "Valence (France - toutes gares)") to OSM nodes, or failing that to city names, and in the end fix the remaining ones manually.

tristramg 12y ago
Very nice representation! I hope that this data will allow more innovative representations to exist!

aselzer 12y ago

It's quite incomplete in (at least) Austria. While some stations in the bigger cities and in Vienna are included, I could not find any stations in lower austria. They are all listed in OpenStreetMap, and the inofficial ÖBB API (kinda documented here: https://github.com/internetztube/oebb-api https://github.com/internetztube/oebb-api) could be used to get the correct names. :)

tristramg 12y ago
Indeed. For now Capitaine Train the only carriers we are connected to that stop in Austrian stations are Deutsche Bahn and Trenitalia. Only those stations are in the database. Once we connect to ÖBB and Westbahn, we will need a more important cover. Until then, we are open for pull requests ;)
- aselzer 12y ago
  I might actually give it a try. Hope they don't rate limit much :)
ArturSoler 12y ago
Around Barcelona there are also many missing stations.