20.500.12556/RUL-187942 Obdelava in analiza podatkov OpenSky z razvojem spletne aplikacije Processing and Analysis of OpenSky Data through the Development of a Web Application Diplomsko delo obravnava razvoj aplikacije za analizo arhivskih podatkov letalskega prometa z namenom, da bi prepoznali prostorske in časovne vzorce gibanja zrakoplovov. Za vir podatkov je bila uporabljena arhivska podatkovna baza OpenSky, ki hrani podatke o poletih zrakoplovov, kot so hitrost, smer, višina leta, čas oddanega signala in lokacija v trenutku oddaje signala. Pridobljeni so bili podatki za območje Srednje Evrope med 11° in 19° vzhodne geografske dolžine in 44° in 48° severne geografske širine, ki so bili shranjeni v lokalno podatkovno bazo MySQL. Aplikacija je sestavljena iz treh sklopov – pridobivanje podatkov, obdelava podatkov in prikaz rezultatov. V postopku obdelave so bili posamezni podatki povezani v trajektorije letov, koordinatne pa transformirane iz koordinatnega sistema WGS84 v lokalni ravninski koordinatni sistem. Za analizo gostote prometa je bila uporabljena metoda ocene gostote jeder (Kernel Density Estimation – KDE) z Gaussovim jedrom, ki omogoča prepoznavanje območij z največjo koncentracijo letalskega prometa. Rezultati so pokazali, da se letalski promet kljub odprtemu evropskemu zračnemu prostoru koncentrira vzdolž jasno izraženih letalskih koridorjev. Razvita spletna aplikacija omogoča interaktivni prikaz rezultata v obliki animiranih toplotnih kart, pri čemer uporabnik izbere časovni in višinski interval analize. Naloga povezuje geoprostorske podatke, prostorsko analizo, podatkovne baze in spletne tehnologije in predstavlja uporabno orodje za raziskovanje vzorcev letalskega prometa. 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. OpenSky GIS prostrorski podatki letalski promet prostorska analiza spletna aplikacija sistem za upravljanje podatkovnih baz OpenSky GIS geospatial data air traffic spatial analysis web application database management system true false false Slovenski jezik Angleški jezik Diplomsko delo/naloga 2026-09-16 15:50:25 2026-09-16 15:50:29 2026-09-17 04:30:06 0000-00-00 00:00:00 2026 0 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 1970-01-01 182317 23476.pdf 23476.pdf 1 2FFA0A8080642F32AE8F1D7E0D3A65CB 41fbf18e27e0ac1d22d075508d7bc6cc93ad0d54108d24934ad38d7e4dcd81cf 8c52b7b7-b1d5-11f1-8bc5-0050569b8976 https://repozitorij.uni-lj.si/Dokument.php?lang=slv&id=247787 Fakulteta za gradbeništvo in geodezijo 0 0 0