Hi Frank,
I would love it if it were possible to list all flights from (for example)
Minnesota. I hosted a contest in 2005 in Minnesota and it was somewhat
difficult to extract data for all flights that originated in MN. That would
make it even more fun than it already is in my opinion. To find the data I
had to know which pilot had submitted OLC flights. I was then able to
generated a spreadsheet manually by looking at lists of flights by each
pilot. The competition I sponsored also compared flights from specific
soaring sites. That was tough because some of the pilots flew from multiple
locations and submitted flights to the 1-26 Association. In the end I was
able to use the spreadsheet to compare the flights from the 3 gliderports,
but it was not easy. It would be awesome to be able to see a total of all
flights that originated from a particular soaring site.
The contest I sponsored for 2005 is shown he
http://www.soarmn.com/cumulus/olc-mn.htm
Good Soaring,
Paul Remde
Cumulus Soaring, Inc.
http://www.cumulus-soaring.com
"Frank Whiteley" wrote in message
oups.com...
Personally, I don't know why we are using regional filters at all
unless someone in the SSA is planning on regional records/awards. But
those are not in evidence at this point. Since the SSA has the rights
to the US OLC, I'd like to know who requested the regional queries and
what the plans are. It's worthy of discussion. If this is posted
somewhere, point me there please.
I did award state OLC trophies this year and would appreciate some
selectable state filters to isolate flights originating here,
terminating here, or both. However, I can import pilot flights into a
spreadsheet or database and filter appropriately, just takes extra time
and effort. Criteria for last year were Colorado starts. This
eliminated those flights in Uvalde, Hobbs, and Parowan which might have
skewed things a bit here and there. I also included all Colorado
flights, rather than the top six, as the top six led to additional
skewing to particular sites. Including all flights showed pilot
effort, even though there was little difference in the total number of
flights among the best pilots after the out of state flights were
removed. The regional query also removes flights outside the region,
so it misses what some pilots based within the region may be doing. I
guess the question is where to draw the lines and why. I found the
regional query useless.
Frank Whiteley
SSA Governor Colorado