List of European train stations and associated metadata • Hacker News Board

Re: List of European train stations and associated metadata

#11

Post by Symbiote » Thu, Apr 23, 2015, 12:28 PM UTC

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

Re: List of European train stations and associated metadata

#12

Post by jphallain » Thu, Apr 23, 2015, 12:33 PM UTC

Bien joué ;)

Re: List of European train stations and associated metadata

#13

Post by espadrine » Thu, Apr 23, 2015, 12:39 PM UTC

Symbiote wrote: post #11

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

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

Re: List of European train stations and associated metadata

#14

Post by orless » Thu, Apr 23, 2015, 12:45 PM UTC

espadrine wrote: post #13

Symbiote wrote: post #11

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

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

Re: List of European train stations and associated metadata

#15

Post by amelius » Thu, Apr 23, 2015, 12:56 PM UTC

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.

Re: List of European train stations and associated metadata

#16

Post by tristramg » Thu, Apr 23, 2015, 12:56 PM UTC

orless wrote: post #14

espadrine wrote: post #13

Earlier quoted context omitted.

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

Re: List of European train stations and associated metadata

#17

Post by Cthulhu_ » Thu, Apr 23, 2015, 12:58 PM UTC

amelius wrote: 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.

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.

Re: List of European train stations and associated metadata

#18

Post by orless » Thu, Apr 23, 2015, 12:59 PM UTC

amelius wrote: 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.

Most trains already have GNSS capabilities, we (DB) get quite exact positions every 30 seconds (going down to 10 soon).

Re: List of European train stations and associated metadata

#19

Post by pfunk » Thu, Apr 23, 2015, 1:02 PM UTC

amelius wrote: 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 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/Pa... http://tap-tsi.uic.org/

Re: List of European train stations and associated metadata

#20

Post by orless » Thu, Apr 23, 2015, 1:02 PM UTC

tristramg wrote: post #16

orless wrote: post #14

Earlier quoted context omitted.

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