(This reply is specific to the USA)

Chris,

Your list shows that you have put a lot of good thought into the topic. However, I've been creating turnpoint lists for contests and other uses for some years, and my process looks quite different. There are a couple of reasons for this:

- There are automated tools to do many of the things you mention, such as generating names, renumbering, composing airport lists, and so forth.

- The problem of keeping the airport data current is actually much more difficult than you might think. Most of the tunrpoint lists I see are materially stale. This happens because airports (especially private ones) close, frequencies and ID's change, and so forth. These kinds of changes are actually more frequent than many people realize.

So here is my process:

1. Concentrate on getting the control points established first, primarily using tasking considerations. These are the ones that would be numbered points in a contest, including the starts and finishes. Produce a list that contains ONLY the control points. Many people like to use SeeYou for this planning, and produce a .CUP file at the end.

2. Add to this list any unofficial airports or outlanding places you might want to include. These are the ones that would not appear in official databases. Designate these as "Outlanding Place" in SeeYou. This plus the control points from step #1 become your master list.

3. Compose a "black list" of airports that you want to exclude from your final database. These are ones that appear in the official sources, but for some reason should not be included. Perhaps the airport doesn't actually exist, or there is some reason you really wouldn't want to land there.

4. Use an automated tool such as my website (http://www.soaringdata.info) to fill the turnpoint list with airports. There are a couple of ways of doing this. One is to select a centerpoint and a radius. Another is to let the system to compute a bounding polygon for the turnpoints, and include all the airports within or near the boundaries. My system will produce a Soaring Turnpoint Exchange (STX) format file as well as CUP and a few other output formats. It will also automatically produce companion special use airspace files for the area covered by the turnpoints.

5. Make any hand edits you think necessary. You can choose to correct mistakes that might originate in official data here. There is also a way to make error reports to the FAA so that the official data gets fixed.

6. Submit the STX file to the Soaring Turnpoint Exchange. John Liebacher has automated tools to automatically translate it to literally dozens of different formats, complying with name and other restrictions unique to each..

7. When it comes time to update the database, you just start at step #4. You get fresh airport and airspace data painlessly.

I can provide detailed help with any of these steps if you would like to contact me separately. You can use the "Questions and Comments" link on my site.

Best of Luck

Lynn Alley
"2KA"