Download
1 / 20
200 likes | 276 Views
Tennessee Tree Toppers Weekend Series Scoring Web Application. By Jeff Nibler.
E N D
Tennessee Tree Toppers Weekend Series Scoring Web Application By Jeff Nibler This web application was created to be used for the Tennessee Tree Toppers Weekend Series competition. The TTT Weekend Series competition was created by TTT Competition Committee chairman Ollie Gregory, with assistance from Dean Funk and Jeff Nibler. The web application was created by Jeff Nibler. This web application has many functions that could be used by other clubs around the country, and could be hosted in one place on the worldwide web. It could serve as a national or global level competition database for many different kinds of competitions. The purpose of this presentation is to demonstrate the current abilities of the application in hopes that it can be modified for use with other clubs and competitions around the world. I am more than willing to modify this application to help make it work for a larger audience, and to help promote the sport. Click here to continue
The web application can display reports. This is a report with sample data for our weekend series, so the report is grouped by weekends. All data is stored in a database (including tasks, waypoints, flight information, pilot information, track logs, etc). This means that custom reports can easily be added to the site. Note the different contest categories including most flights per weekend, fastest to land, max duration, and spot landing. The XC results appear on the next row and are divided by pilot type. Clicking on any of them opens a pop-up window listing ALL XC flight details for that given weekend and wing type. Click on this XC group see the details! The report continues to scroll down for each weekend
…. And this pop-up window displays detailing all XC flights made on the given day for the given wing type The “Completed” column means that the task the pilot attempted to fly was or was not fully completed. The “Last WP” column is the GPS name of the last waypoint in the task the pilot successfully hit (for incomplete tasks only). The “Landing Coords” column displays the pilot’s landing coordinates (if they did not make goal). Mileage is total miles flown (leg to leg or open distance), and points are calculated based on task type and mileage. The scoring system can be adjusted as needed. When pilots upload their flight, they have the option of uploading a track log with it. The application can be modified to REQUIRE track log upload if needed. If a track log is uploaded, then users can download that pilot’s track log in whatever format it was uploaded in (currently supports IGC/GPX). In addition, they can click the “Get KML” link which will automatically convert their GPX or IGC track log into KML format for Google Earth and allow them to download it. And lastly, clicking the “View Flight” link will launch a popup window that contains a web browser embedded Google Earth plugin, and will automatically load the pilot’s flight and zoom right to that position on the globe. Lets try it out now! First click on the IGC track log link
An open-save dialogue box appears allowing you to open or save the file on your computer (in the same format the pilot uploaded it in). Now lets click the KML file link
An open-save dialogue box appears allowing you to open or save the KML file on your computer (the original GPX or IGC file uploaded by the pilot is automatically converted to KML by the application). Clicking the “Open” button would result in Google Earth launching on your computer with the flight-path automatically drawn, or you can save it to your computer to view in Google Earth later. Now lets click View Flight
A pop-up window opens with an embedded Google Earth control that functions just like the normal version of Google Earth; you can scroll, zoom, pan, tilt, etc. The flight log is automatically displayed and you are automatically zoomed right in to the track. Note that the track log currently displays in one color. I will be adding color coding for altitude/speed/climb/etc shortly. Click here to continue
That’s it for the reports. Now lets take a look at the pilot entry screens. Currently the app is geared toward TTT pilots so only TTT pilots can enter, but this can easily be opened up to the rest of the world. Click “Continue” to go to the next page
This page allows the user to enter their basic flight information. The data gathered here is used to calculate scores for “Most flights per weekend”, “Longest flight”, “Shortest flight”, and “Spot Landing”. The pilot enters the data in the textboxes then clicks “Save Flight” for each flight they want to save. A table at the bottom of the page displays all flights they have added this year Note that I don’t currently allow pilots to delete their flights if they made a mistake. This is for security purposes because there is no login other than USHPA number. If this application were to be used by more than just the TTT, I would create a secure login system with password. Lets click the “Continue” button to go on the XC page!
This screen is very similar to the main weekend report you viewed earlier, but it displays all XC flights the currently logged in pilot has entered. Note the track log options are the same as on the main report. The pilot can click the button on this screen to add new XC flights. This results in a pop-up window opening with an “XC Flight Wizard” Lets click the button to view the XC Flight Wizard and enter a new flight!
The XC Flight Wizard pop-up window displays. This wizard is a substitute for requiring all pilots to upload a track log for all XC flights. We score on the honor system for our Weekend Series and Team Challenge competitions so we do not require track log file upload (though we do allow them to be uploaded as you have seen on the reports and we will see in just a moment). The idea behind the wizard is to keep the pilots from having to calculate any kind of distances, and to keep lower level pilots without advanced GPS equipment or GPS skill to have an easy time entering their flight data. They simply follow the wizard, enter information, and their distance is automatically calculated. Sometime during the first week of March, I will add functionality to have the option of replacing this wizard with an IGC/GPX track log upload that will automatically calculate distance for all types of tasks (triangle, out and return, open distance, etc). Once the pilot selects their wing type and flight date, they click next to get to the next screen. Click “Next” to continue
A drop-down list of all available tasks displays. The available tasks are defined in an administrative related screen elsewhere in the application (as are the waypoints that make up the tasks). Once the pilot selects their task from the list, they click the “Next” button to continue (which is currently hidden behind the drop-down results in this screenshot) so…… Click here to continue
This screen asks the pilot if they made goal. The drop-down box contains only “yes” and “no” options. If they select “Yes”, they are taken to the confirmation screen where they can save their flight. Because the application knows the waypoints in the selected task, the distance can be automatically calculated without further input from the pilot. If the user selects “No”, they are taken to the next screen. Click the next button to continue (assuming we also select the “No” option in the drop-down box).
This screen asks the user to select the last waypoint they successfully reached. The list of waypoints in the drop-down is limited to those waypoints within the task they selected earlier. Once they select this, the application will know how many legs they completed (if any) and can automatically calculate distance between those completed legs based on the waypoint data stored in the database. For this example, I will click the last waypoint in the triangle before goal which means I completed the first two legs of the triangle, but didn’t reach the goal. Click the next button to continue
This screen asks the pilot to enter their landing coordinates. These will be used to calculate the distance for their last, partially completed leg. The distance they receive credit for is the distance between the next waypoint, and the previous waypoint, MINUS the distance between the next waypoint and their current position. I have entered coordinates that are slightly off course for the final leg. Click the next button to continue
The final confirmation screen displays. This screen shows the user everything they entered, tells them the mileage they receive credit for, and tells them their score for the flight (including a detail of how the points were calculated for each leg of the task). The pilot can save the flight now, start over, or add an IGC/GPX track log file. Lets add a track log file by clicking the browse button
A dialogue window opens allowing the user to select an IGC or GPX file to download. Once they select the file and click open, they click the “Save XC Flight” button to save their flight Click the Save XC Flight button to continue
The flight is saved, the track log file is uploaded, and the user is notified of the status. The information the user entered is immediately available in the report screens. The user can now close the window or continue entering additional flights Now lets take a look at the administrative screens that allow the admin to enter waypoints and routes/tasks. Click here to continue
This is the waypoint maintenance screen. Waypoints are easily added on this form. Click here to continue
This is the task/route screen. The drop-downs list all waypoints in the database. Tasks are easily added using this form. Click here to continue
This concludes the presentation of the Tennessee Tree Toppers Weekend Series scoring application. We hope that this application will benefit pilots in the USA and around the world. If you have any questions about this application, please contact: Jeff Nibler jeffnibler@gmail.com (404) 357-8736 If you have any questions about the TTT Weekend Series Competition, please contact: Oliver Gregory olliettt1955@yahoo.com Thank You!
