Data Processing and Visualization of Weather Data for Business Aviation Operators

Build a real-time weather information processing and visualization software

Duration: 28 months

Industry: Aviation

Overview

The client is a leading provider of weather forecasting service for business aviation operators. 

The project requirements included the processing of weather-related data from both government and private sources, building of weather data models, and development of a web-based application to visualize location-based weather data on Google Maps.

Data Processing and Visualization of Weather Data for Business Aviation Operators

The Solution

Perituza assembled a development team with experience in processing high-volume data with Microsoft SQL Server database technology and GIS (Geographical Information Systems).  The project was conducted in three phases:

Phase 1 - data extraction:

  • Perituza built SSIS packages to download data files from various sources via HTTP and FTP
  • Decoded and extracted data elements and stored them in the Microsoft SQL Server database
  • Scheduled SSIS packages to run on various time intervals

Phase 2 - data analysis and modeling:

  • Utilized SQL Server spatial queries to build various data models
  • Worked with the client’s weather data specialists to validate the data models

Phase 3 - development of a web application featuring data visualization:

  • Built a web portal to visualize various weather forecast information such as wind direction, wind temperature, precipitation, and humidity.
  • Overlaid weather-related data on Google Maps for location-based visualization

The Perituza project team consisted of:

  • A lead database developer specialized in Microsoft SQL database and SSIS
  • A GIS consultant with experience in Python and SQL spatial queries
  • Two (2) full-time SQL developers
  • Two (2) full-time web developers specialized in ASP.NET MVC and C#
  • A UI developer specialized in HTML, CSS, and JavaScript

Technologies used:

  • SQL Server, C#, ASP.NET MVC, Web API, SSIS (SQL Server Integration Services)
  • Amazon Web Services (AWS), Google Maps APIs
  • DEGRIB (General Regularly-distributed Information in Binary form), and GDAL (Geospatial Data Abstraction Library)

Project management and communication tools used:

JIRA, Basecamp, and HipChat

The Result

The project was implemented successfully and the software is now used by the client’s global customers in planning flights across the world.  The system processes approximately 2.5 million data records every six (6) hours.

Share this case study

Other Case Studies

Modernization of aircraft and crew scheduling software

Modernization of aircraft and crew scheduling software

The client’s legacy system was developed with FoxPro, and they wanted to re-architect the software in modern Microsoft ASP.NET MVC technology with C#

Read More
Automation of Accounts Payable (AP) Invoice Processing

Automation of Accounts Payable (AP) Invoice Processing

The client is an innovative technology company which provides an online platform to control & manage entire PCBA manufacturing processes.

Read More
Data Processing and Visualization of Weather Data for Business Aviation Operators

Data Processing and Visualization of Weather Data for Business Aviation Operators

The client is a technology company who provides a Point of Sale (POS) software platform for coffee shops and a mobile app for customers.

Read More
Mobile App Development to Share Videos and Search Athletes

Mobile App Development to Share Videos and Search Athletes

My Crop is a mobile app solution which connects young athletes with college coaches, and fans. The athletes add their performance video highlights from YouTube and Instagram.

Read More

Get in Touch