Alteryx > Case Studies > Automating Aviation Chart Creation: A Case Study

Automating Aviation Chart Creation: A Case Study

Alteryx Logo
Technology Category
  • Analytics & Modeling - Machine Learning
  • Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
  • Aerospace
  • Equipment & Machinery
Applicable Functions
  • Maintenance
  • Product Research & Development
Use Cases
  • Leasing Finance Automation
  • Time Sensitive Networking
Services
  • System Integration
  • Testing & Certification
About The Customer
The customer in this case study is TerraVeta, a Geospatial information firm. TerraVeta specializes in the aviation field and was looking for a solution to automate the process of creating aviation charts. These charts are essential for pilots as they provide crucial information about their destination airport or airfield. The information on these charts includes safety warnings, terrain contours, communication frequencies, geospatial data, and other instructions that affect flight safety. TerraVeta's expertise in the aviation field was crucial in the development of the automated system, as their knowledge about the intricacies and requirements of aviation charts helped shape the solution.
The Challenge
TerraVeta, a Geospatial information firm, was faced with the challenge of manually creating aviation charts. These charts, which provide essential information to pilots such as safety warnings, terrain contours, communication frequencies, geospatial data, and other instructions, had to be constructed with precision and attention to detail. The process was time-consuming and labor-intensive, with technicians having to extract information from a database piece-by-piece and individually plot each element. The challenge was to automate this process, reducing the time spent on menial tasks and allowing aviation experts to focus on larger conceptual issues.
The Solution
The solution involved breaking the project down into two major sections: Data and Programming. The data was extracted from a government database using Alteryx, a tool that allows for quick extraction, blending, transformation, and calculation of data. The data was then cleaned and transformed into a format that could be input into the CAD plotting environment. To accommodate many users and give full control to the data engineers and mappers, the team transitioned to the open-source statistical modeling programming language, 'R'. The programming was done in MicroStation, a CAD software, with the aim of populating the chart in a natural order. The team developed a unique framework with cascading logic that mimics the computer science principle of binary search, allowing the code to be dynamic enough to anticipate unexpected rules and situations. The entire process was automated, reducing the time spent on creating aviation charts and eliminating human error.
Operational Impact
  • The operational results of this project were significant. The automation of the aviation chart creation process not only saved time but also ensured the accuracy of the charts by eliminating human error. This allowed the well-trained aeronautical specialists at TerraVeta to focus on what they do best - using their experience and knowledge to craft solutions. The success of the project also led to the software being licensed to a major government contractor, expanding the reach of the solution. Furthermore, the project demonstrated the effectiveness of a flexible approach that breaks large projects into smaller chunks and pairs with experts in the domain. This approach will be used in all future development work at TerraVeta.
Quantitative Benefit
  • Reduced the time spent on creating aviation charts from three hours to thirty seconds, saving approximately two hours and thirty minutes per chart.
  • Eliminated human error from the process, ensuring the accuracy of the charts.
  • Licensed the software to the main government contractor, a subsidiary of a Fortune 30 company.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that Asia Growth Partners may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from Asia Growth Partners.
Submit

Thank you for your message!
We will contact you soon.