Originally Posted by
BA97
I am all in favour of this, but let me look at making a few changes first to treat the train companies a little differently to airlines in the database so stuff renders properly.
The issue may come with distances. Anyone know of a precompiled database of train stations with their latitude and longitude?!
For Europe I have found the following:
https://www.kaggle.com/datasets/head...ions-in-europe
it does, however, not include the three letter IATA designators or three digit codes and includes ALL train stations in Europe as well as the UIC code for the stations for which you could use this database to look them up:
http://ccs.rne.eu/crd/
I think manually adding the IATA codes to a database in rstudio or something based on the wikipedia links and the provided databases above might be easier and cleaner.
(US Amtrak stations list:
https://en.m.wikipedia.org/wiki/List_of_Amtrak_stations
Shinkansen stations dataset:
https://www.kaggle.com/datasets/japa...tions-in-japan
OpenFlights dataset:
https://www.kaggle.com/datasets/open...erry-terminals
)
Maybe it would be smart to build one single comprehensive dataset with additional details (name, city served, IATA code, ICAO code, CRS code, station/airport type etc.), similar to the open flight one in the link above. What database are you currently using for the airport codes and locations?