BA97 Lounge Calendar Master Thread
#1382
Original Poster
Join Date: Aug 2004
Location: Newcastle upon Tyne, UK
Programs: BA Gold
Posts: 2,125
Thanks @csdf, @IMH and @AgEngineer for the bug report. That little search icon on the flight entry screen triggers a script running on the server-side which used to successfully scrape the flight details from Google Flights. Like all good screen scrapers it works just as long as it takes the target of the screen scraping to change their layout, which Google have, and rather than barfing quickly the script was perpetually spinning away and chewing up application pool resources which prevents the site from serving subsequent requests until IIS automatically spins up a new pool to take over. The 502 Bad Gateway responses indicate that - I front IIS with NGINX, and when NGINX is trying to proxy requests through to IIS and can't you get a 502. You are getting a response from the server then, so it's not your ISP or connectivity, just the server itself is saying "I'm broken".
Anyhow, as the search function wasn't working I've taken it away pending a return if and when I find another source to scrape or query for flight details.
Anyhow, as the search function wasn't working I've taken it away pending a return if and when I find another source to scrape or query for flight details.
#1383
Original Poster
Join Date: Aug 2004
Location: Newcastle upon Tyne, UK
Programs: BA Gold
Posts: 2,125
Now we just gotta ask BA97 what he thinks of this proposal
The issue may come with distances. Anyone know of a precompiled database of train stations with their latitude and longitude?!
#1384
Join Date: Oct 2009
Location: Dundee
Programs: BA Plastic. HH Diamond. Speedwell Bar Lifetime Platinum.
Posts: 1,418
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?!
The issue may come with distances. Anyone know of a precompiled database of train stations with their latitude and longitude?!
IATA Railway Stations
#1385
Join Date: Jul 2010
Location: Here today, gone tomorrow
Programs: Nothing shiny :-(
Posts: 2,491
Eurostar is on the list - but the stations it serves aren't. I've cheated a little and taken Eurostar from London City to Charles de Gaulle but it would be great if QQS (St Pancras), XPG (Gare du Nord) and the other stations accessible by Eurostar could be added.
#1386
Join Date: Sep 2013
Location: Birmingham New Street
Programs: ASLEF
Posts: 266
If railway stations are added, please could you use CRS codes for UK stations that don't have an IATA code? E.g. BHM = Birmingham New Street. BNS = Barnes etc. A full and comprehensive list can be found at CRS, NLC, TIPLOC and STANOX codes
#1387
Join Date: Sep 2013
Location: Birmingham New Street
Programs: ASLEF
Posts: 266
The ORR Station usage data set has northings and eastings if you can calculate longitude and latitudes from that? https://dataportal.orr.gov.uk/statis...great-britain/
#1388
Join Date: Oct 2009
Location: Dundee
Programs: BA Plastic. HH Diamond. Speedwell Bar Lifetime Platinum.
Posts: 1,418
If railway stations are added, please could you use CRS codes for UK stations that don't have an IATA code? E.g. BHM = Birmingham New Street. BNS = Barnes etc. A full and comprehensive list can be found at CRS, NLC, TIPLOC and STANOX codes
Last edited by BlueThroughCrimp; Aug 19, 2022 at 3:37 am Reason: Doh, it's not Kansas
#1390
Join Date: Oct 2009
Location: Dundee
Programs: BA Plastic. HH Diamond. Speedwell Bar Lifetime Platinum.
Posts: 1,418
Maybe stick a railway identifier prefix to the codes to prevent any overlap/duplication? E.g. 'R' for Railway. Birmingham New Street's BHM becomes RBHM? I'm sure BA97 will come up with a better solution.
#1391
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?!
The issue may come with distances. Anyone know of a precompiled database of train stations with their latitude and longitude?!
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?
Last edited by Nick Art; Aug 19, 2022 at 6:36 am
#1395
Feel free to submit the missing lounge with all the necessary information directly on ba97 and I will approve it as soon as you did