View source for Index talk:Aviation

Unfortunately, removing the ANACA codes makes it very difficult to find direct neighbors, which should be responsible for 85 % of the flights.
Here are some overpass links to check the intl. references of airports
*[https://turbo.ogf.rent-a-planet.com/?Q=(node%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%22icao%22%5D(%7B%7Bbbox%7D%7D);way%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%22icao%22%5D(%7B%7Bbbox%7D%7D);relation%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%22icao%22%5D(%7B%7Bbbox%7D%7D)%3B)%3Bout%20body%3B%3E%3Bout%20skel%20qt%3B&R&C=0%3B0%3B1 airports with ICAO code]
*[https://turbo.ogf.rent-a-planet.com/?Q=(node%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%22iata%22%5D(%7B%7Bbbox%7D%7D);way%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%22iata%22%5D(%7B%7Bbbox%7D%7D);relation%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%22iata%22%5D(%7B%7Bbbox%7D%7D)%3B)%3Bout%20body%3B%3E%3Bout%20skel%20qt%3B&R&C=0%3B0%3B1 airports with IATA code]
*[https://turbo.ogf.rent-a-planet.com/?Q=(node%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%21%22icao%22%5D%5B%21%22iata%22%5D(%7B%7Bbbox%7D%7D);way%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%21%22icao%22%5D%5B%21%22iata%22%5D(%7B%7Bbbox%7D%7D);relation%5B%22aeroway%22%3D%22aerodrome%22%5D%5B%21%22icao%22%5D%5B%21%22iata%22%5D(%7B%7Bbbox%7D%7D)%3B)%3Bout%20body%3B%3E%3Bout%20skel%20qt%3B&R&C=0%3B0%3B1 airports without IATA/ICAO code]
*[https://turbo.ogf.rent-a-planet.com/?Q=(node%5B%22aeroway%22%3D%22runway%22%5D%5B%21%22ref%22%5D(%7B%7Bbbox%7D%7D);way%5B%22aeroway%22%3D%22runway%22%5D%5B%21%22ref%22%5D(%7B%7Bbbox%7D%7D);relation%5B%22aeroway%22%3D%22runway%22%5D%5B%21%22ref%22%5D(%7B%7Bbbox%7D%7D)%3B)%3Bout%20body%3B%3E%3Bout%20skel%20qt%3B&R&C=0%3B0%3B1 runways with missing reference] --[[User:Mstr|Mstr (talk)]] ([[User talk:Mstr|talk]]) 01:25, 22 January 2023 (UTC)
:Consolidating references to only use the 3-letter code was decided upon about a year ago in [https://wiki.opengeofiction.net/index.php?title=Forum:Global_and_regional_issues/The_two_systems_of_airport_codes&t=20220101175123 this forum thread]. –[[User:TheMayor|TheMayor]] ([[User talk:TheMayor|talk]]) 02:26, 22 January 2023 (UTC)
::Thank you for your answer.--[[User:Mstr|Mstr (talk)]] ([[User talk:Mstr|talk]]) 15:15, 22 January 2023 (UTC)

Here is a list of all airports with their airport codes--[[User:Mstr|Mstr (talk)]] ([[User talk:Mstr|talk]]) 00:13, 29 January 2023 (UTC)<br />
---list deleted---
:This list doesn’t include airports that don’t have the 4-character code, which is no longer necessary. Additionally, I think there’s value in having a more curated list to filter out non-canon areas and the plethora of airports in blue territories that shouldn’t be considered part of the global aviation network. -[[User:TheMayor|TheMayor]] ([[User talk:TheMayor|talk]]) 01:44, 29 January 2023 (UTC)
::I agree. Overpass can be very powerful, but as a blanket for things like this, it creates a lot of noise of things either non-canon or of dubious canonicity. We already push the limits a bit more with the territorial index pages, but those require nonstandard, OGF-specific tags to appear. &mdash; [[User:Alessa|Alessa]] <sub>([[User talk:Alessa|talk]])</sub> 04:08, 30 January 2023 (UTC)
:::Okay, now it shows all "IATA"-codes... it's rather a tool to look up all existing codes (where they are and how they are mapped)--[[User:Mstr|Mstr (talk)]] ([[User talk:Mstr|talk]]) 19:36, 31 January 2023 (UTC)
{{#clear_external_data:}}{{#get_web_data:url=https://overpass.ogf.rent-a-planet.com/api/interpreter?data=(way%5B%22name%22%5D%5B%22iata%22%5D%3B)%3Bout%3B
|format=xml
|data=
 way_id=/osm/way/@id,
 name=/osm/way/tag[@k='name']/@v,
 iata=/osm/way/tag[@k='iata']/@v
|use xpath
}}
{| class="wikitable sortable mw-collapsible mw-collapsed"
! width=500px; colspan="2" | List of airports with IATA code
{{!}}-
! width=500px; | Name
! width=100px; | IATA
{{#for_external_table:<nowiki/>
{{!}}-
{{!}}[http://opengeofiction.net/way/{{{way_id}}} {{{name}}}]
{{!}}{{{iata}}}
}}
|}
{{#clear_external_data:}}

== Data Reformatting ==
I was wondering if I could re-format and add a column for Index:Airports.

'''Primary City:''' 
* A slash (/) separator for multiple Primary cities
* Full names for states
'''Airport Name:''' 
* English Name (Native name/s) or just Native Name if English isn't provided
'''Runway orientation and length:''' 
* A diesis (‡) to provide comments about that particular runway
'''(New column) Time:''' 
* UTC Time for that airport
* Time UTC+XX:00 (optional DST: UTC+XX:00)

I can fix these upon permission. 

Thanks --[[User:Joebro|Joebro]] ([[User talk:Joebro|talk]]) 23:59, 29 December 2023 (UTC)

:Is there a way to incorporate the data (runways, ...) directly from the map (overpass)? An additional column to indicate the region/continent would also be helpful. In the past the ANACA-code has served for this purpose.--[[User:Mstr|Mstr (talk)]] ([[User talk:Mstr|talk]]) 01:01, 30 December 2023 (UTC)

::@Joebro: I love the idea of time zones being put in there. It has actually been my preference to ''eliminate'' a column in the long run. I'd be curious if you have thoughts on collapsing that. Also, what do you mean by comments about a runway? Here's a thought: would you be willing to mock up what it would look like here on the talk page with just two or three entries that covers these changes? I'm absolutely open to seeing what you come up with.
::@mstr: Having selected data like this from Overpass is a challenge, since it would have to merge with existing data. As I mentioned above, a list of airports strictly from Overpass creates a fair amount of useless noise/clutter. As for continent/region, I'm open to having something indicate that. Let's see what Joebro does with his proposed list first, because I very much don't want to add more than one other column.
::&mdash; [[User:Alessa|Alessa]] <sub>([[User talk:Alessa|talk]])</sub> 05:13, 30 December 2023 (UTC)
:::@Alessa I'm not sure this would work with Joebro's way of retrieving the data but one way you could probably remove a column without losing information would be to set up the table where the types are separated by collapsable headings of type (global, regional, domestic). Not sure exactly what that would look like though--[[User:Ernestpkirby|Ernestpkirby]] ([[User talk:Ernestpkirby|talk]]) 19:41, 30 December 2023 (UTC)
:::We probably can remove "number of gates" as a column. There are plenty of circumstances where the number of gates isn't really indicative of an airport's size or capacity (e.g., an airport that has many stands for regional planes could have more gates than a more major airport that handles larger international flights). --[[User:TheMayor|TheMayor]] ([[User talk:TheMayor|talk]]) 20:13, 30 December 2023 (UTC)
::::While a fair point, I don't really know that removing number of gates because of them not always being indicative of size or capacity fully makes sense because the number and length of runways also isn't always indicative of size or capacity. London-Heathrow with 2 runways handles only a few million less passengers than O'Hare with 7 runways; Kinston Regional Jetport in southeast NC has a longer runway than Charlotte-Douglas and Raleigh-Durham and no commercial flights at all today. Maybe there's a way to consolidate the set?--[[User:Ernestpkirby|Ernestpkirby]] ([[User talk:Ernestpkirby|talk]]) 09:10, 31 December 2023 (UTC)
:::::Length of runway has a direct impact on the size of aircraft that can use the airport. If we do need to eliminate a column, number of gates would have the least impact. —[[User:TheMayor|TheMayor]] ([[User talk:TheMayor|talk]]) 16:11, 31 December 2023 (UTC)
::::::Hm, fair point. I wasn't thinking as much about the length as indicative of plane size capacity, that makes sense. The only other point I would make for the gates is I feel like it is sort of the piece that passively helps encourage people to only add airports mapped to a certain level of detail. Most of the information is easy to generate without much mapping, and it's fairly easy to plop down and label some runways (this is not an argument against the runway column, your point is valid) but having gates feels like it has that step of "hey, is your airport mapped to enough detail to give a number for this? No? Then come back when it is." At least I know I stopped and went back to add more detail when first adding airports because of that hurdle. But maybe that was just me, I guess nothing is stopping someone from making up a number...--[[User:Ernestpkirby|Ernestpkirby]] ([[User talk:Ernestpkirby|talk]]) 17:51, 31 December 2023 (UTC)
::@Alessa: Generally, the data formatting on the table is pretty much correct - I just wanted to point out some small fixes because a couple of nations' airports have very small differences (i.e. space between the number and metres, usage of line break elements, italics...) and to be honest, it's not really a big deal. It's just that i'm looking for a way to extract data in a cleaner fashion without affecting the readability of the wiki table, which is why I defined a couple of enforced rules from my previous comment.

::In the table below, here are just some of these rules applied to already existing entries:
::{| class="wikitable sortable" border="1" style="margin:0px;width:90%;"
|-	  
! | Country
! | Primary City
! | Airport Name
! | Code<br />
! | Type<br />
! | Gates<br />(total)
! class="unsortable" | Runway orientation and length
! class="sortable" | Time
! class="unsortable" | Location
|-
| {{Gobrassanya}} <br />{{Alora}}
| Gallaton, Tenata/Quesagnais, Grand Lake District
| Grand Lakes International Airport<br />
| GLI
| R
| 94
| 3R/21L (3050m)<br />3C/21C (3050m)<br />3L/21R (3000m)
| UTC+05:00
| {{Airport-coord|20.9919|83.9022}}
|-
| {{Gobrassanya}}
| Puerto Geo, Arrowic District
| Puerto Geo - Arrowic International Airport
| GEO
| R
| 59
| 11-29 (4240m)<br />11W-29W (1100m) ‡Seaplane Landing Zone
| UTC+05:00
| {{Airport-coord|19.2937|86.0430}}
|-
| {{Geklinia-Dregolesia}}
| Mižričkavs'k/Dobrzanka/Chashavinsk
| Geklinia-Dregolesia International Airport (Міжнародний Аеропорт Жеклінія-Дреголесія/Міэѕинародови Порт Лотнічи Жеклініа-Дреголезја)
| GD
| G
| 70
| 8/26 (3200m) <br/>3L/21R (3820m) <br/>3R/21L (3480m)
| UTC+05:00
| {{Airport-coord|56.5701|77.1621}}
|-
|}
::<br>
::@TheMayor does make a good point about removing gates as a column, but alternatively, if you wanted to give more value to the data, you could define an array of terminals, with each terminal having its respective gates.
::--[[User:Joebro|Joebro]] ([[User talk:Joebro|talk]]) 12:00, 4 January 2024 (UTC)
:::Thank you for showing me and highlighting what you're planning to do. Apologies for not getting back to you quickly. Holidays, illness, and family matters made me forget about replying.
:::I think we should remove gates for now; few are mapped to that level, and it really isn't lost data at this point (can be restored in another way from the history or whatnot). So, feel free to add the timezones, remove gates, tweak any other formatting, etc. On a related note, if this were powered by Overpass instead of manually editing the wiki, would that interfere with how the data is gathered? There is a standardized tagging scheme that exists that we can pull from to ensure the data goes into the right place. &mdash; [[User:Alessa|Alessa]] <sub>([[User talk:Alessa|talk]])</sub> 02:55, 27 January 2024 (UTC)

== WAAT/IATA codes in the route map ==
I suggest adding the airports' 3-letter codes also in the pop-up that shows up when one selects a route in the route map.
--[[User:Izaland Terramorphing Committee|Izaland Terramorphing Committee]] ([[User talk:Izaland Terramorphing Committee|talk]]) 15:46, 22 November 2025 (UTC)