Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by mikegreen | Hacker News Reader

Full thread

mikegreen·

Interesting.

Riddle me this: 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"?

View on HN

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

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

yeah, EWR comes under Newark. Though I should consider merging metropolitan areas beyond cities.

http://flightsphere.com/flight-time/from/newark/to/san-franc...

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

I'll take you up on that sometime soon hopefully. I'm a bit far from the bay area atm.

What is the data source?

http://www.transtats.bts.gov/Fields.asp?Table_ID=236

just contact me at nikhilb at ml1.net and you've got your beers.

Reply on news.ycombinator.com