Peakbagger.com

Help for the Query Page

Introduction

Peakbagger.com has over 400 peak lists on its Peak Lists page, ranging from well-known hiking/climbing endeavors to obscure summit collections of interest to peakbagging geeks only. However, it is obvious that untold thousands more lists could be added—given over 30,000 peaks in the master Peakbagger database, the number of unique possible peak lists is astronomical.

To help address this mismatch, registered users of Peakbagger.com can now create their own peak lists using the new Query Page. This page is a simple interface that lets users enter various criteria for peak inclusion and generate a query result set that becomes a list.

General Considerations and Limitations

Only registered members of the site can create queries. To sign up, use the Login Page to request an activation code and start the process of getting an account.

To access the query page, click on the "Query" link in the upper right hand corner when you are logged in. Or, your home page on this site also has a link to the Query Tool.

Provisional peaks entered by Peakbagger.com users WILL NOT ever appear in any query results—only after they have been promoted to “full” peaks are they eligible for inclusion. If you have entered peaks that you would like to see on a list you have created, email the webmaster and ask him to promote your peaks.

The maximum amount of peaks that will be returned with a query is 200.

All the criteria are joined using the logical “and” to yield a query result set. You cannot specify an “or” condition. Therefore, every attribute you enter will generally subset your list further. It is not possible to generate complex queries based on different sets of and/or logic.

You cannot generate “High Point” queries using this tool, such as “show me all the high points of the provinces of Albania”. If the data for such a query existed in the database, the query would likely already exist as a permanent, main list.

Generating a Query

The query page allows you to create your list using about 20 different attributes of a peak, including: numeric values such as elevation, prominence, isolation, and distance to a point; location such as country, state, county, island, mountain range, park; and also by matching a given name string.

The criteria in the third column for Range, Island, Park/Land, Wilderness, Basin, and Map all work using auto-complete. Start typing in the name of your desired place, and then wait a second or two to see a drop-down of auto-complete options. You MUST select one of these options from the drop-down for your selection to be registered for use in the query. Bear in mind that not all ranges, islands, parks, etc. in the world are necessarily in the database, and therefore you will not be able to query based on items not in the auto-complete dropdowns.

When you have set up your criteria using the various dropdowns, click on the “Run Query” button to generate your results. The results do not update dynamically when you change criteria or add/remove columns. Often your first try at a query will not be quite right, and you can then fine-tune it by adjusting multiple criteria in between clicks of the “Run Query” button.

You can select the default units for your list (feet/miles or metric) , the number of peaks you want returned (if less than 200), the method for calculating elevations, and the columns you want to sort the list by. The Match Text box is for limiting your peaks to ones whose names contain a certain character string, similar to doing a search by name. This can help you generate a list of, for example, all the Montana peaks with “bald” in their names (15 of them).

You can select the columns you want displayed using the checkboxes along the bottom of the query criteria pane. Every list must contain the peak name, elevation, and ascent date columns. Other columns are optional and can be selected if you desire. The checkboxes represent the only columns allowed in query result sets.

Saving Queries as Lists

Note that a query result set is essentially the same thing as a list. If you have generated a query that you like, and you think it makes a nice peak list for either armchair interest or as an actual hiking/climbing objective, you can save your query.

To save a query that you have run, enter a name in the box supplied and click “Save Query”. It is now saved as a list on the site, and viewable using the standard list interface. After you save, a button on the Query Page allows you to see your list in this fashion.

Anyone on the internet can see a list you create. They are not part of the main Peakbagger.com Peak List page, but they are accessible from a climber’s home page on the site. Anywhere a climber's name is hyperlinked, click to go to his/her home page, where a "Custom Query Lists" link will be present if that climber has saved any queries/lists. To see your saved lists, click on the "My Queries" link at the top of a page when you are logged in.

The Front Runner’sList (FRL) is available for any list you create from your list of personal lists, or from a link at the bottom of your list page.

If you decide you want to change your list, you can call it up on the Query Page by clicking on the Edit link from your list of personal lists, or from the list page itself. You can change the criteria until you like the new result set, and save it as a list again. Do be aware that there might be other users that found your list and liked it, and they may even be pursuing peaks on it. You do have the right to change or delete your list anytime you want, or course, but be careful about a list that seems unique and has been around for a long time.

To delete a query/list, click on an Edit link and then, on the Query Page, hit the Delete button.

A registered user can save up to 100 queries as lists.




Questions/Comments/Corrections? See the Contact Page
Copyright © 1987-2014 by Peakbagger.com. All Rights Reserved.