Abstract As discussed in Homework I many ETL (extraction, transformation, and load ing) problems parse data files wherein the data fields is separated by commas. This assignment is a continuation of that process - with an additional two steps. The first step is to convert the input file's latitude and longitude from sexagesimal (base 60) degrees to decimal degrees. For example, the inputs are in the form: degrees, minutes and seconds, arcseconds and direction. The outputs are in the form: sign, degrees, and decimal fractions to represent the same value. Once the latitude and longitude have been converted to decimal the next objectivie is to sort the airports alphabetically. Once that has been option, accomlished the second option is to sort the airports geographically and plan a route from south to north, all the while flying over land. This assignment requires the data extraction, degree conversion, data formatting, sorting by two different criteria, and output the sorted results. The file inputs are defined in the Inputs. Similarly, the sort criteria are defined in Processes and the outputs are defined in Outputs 1 Objectives The objectives of this assignment are to demonstrate proficiency in file I/O, data struc- tures, data transformation, sorting techniques, and file output using C language re- sources 1.1 Inputs There are two basic inputs, the input file name, passed via the command line, and the input file data defined below