Flight Path Analysis Project: Weekly Meeting

Meeting Date: Nov 10, 2023 - 10:00 CT / 11:00 EST / 9:00 MST / 15:00 UTC

Meeting Location: Zoom

Chair: Andre Guimaraes

Announcements / One Minute Updates

• 26 days until project deadline

Agenda Items

• Action Items:
  • Download data for relevant flights (Andre Guimaraes)
    • Issue
  • Final touches on METAR data integration (Hannah Solomon, Andre Guimaraes)
    • Issue
  • Passenger Data Availability (Dimindu de Silva, Ruth MacLeod)
    • Issue
  • Comparison and final decision on fuel consumption model (Dimindu de Silva, Ruth MacLeod)
    • Issue
  • GPS Waypoint routes or other FAA Published routes (Noah Thompson)
    • Issue
  • Estimation of relevant wind speed from flight data (Andre Guimaraes, Noah Thompson)
    • Issue
• Other issues for discussion
  • Paralellizing process among group
• Set up action items and working groups for next week
• Any Other Business

---

AI-Generated Summary

Recording Link

• André discussed the upcoming deadline and reminded the team to start working on the project. He also mentioned that he downloaded the relevant flight data for January and will download the July data soon. Dumindu mentioned a Python library but didn't provide further details. - PLAY @0:01: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=1.26
  • Dumindu, André, and Solomon discussed various topics related to estimating fuel consumption for flights using a library called traffic. They explored the library's features, integrated fuel consumption calculations, and observed a potential issue with two peaks in the fuel consumption histogram. - PLAY @3:19: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=199.6
  • André, Ruth, Solomon, Dumindu, and Noah discussed various aspects of the data analysis project, including the possibility of different aircraft types, the inclusion of aircraft type in the visual, the consideration of air density, the use of ground speed, and the clarification of altitude measurements. They agreed to move forward with the available data and focus on integrating weather information into the flights before building a model. - PLAY @11:45: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=705.44
  • André, Dumindu, Noah, and Solomon discussed various topics including pushing a notebook to the repository, the availability of FAA API for waypoints, the decision to skip scraping waypoints, and the identification of abbreviations in MITAR data that could cause planes to divert. They also considered using a binary system to indicate severity of weather conditions and discussed the possibility of creating a weather map for presentation purposes. - PLAY @17:26: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=1046.04
  • Solomon and André discussed the different columns in the flight data and decided to exclude certain ones, such as the altimeter and weather symbol. They also made adjustments to the cloud type and cloud level columns, and decided to focus on wind speed rather than wind direction. - PLAY @24:56: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=1496.22
  • Solomon and André discussed various tasks, including typing down information, finalizing MITAR, downloading flight data for January, and ensuring they had permission. They also mentioned successfully completing some tasks and encountering challenges with high-speed winds. - PLAY @31:48: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=1908.86
  • André discussed the weather interpolator module that estimates weather conditions at a given location using SQLite databases. He requested assistance from Solomon and others to run the module on specific flight routes in parallel to speed up the computation process and create a script for easier usage by Monday. - PLAY @32:40: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=1960.42
  • André, Ruth, Solomon, and Dumindu discussed their tasks for the upcoming week, including pushing the notebook, implementing fuel consumption calculation, and potentially looking into small and big flights separately. They also mentioned the possibility of learning Tableau for data visualization but were unsure if they would have enough time to do so within the project deadline. - PLAY @38:02: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=2282.94
  • André, Dumindu, Solomon, and others discussed the data processing and analysis plan. They agreed to schedule a meeting on Sunday at 1 o'clock central time to implement the fuel-related tasks and address any SQL issues. - PLAY @46:26: https://fathom.video/share/chuaoqHDad-8Tk9cbTw5M9Nsn_FurMyB?timestamp=2786.58