Is there available an easily digestible (i.e., CSV or something) source for Amtrak rail station codes? They have a code page here but I'm looking for something that could be included in a database lookup, without scraping and building it myself.
Scraped and built for you, up on Open Data SE's datahub.io account; note, these are only for America, not all Amtrak stations/codes:
https://datahub.io/dataset/amtrak-stations
2017-04-03 Update:
Added official Amtrak Stations (of U.S.) GeoJSON dataset:
Updated database of the Federal Railroad Administration's (FRA) Amtrak Station database. This database is a geographic data set containing Amtrak intercity railroad passenger terminals in the United States and Canada. Attribute data include services and passenger amenities provided at the station
Official Source:
Amtrak Stations - US DOT
-
1Wow, thanks! Out of curiosity, did you already have some sort of scraping framework at the ready? Or just bespoke it? If I were tackling it myself I'd probably go the python/beautifulsoup route to build something but I don't have the time at the moment to poke at it. – Peter Tirrell Nov 25 '15 at 18:56
-
2thought about python/bs route, thought about using importHTML into google sheets, but the structure of each page was so annoying i just copy/pasta'd it – albert♦ Nov 25 '15 at 19:17
The National Transportation Atlas Database has a shapefile of Amtrak stations