4 ms·
Interesting. Riddle me this: http://flightsphere.com/flight-time/from/atlanta/to/chicago http://flightsphere.com/flight-time/from/atlanta/to/chicago It says U
by mikegreen 12y ago
Interesting.
Riddle me this: http://flightsphere.com/flight-time/from/atlanta/to/chicago http://flightsphere.com/flight-time/from/atlanta/to/chicago
It says United has 6 flights per week from Atlanta to Chicago. They have 6 or 7 per day in reality.
How are airports in metro areas consolidated?
Are you using MDW instead of ORD for "Chicago"?
- nikhizzle 12y agoThanks for finding this, I owe you a beer. Payable any time in the bay area. It is probably a bug in my data pipeline. I will look into this. I consolidate all airports in a metro area, MDW and ORD for Chicago.
- sardonicbryan 12y agoI'm pretty sure UA has more than 48 flights a week to the NY area as well if you're aggregating JFK, LGA and EWR,the number should be closer to 20 per day. I just arbitrarily picked Friday, 10/17 from SFO => NYC and there are 23 flights. Your number might be right if excluding EWR, which like SFO is a major UA hub.
- nikhizzle 12y agoyeah, EWR comes under Newark. Though I should consider merging metropolitan areas beyond cities. http://flightsphere.com/flight-time/from/newark/to/san-francisco http://flightsphere.com/flight-time/from/newark/to/san-franc...
- sardonicbryan 12y agoMost cities actually have an airport code as well, ie CHI for Chicago and NYC for New York. It might be worthwhile to piggyback off of that for consistencies sake.
- mikegreen 12y agoI'll take you up on that sometime soon hopefully. I'm a bit far from the bay area atm. What is the data source?
- nikhizzle 12y agohttp://www.transtats.bts.gov/Fields.asp?Table_ID=236 http://www.transtats.bts.gov/Fields.asp?Table_ID=236 just contact me at nikhilb at ml1.net and you've got your beers.