Live data from Hacker News

List of European train stations and associated metadata

github.com

21–30 of 57 posts

Re: List of European train stations and associated metadata

#21
post #15

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.

Here's our "train radar":

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.

Re: List of European train stations and associated metadata

#22
post #20

Earlier quoted context omitted.

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

Re: List of European train stations and associated metadata

#23
post #3

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

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

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

Re: List of European train stations and associated metadata

#24
post #3

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

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

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

Re: List of European train stations and associated metadata

#25
post #15

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.

There's an API for that...

Here's a list of uses of British open train data: http://nrodwiki.rockshore.net/index.php/Projects (a few are broken).

For example, a live diagram of the signals on the line from London Victoria to East Croydon http://www.opentraintimes.com/maps/signalling/vtb1

Re: List of European train stations and associated metadata

#27
post #4

In this context absolutely worth mentioning is the 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-ap... Disclaimer: I'm working for the Deutsche Bahn (German Railways) and try do some persuasion work towards Open Data here internally.

Systel? Been at the Hackathon recently? :)

Re: List of European train stations and associated metadata

#28
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)?

Re: List of European train stations and associated metadata

#29
post #20

Earlier quoted context omitted.

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/

Re: List of European train stations and associated metadata

#30
Great, I wish I had that when I did this visualisation: 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.

Post reply on HN