History of airport database edits - Visualized

1

Hi, so one Friday evening I had the amazing idea to analyze all changes in IFAET Airports database. 2 days, 43 GB and millions of analyzed files later I did it, so enjoy. If you have a question it didn’t answer, like how much runways there were in total for each release, I’ll be happy to answer them in a follow up post, but sadly not here, as running this analysis means leaving my notebook running for half an hour due to the sheer amount of data.

Table
Version Total Added Changed Deleted Empty*
V1 1638 0 0 0 0
V2 1686 49 161 2 1
V3.0 1687 2 107 0 1
V3.1 34532 32859 741 18 7358
V4 34304 36 576 263 7325
V5 34311 16 192 8 7322
V6 34310 4 124 5 7321
V7 34310 1 85 1 7320
V8 34311 3 102 3 7317
V9 34298 423 110 420 7314
V10 34232 4 262 71 7302
V11 34217 20 223 37 7266
V12 34220 13 255 8 7249
V13 34219 3 115 4 7247
V14 34223 13 175 10 7239
V15 34216 1 134 8 7235
V16 34238 34 217 12 7211
V17 34237 3 203 3 7207
V18 34252 20 201 5 7196
V19 34248 5 136 9 7191
V20 34255 11 263 5 7188
V21 34251 20 222 22 7160
V22 34251 4 222 4 7156
V23 34254 6 200 3 7155
V24 34252 1 118 3 7153
V25 34246 7 126 13 7151
V26 34247 2 81 1 7147
V27 34246 14 273 15 7123
V28 34243 6 155 9 7106
V29 34233 18 139 30 7095
V30 34225 15 122 24 7073
V31 34228 17 156 14 7045
V32 34200 29 378 56 6999
V33 33759 91 760 535 6872
V34 33594 32 246 197 6814
V35 33594 32 246 197 6814

*Empty airport here is an airport without a runway, it’s folder is usually marked with [-] in the repo

IFAET
IFAET4000×1600 257 KB

The darker the color of a tile - the more changes were made in that version

CHART1
CHART14000×4350 614 KB

CHART4
CHART44000×2900 519 KB

CHART3
CHART34000×2900 439 KB

CHART2
CHART24000×3750 504 KB

Sources:
Releases from IFAET Github
Color palettes from coolors.co
Data analyzed using Swift
Data visualized using Sketch
Some graphs made with the help of Numbers for Mac and later beautified in Sketch

29 Likes
2

next up: a map with the airports colored with the color palette.

1 Like
3

Fantastic work! Thank you for that.

Just a short notice: as far as I could see most of the peaks came from the time between two updates being significant longer then average.
Putting the “versions” on a timescale would be nice therefore.

Great work.
Tom

2 Likes
4

Hi Tom, thanks for the nice words! I’ll try to do this, but I’m not sure that numbers/excel can do such things. If not I’ll do my best to add average airports/day to the follow-up post

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.