Airports & Aircraft Database

[Unknown98]

Actually, yeah that might work. Good idea lol

[POTKC]

No, longitudes would not work. Time zones aren't that perfectly aligned. There's the problem of Cambodia and North Korea being in random timezones though, and Russia not doing Daylight Savings Time (or rather perpetually on daylight savings time...)

[Unknown98]

You could still get a lot of airports in one shot though, and then go back and individually edit the few airports that need it. I'll figure something out, shouldn't be too difficult.

[skifans]

Is this actually nesicery? Can UTC not be used to simplify everything?

---

Question for US people who know about this sort of thing, I have been trying to use from the US department of transportation and got the spreadsheet attached from here (http://www.transtats.bts.gov/DL_SelectFi...20Carriers). The data is in pounds (lb), it is sorted by IATA code and also shows how much cargo was sent to each destination and by each carrier so if you use it be sure to add them all up. However, alot of the values are 0, but not enough for each airport to each airport. So does anyone know if the 0 is a rounding error (there was <1 pound of cargo, but there was some), these also seems unlikely. Does anyone know?

---

Link, to spreedsheet: https://drive.google.com/file/d/0Bxs-znO...sp=sharing (this is about the 3rd attempt at me uploading this file, it sometimes gives a cannot display error, but seems to work if you click download)

[Unknown98]

The time zones are necessary for calculating demand during certain hours of the day. A flight arriving at 4am will have very little demand for instance.

[POTKC]

It's not that simple. Flight arrival and departure times do affect demand, but that depends on traveler preferences. Low-cost airlines and the like arrive late at night or very early in the morning to take advantage of cheaper gate prices, passing on the low prices to their customers, and therefore generating a lot of demand. Many transatlantic flights going east take off late at night or in some cases arrive very early. I know that for some reason 80% of all flights into Domodedovo that I take (again, using Moscow as an example since I live there) arrive between midnight and 5AM. Many south-west Asian-based airlines fly into Moscow at that time due to, again, the cheaper gate prices. This is all probably too complicated to calculate for the purposes if the game, so perhaps a simplified version could be used. Arrival/departure slot prices should maybe be charged per flight rather than buying gates as CA did, and the price should vary depending on the time?

EDIT: This is all probably going a bit off topic, so maybe a separate thread is necessary? What do you think, Unk?

[Unknown98]

Well yes it's not just that simple, there's more factors to take into account. It's all currently being worked into the demand model I'm trying to build in excel. You're right though, feel free to make a new thread so we can discuss demand, formulas and such in one place.

[chaitanya]

The time zones are necessary for calculating demand during certain hours of the day. A flight arriving at 4am will have very little demand for instance.

That's not true. The Delhi airport has maximum departures to South East Asia between 1am and 4 am. And they all nearly full.

[POTKC]

Well yes it's not just that simple, there's more factors to take into account. It's all currently being worked into the demand model I'm trying to build in excel. You're right though, feel free to make a new thread so we can discuss demand, formulas and such in one place.

It doesn't seem that I'm allowed to post a new thread in this forum section...I'll put it somewhere else

[skifans]

The time zones are necessary for calculating demand during certain hours of the day. A flight arriving at 4am will have very little demand for instance.

That's not true. The Delhi airport has maximum departures to South East Asia between 1am and 4 am. And they all nearly full.

Just because most flights are at time dosnt neserceraly mean most demand at that time. People may want and be more willing to fly in the day but are unable to.