The bachelor’s thesis presents the development of an application for the analysis of historical air traffic, with the aim of identifying spatial and temporal patterns in aircraft movements. The OpenSky historical database was used as the data source, as it stores data about aircraft, including velocity, heading, altitude, signal transmission time, and coordinates at the moment of signal transmission. Data were collected for an area in Central Europe between 11° and 19° east longitude and 44° and 48° north latitude and stored in a local MySQL database.
The application consists of three main components – data acquisition, data processing, and result visualization. During the processing stage, individual observations were linked to form flight trajectories, and the coordinates were transformed from the WGS84 coordinate system into a local projected coordinate system. To analyze traffic density, the Kernel Density Estimation (KDE) method with a Gaussian kernel was applied, enabling the identification of areas with the highest concentration of air traffic.
The results showed that, despite the open European airspace, air traffic is concentrated along clearly defined air corridors. The developed application provides an interactive visualization of the results in the form of animated heat maps, allowing users to select the temporal and altitude intervals for the analysis. The thesis combines geospatial data, spatial analysis, databases, and modern web technologies, providing a useful tool for the exploration and analysis of air traffic movement patterns.
|
