MyFlightRoute - new function

kullery
Posts: 398
Joined: Sat Oct 06, 2012 3:13 am
Location: Medina, OH

MyFlightRoute - new function

Post by kullery »

The TEC route search on MyFlightRoute.com now includes a link to Skyvector for each TEC route. The link should produce a chart of the full TEC route (along with your specified departure and arrival airports). If the route includes any airways, the link will include all of the waypoints along those airways.

I've been wanting to add this for some time, but I found that it was a bit more challenging then you might first think. There is a surprising amount of data and code required to support this and much of the data had to be manually "tweaked". I am certain that there are still a few bugs. If you see an error with the route which the link generates, please drop me a note (admin@myflightroute.com) with the TEC route that you are using and I'll clean it up.



NOTE TO KEITH: the forum is not accepting image uploads.......it generates a "Sorry, the board attachment quota has been reached" message.
Ken Ullery - PPL-SEL, 1G5
Cyrus
Posts: 350
Joined: Sat Dec 29, 2012 8:33 am
Location: Virginia, USA

Re: MyFlightRoute - new function

Post by Cyrus »

Ken, you are THE man!

Muchas gracias! :D
-Cyrus Kapadia. A few RW hours in a C172, then a 15 year hiatus. Joined PE in Dec'12, then took a break. Now I'm back, learning fast and loving it. If I'm on, it's usually between 22h and midnight EST with Baron 258E, Skyhawk 176CM or Learjet 66L.
lwilliams
Posts: 206
Joined: Thu Dec 09, 2010 8:32 pm
Location: Guelph, Ontario

Re: MyFlightRoute - new function

Post by lwilliams »

This web site is fantastic.....a must visit fir Pilotedge enthusiasts.
Lee Williams
Keith Smith
Posts: 9943
Joined: Sat Oct 09, 2010 8:38 pm
Location: Pompton Plains, NJ
Contact:

Re: MyFlightRoute - new function

Post by Keith Smith »

Thanks a lot, Ken! I'm sure that was a ton of work...airway parsing is no picnic!

I've increased the quote for images.
kullery
Posts: 398
Joined: Sat Oct 06, 2012 3:13 am
Location: Medina, OH

Re: MyFlightRoute - new function

Post by kullery »

Actually the airway parsing turned out to be the easy part. I collected each airway's waypoints and put them in a database. Then wrote some VBA code to find the airway entrance/exit waypoints and return all the waypoints in between. With that code in place, I thought it would solve most issues. WRONG!!!

Additional manual adjustments were needed for:
  • TEC routes that were written with intersecting airways (i.e. LAXN65) but they don't specify the intersection name in the TEC route (likely the intersection was named long after the route was originally created).
  • TEC routes that have you immediately join an airway without a specific entry waypoint (for example many of the BURN routes). For those I approximated an entry point and some of these likely need to be adjusted.
  • TEC routes (mostly for jets) that include intersections of 2 radials without a name or airway.
  • TEC routes that start/end with specific SIDS and STARS.
  • And of course the routes into HHR which include "HHR RY25 LOC"......I don't think any charting application gets that one correct!!!
In all, I ended up making some sort of manual adjustment to almost half of the 425 TEC routes to support the charting link. Note that these adjustments all occur "behind the scenes". The route you see on the website should still be exactly what is published in the AF/D.

Basically, if you see a "GPS" waypoint in the Skyvector flight plan, it was done manually so double check that it makes sense for your specific flight.
Ken Ullery - PPL-SEL, 1G5
Ryan B
Posts: 856
Joined: Mon Mar 05, 2012 2:37 pm

Re: MyFlightRoute - new function

Post by Ryan B »

I must be dense but the skyvector link column is blank when I search for TEC routes... am I missing something?
PE ID: 29
FAA ATCS
FAA PPL ASEL
Cyrus
Posts: 350
Joined: Sat Dec 29, 2012 8:33 am
Location: Virginia, USA

Re: MyFlightRoute - new function

Post by Cyrus »

lol, Ryan. This caught me out too, at first.

You have to select an Aircraft Classification first (Q, P, M, J), then you'll see the "Detail", "SkyVector" and "File Alt" links/info.

The 'Detail' link is especially wonderful... all the info about departure and arrival fields in one handy screen.
-Cyrus Kapadia. A few RW hours in a C172, then a 15 year hiatus. Joined PE in Dec'12, then took a break. Now I'm back, learning fast and loving it. If I'm on, it's usually between 22h and midnight EST with Baron 258E, Skyhawk 176CM or Learjet 66L.
tshuff
Posts: 152
Joined: Fri Jan 24, 2014 4:51 pm
Location: Massachusetts, USA

Re: MyFlightRoute - new function

Post by tshuff »

This is an awesome update! Thanks for the work you do on this site, makes my life endlessly easier when jumping ad-hoc :).
Ryan B
Posts: 856
Joined: Mon Mar 05, 2012 2:37 pm

Re: MyFlightRoute - new function

Post by Ryan B »

Thanks.... I swear those radio button options weren't there before.
PE ID: 29
FAA ATCS
FAA PPL ASEL
kullery
Posts: 398
Joined: Sat Oct 06, 2012 3:13 am
Location: Medina, OH

Re: MyFlightRoute - new function

Post by kullery »

Ryan B wrote:Thanks.... I swear those radio button options weren't there before.
:) Yup, they were always there.

I suspect that you are not alone in missing them because the usage reports for the website show that the "detail" page is not accessed by a very high percentage of users. I suspect that many never knew it existed because the links didn't show up until a classification was selected.

I just changed the page so the links always show up. However, if you try to select "Details" prior to picking a classification, you should get a prompt. This is required because the system can not determine the correct altitude for your flight plan unless it knows you aircraft classification.
Ken Ullery - PPL-SEL, 1G5
Post Reply