| ASF Home | KID Home | Search/Login | Help | Privacy | Sun Dec 22 12:12:34 2024 (Sydney/AU) | |
| Australian Speleological Federation KID: Help: Advanced Search | ||
| Australian Speleological Federation: Help: Advanced Search | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Help for the Advanced SearchPurposeTo provide read access to all the data in the ASF Karst Index database and to provide complete control over the queries. The other search methods only provide access to a very restricted number of database fields. To ensure that the information returned by the database is what you expect you will need to thoroughly understand how the advanced search works.Don't forget to have a read of the Search Tips section.
Search MethodologyThere are hundreds of fields in the ASF KID and they are classified into 49 categories. These categories are the same as the ASF's Cave Summary Form (1985 Karst Index, Appendix A) so that you will be familiar with the layout and format.To divide up the task of selecting fields in a query the Advanced Search is done in two parts; in Part 1 you select which of the broad categories you are interested in querying and in Part 2 you will be able to select individual fields within those categories. For instance if you check [Karst Feature] in Part 1 then when you move onto Part 2 this category will be expanded and you will be able to select fields such as "Entrance, Arch, Bridge" to "Streamsinks and Uvalas".
Part 1 - Select Categories to QueryTo select the categories that you wish to query in Part 1 simply tick each category. You can tick as many as you wish. When you have finished making a selection click the [Select Ticked] button. If you really wish to make a query involving all the categories there is a [Select All] button.The selected categories will determine what fields in the database will be available for you to perform queries on in Part 2. If you do not select a category it will not be searched and the KID will not return any information on any fields within unselected categories. Part 2 - Select Individual Fields to QueryIn this section you specify your query more precisely. This is done by selecting options in the drop down boxes or filling out text boxes with values to restrict the information that will be returned to you. Performing searches as in the search examples below are the best way to understand how this works.Format OptionsExample:
The standard 1985 format returns the same information on the caves selected by the search as the classic 1985 Australian Karst Index Book shows. Note that you may have searched on fields that the 1985 KI did not show. That data will not appear in the returned information, only information that the 1985 KI showed will be returned. The purpose of this format is to return a short summary of the cave in question. Example:
The one per cave format returns a single HTML formatted table for each cave. Each row of the table represents each field that the KID searched on. This format is good when you have many fields but few caves as then the table will be long but not too wide so that it will probably print OK on A4 sized paper. You can save the file and many word processors will be able to read the HTML table into their table format. Example:
The one per cave (plain) format returns a single plain text formatted table for each cave. This is excellent for copying into documents that do not support HTML. Example: TopState Tasmania Area Ida Bay Serial No. 2 Principal Name Loons Cave Length 1000.0 Pitches 27.0 Saving and Deleting SearchesRetrieving Saved SearchesSaved searches are listed to the right of the title "Advanced Search - Part 1". Saved searches can be loaded selecting the saved query you want from the drop down list box and clicking the [Select Saved] button.
Saving New SearchesTo save a new search:
Deleting Saved SearchesYou can easily delete previously saved searches by selecting the search from the drop down box and clicking the [Select Saved] button. This will load and run the saved search. Now clicking the [Delete] button will delete the seach and return you to Part 1.Search ExamplesExample 1We wish to find out what caves in Australia are listed as having the fungal infection histoplasmosis. I just wish to know the name and number of the cave.Part 1: Select Categories to Query
We are interested in finding the cave number, cave name and a particular
hazard. These are in the following categories; select each one by
ticking the checkbox for each category. Tick the Number, Names and Hazards buttons. [X] 1. Number [X] 24. Hazards [X] 3. Namesand then click the [Select Ticked] button. The server will return a new page where you can now select individual fields in Part 2. Part 2: Select Individual Fields and Construct your Query The screen would look like this:
1. NUMBER
1.1 STATE or PROVINCE [ all ] <-- change this to "all"
1.2 AREA [ ] <-- leave this blank
1.3 SERIAL NO. [ ] <-- leave this blank
3. NAMES [ ] <-- leave this blank
24. HAZARDS
[X]histoplasmosis <-- select just histoplasmosis
(leave all the other fields blank)
Click on the drop down selection menu and select the State "all"
so that the search will be over all States.
Select [X]histoplasmosis from the Hazards list. Clicking the [Submit] button will return all caves in Australia which are listed as having had histoplasmosis. The results of the query 6 rows match
If we had entered in the AREA field "Undara" this would further restrict the search to caves within this area. In this case only three caves would now be returned by the search ie. Hanson, Taylor and Picnic Cave. Entering data into the number field "1-10" would further restrict the search result to caves at Undara which have serial numbers in the range 1-10.
Example 2What sea caves are there in in South Australia? What ones are in dune limestone?Part 1: Select Categories to Query Tick the Number, Names, Cave Type and Rock Type buttons. [X] 1. NUMBER [X] 3. NAMES [X] 4. CAVE TYPE [X] 5. ROCK TYPEand then click the [Select Ticked] button. The server will return a new page where you can now select individual fields in Part 2. Part 2: Select Individual Fields and Construct your Query The screen would look like this: 1. NUMBER 1.1 STATE or PROVINCE [ Select ] 1.2 AREA [ ] 1.3 SERIAL NO. [ ] 3. NAMES [ ]Click on the "STATE or PROVINCE" drop down selection menu and select the State "Victoria". Leave the other entries; AREA, SERIAL NO. & NAMES blank. We don't want to limit our search to any particular area or caves in Victoria. Next we wish to limit our search to caves or karst features which are of type "sea cave". Also check "weathering cave" just in case anyone has classified sea caves under wethering caves. To do this select the appropriate check boxes as below. 4. CAVE TYPE [ ] (limestone cave) [ ] artificial cave [ ] blowhole [ ] boulder cave [ ] fault-movement cave [ ] glacier cave [ ] lava tunnel <-- select this checkbox [ ] lava vent <-- select this checkbox [ ] mine [ ] rock shelter [X] sea cave [ ] piping cave [X] weathering cave [ ] (misc. type)We have now setup the query and can click the [Submit] button. The results of the query The KID will report that something like 17 rows match. These are some of the first few entries:
We are particularly interested in sea caves in dune limestone so let's limit the search. We have to return to Part 2 of the search where we can restrict the results to just those caves that are in dune limestone.
Save the search for later use To the left of the [Save Search] button is a text entry box. Enter into here a short text description of your last search and then click the [Save Search] button. When you return to Part 2 you will see under the title, for example: "saved: Sea caves in dune limestone in SA" If you return to Part 1 you will see that this search is now an option in a drop down box on the right of the title. You can use this search again without having to setup the query again by selcting the saved query you want and clicking the [Select Saved] button.
Example 3What caves in NSW have a recorded maximum temperature greater than 30 °C?In this example we introduce the < and > commands for specifying ranges less than or greater than some numeric value. Part 1: Select Categories to Query We want to know the cave number, cave names, air temperature range and we shall include the moisture category as that information may be interesting. Tick the following categories: [X] 1. Number [X] 38. Air Temp Range [X] 3. Names [X] 40. Moisturethen click the [Select Ticked] button. Part 2: Select Individual Fields and Construct your Query The screen will look like this:
1. NUMBER
1.1 STATE or PROVINCE [ NSW ] <-- change this to "NSW"
1.2 AREA [ ] <-- leave this blank
1.3 SERIAL NO. [ ] <-- leave this blank
3. NAMES [ ] <-- leave this blank
38. AIR TEMP RANGE MIN TEMP [ ] <-- leave this blank
MAX TEMP [ >30 ] <-- enter >30 here
40. MOISTURE [ --select-- ] <-- leave this as `select'
By selecting the State and changing it to NSW we are restricting the search
to caves in NSW. Entering a MAX TEMP value of >30 will find caves with a
maximum temperature greater than 30 and by leaving all the other fields blank
we are not restricting the search any further and any information in these
fields will be returned.
Click the [Submit] button. The returned results will be like the following:
This example can be used to demonstrate why it is important to understand what the search is retrieving. Suppose that we add to the search the additional restriction of a recorded minimum temperature of greater than 10 °C.
38. AIR TEMP RANGE MIN TEMP [ >10 ] <-- now enter >10 here
MAX TEMP [ >30 ] <-- enter >30 here
Now we get back just the single entry for Humidicrib cave;
The other two caves "Thermal Number 1" and "Thermal Number 2" are not returned. This is because those caves have no recorded minimum temperature and we have asked the search to only return caves where this field is greater than 10. Example 4What Queensland caves have a recorded minimum humidity between and 80 and 90 % with a maximum humidity greater than 99 % ? In this example we introduce the colon (:) command for specifying a range of numeric values to search. Part 1: Select Categories to Query We want to know the cave number, cave names, humidity range and the moisture. Tick the following categories: [X] 1. Number [X] 39. Humidity [X] 3. Names [X] 40. Moisture then click the [Select Ticked] button. Part 2: Select Individual Fields and Construct your Query. The screen will look like this:
1. NUMBER
1.1 STATE or PROVINCE [ Qld ] <-- change this to "Qld"
1.2 AREA [ ] <-- leave this blank
1.3 SERIAL NO. [ ] <-- leave this blank
3. NAMES [ ] <-- leave this blank
38. HUMIDITY RANGE MIN HUMIDITY [ 80:90 ] <-- enter 80:90
MAX HUMIDITY [ >99 ] <-- enter >99 here
40. MOISTURE [ --select-- ] <-- leave this as "select"
Click the [Submit] button. The returned results will be like the following:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||