Australian Speleological Federation KID: Help: Advanced Search


[
help index | simple search | standard | top10 | advanced | tips ]



Australian Speleological Federation: Help: Advanced Search

Help for the Advanced Search

  1. Purpose
  2. Search Methodology
  3. Format Options
  4. Saving and Deleting Searches
  5. Search Examples
    1. Search for caves in Australia that have histoplasmosis
    2. Search for South Australian sea caves in dune limestone
    3. Find caves in NSW with maximum temperatures greater than 30 °C
    4. What Queensland caves have a minimum humidity range from 80 to 90 % with a maximum humidity greater than 99 %

Purpose

To 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 Methodology

There 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 Query

To 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 Query

In 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.

Top


Format Options

tabular standard 1985 one per cave one per cave (plain text)
The tabular format returns a HTML formatted table with one row for each record found. Each column of the table will list a field that was searched or requested in the output. If you have many fields in your search the table may be quite wide and printing the table, while maintaining the formatting, may be a problem. If setting a smaller font size still results in a table that is too wide to print you may wish to use the one per cave format.

Example:

State Area Serial No. Principal Name Length Pitches
Tasmania Ida Bay 2 Loons Cave 1000.0 27.0
Tasmania Mole Creek 64 Tailender Cave 1000.0 8.0

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:

7IB-2 Loons Cave at Ida Bay
Entrance is cave type; (2 entrances); development is cave with small stream; karst type is unknown; length is 1000.0 m, est during visit; vertical extent is 30.00 m; reasonably explored, no leads noticed; wet environment; pitches 27.0.

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:

State Tasmania
Area Ida Bay
Serial No. 2
Principal Name Loons Cave
Length 1000.0
Pitches 27.0

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:

State   Tasmania
Area    Ida Bay
Serial No.      2
Principal Name  Loons Cave
Length  1000.0
Pitches 27.0
Top

Saving and Deleting Searches

Retrieving Saved Searches

Saved 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 Searches

To save a new search:
  1. Perform the search query that you want to save.
    Go through Part 1 and 2 of the Advanced Search selecting your fields and finish with the [Submit Query] button.
  2. Name the search and save it
    In the centre is a text entry box. Into here you can enter a short text description of your last search and then click the [Save Search] button which is to the right of the text entry box.
  3. Return to Part 2 by clicking the [Back to Part 2]. Under the title "Advanced Search - Part 2" you will now see the text saved: followed by the text description you entered above. This lets you know that the query has been saved.
Now when you return to Part 1 by clicking the [Back to Part 1] button you will see that this search is now an option in a drop down box on the right of the title "Advanced Search - Part 1". You can use this saved search without having to setup the query again by selecting the saved query and clicking the [Select Saved] button.

Deleting Saved Searches

You 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.

Top


Search Examples

Example 1

We 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. Names 
and 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

State Area Serial No. Principal Name Hazards
Victoria East Buchan 33 Dusty Cavern histoplasmosis
Queensland Barambah Basalt 2 Dustpipe Cave ticks, histoplasmosis
Queensland Ravensbourne 3 T'Otherside Cave histoplasmosis
Queensland Undara 1 Hanson Cave histoplasmosis
Queensland Undara 4 Taylor Cave histoplasmosis
Queensland Undara 24 Picnic Cave histoplasmosis

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.

Top


Example 2

What 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 TYPE
and 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:

State Area Serial No. Principal Name Cave Type Rock Type
South Australia Adelaide Hills 12 Newland Head Cave sea cave limestone
South Australia Adelaide Hills 14 Waterfall Cave weathering cave sandstone
South Australia Adelaide Hills 15 Bluff Inlet Cave weathering cave sandstone
South Australia Eyre Peninsula 15 Elliston Sea Cave sea cave dune limestone
South Australia Eyre Peninsula 17 Talia Sea Cave sea cave dune limestone, granite
South Australia Eyre Peninsula 18 Erosion Sinkhole sea cave dune limestone

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.

  1. Click the button [Back to Part 2]
  2. From category 5.ROCK TYPE, select [X]dune limestone
    5. ROCK TYPE
    [ ] limestone
    [X] dune limestone
    [ ] dolomite
    [ ] marble
    [ ] basalt
    [ ] dolerite
    [ ] granite
    [ ] gypsum
    [ ] ice
    [ ] lava
    [ ] magnesite
    [ ] mudstone
    [ ] quartzite
    [ ] sandstone
    [ ] soil
    [ ] tuff
    
  3. Click the [Submit] button
Now only 6 rows match the search criteria

State Area Serial No. Principal Name Cave Type Rock Type
South Australia Eyre Peninsula 15 Elliston Sea Cave sea cave dune limestone
South Australia Eyre Peninsula 17 Talia Sea Cave sea cave dune limestone, granite
South Australia Eyre Peninsula 18 Erosion Sinkhole sea cave dune limestone
South Australia Eyre Peninsula 48 The Sewers sea cave dune limestone
South Australia Eyre Peninsula 64 Whalemans Grotto Cave sea cave dune limestone
South Australia Kangaroo Island 5 Ravine Des Casoars Cave sea cave 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.

Top


Example 3

What 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. 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 [ 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:

State Area Serial No. Principal Name Min.Temp. Max.Temp. Moisture
New South Wales Wee Jasper 33 Thermal Number 1   30.0 wet environment
New South Wales Wee Jasper 34 Humidicrib 14.0 33.0 dry environment
New South Wales Wee Jasper 35 Thermal Number 2   30.0  

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;

State Area Serial No. Principal Name Min.Temp. Max.Temp. Moisture
New South Wales Wee Jasper 34 Humidicrib 14.0 33.0 dry environment

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.

Top


Example 4

What 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:

State Area Serial No. Principal Name Min.Humid. Max.Humid. Moisture
Queensland Camooweal 20 Kalkadoon Cave 82.0 100.0 wide moisture range
Queensland Camooweal 33 Spinafex Cave 85.0 100.0 wide moisture range

Top




[
ASF | KID | search | help | privacy ]