http://www.collembola.org/projects/speclist/queryfaq.htm - Last updated on 2004.03.29 by Frans Janssens
Checklist of the Collembola : Query the Database - Frequently Asked Questions

Peter F. Bellinger (), Department of Biology, California State University, Northridge, CA 91330, USA
Kenneth A. Christiansen, Department of Biology, Grinnell College, PO Box V3, Grinnell, IA 50112-0806, USA
Steve Hopkin, Division of Zoology, University of Reading, PO Box 228, Reading, RG6 6AJ, UK
Frans Janssens, Department of Biology, University of Antwerp (RUCA), Antwerp, B-2020, Belgium

History :

2001.02.28: 0.01: Arne Fjellberg, Frans Janssens
2001.03.06: 0.02: Rafael Jordana
2001.03.12: 0.03: Mikhail Potapov
2001.03.29: 0.04: Kenneth Christiansen, Frans Janssens
2001.04.05: 0.05: Kenneth Christiansen
2002.01.03: 0.06: Anura Wijesekara
2004.03.24: 0.07: Enrique Baquero

This is the general FAQ (Frequently Asked Questions) for querying
the database. It covers general issues of querying the biogeographical
regions and species supplements database.
Contributions are made by users of the database.
'faq length' -or- 'faq message length'
'faq /a test script'

FAQ Overview

General
1) "Can't connect to local MSQL server." What does this mean?
2) What happens if I escape an ongoing query?
3) Why does the species list not appear when I click on a button?
4) No records were listed. All was blank. What do you suggest?

Regions
5) Can you give me the URL to where I can find a map showing the "Good" biogeographic regions?
6) How can I get a list of all species of Sri Lanka?
7) How can I cite the Biogeographic Regions Database?

Supplements
8) How can I query the species supplements?
9) In the supplement I found maritima only once. Where else is it?








































1) Q: General : "Can't connect to local MSQL server." What does this mean?

Whenever you see this error report:
"ERROR : Can't connect to local MSQL server"
it most probably means that the database is out of service...

You can verify the status of the database server to make sure.
Feel free to report problems as soon as possible to Frans Janssens.
This situation can occur whenever the computer that hosts the database
runs into resource problems: such as not enough available processes,
not enough free memory to serve your query, after a reboot of the server, etc...
We will do our best to restore the database service as soon as possible.
Sorry for the inconvenience caused.

Return to FAQ Overview







































2) Q: General : What happens if I escape an ongoing query?

Escaping an ongoing query will always result in an incomplete result.
Normally, your browser will indicate this somehow. Eg, in Netscape, at
the bottom of the escaped page, the message "Transfer interrupted"
is displayed. It is the function of the browser to confirm the escape
event to the user. But, even when the browser (IE?) does not do that,
since the user itself intitiated the escape, she/he should be aware that she/he
interrupted an ongoing task and that the result of this interrupt
is an incomplete result. Escaping a transfer is a general process that has
nothing to do with the database as such. You can escape any www transfer
(a page download, an image download, a file download, etc...) and the
result will always be incomplete.

Return to FAQ Overview







































3) Q: General : Why does the species list not appear when I click on a button?

It is possible that the species list showed up but got hidden by another
window. Check the status list of open windows at the bottom of your screen.
Put the window back in front of all other windows by clicking on its
associated button in the status bar.

This is standard window behaviour. It can happen with any window.
Any (Microsoft) windows user, has to be aware of this.

Return to FAQ Overview







































4) Q: General : No records were listed. All was blank. What do you suggest?

Check the taxon name in the species field.
This field should contain a taxon specification in the form of
somespeciesof_SomeGenus.

I'll give a few examples:

To get the list of recent publications on Podura aquatica,
just select it from species popup lists (in this case the 'a' list)
or enter manually in the species field: aquatica_Podura
Note the _ (underscore) between species and genus name!

To get the list of recent publications on all species of Hypogastrura,
enter in the species field: %_Hypogastrura
Note the %_ to specify that you want to see all species!

To get the list of recent publications on any maritima species,
enter in the species field: maritima_%
Note the _% to specify that you want to see all genera!

To get all recent publications: enter %_%
(= all species of all genera).

Return to FAQ Overview







































5) Q: Regions : Can you give me the URL to where I can find a map showing the "Good" biogeographic regions?

There is a (low resolution) map provided at the website in the
database query and entry forms.
Click on 'Map' above the Region field to open the map.

Return to FAQ Overview







































6) Q: Regions : How can I get a list of all species of Sri Lanka?

This is the procedure that you have to follow to get the
list of all Collembola species of the Indian biogeographic region
Note that this region is not restricted to Sri Lankra.
Clear the species field an enter as such: %_%
(this is a kind of joker syntax meaning anySpecies_anyGenus;
you could also enter %_Onychiurus if you are just interested
in all species of the genus Onychiurus; etc...)
Then select the Indian region.
You can also open the Map to verify that Sri Lanka is included
in the Indian region.
Then submit the query.

Return to FAQ Overview







































7) Q: Regions : How can I cite the Biogeographic Regions Database?

Citation suggested:
Bellinger, P.F., Christiansen, K.A. & Janssens, F. 1996-2004
Checklist of the Collembola, Biogeographic Regions Database.
http://www.collembola.org/projects/speclist/query.htm

Return to FAQ Overview







































8) Q: Supplements : How can I query the species supplements?

The only query that you can do todate is this:
given a species name, retrieve the list of recent publications on
that species.

The query interface is 100% compatible with that of the biogeographical regions
database: the same species pop up list have been reused.
IMHO, this is a big advantadge:
1. you will only have to learn one user interface to access both databases
2. we make sure that the species lists of the different databases
are 100% compatible (no discrepancy is possible in this way).

The genus/subgenus ranking problem is 'solved' in this way:
the species supplements database stores both genus and subgenus.
You can query the database in two ways:
1. simply use the species popup lists, in case you agree
with the 'subgenus' proposed as 'genus' by the popup species lists
or
2. edit the species field manually: you can modify the subgenus manually
to the 'genus' that you would like to query
In both cases, the query will give the same result.
You can try this out with eg. 'pygmaea_Micranurida':
(Micranurida is the subgenus, but it is listed at genus rank in
the species popup lists; the genus is in fact Anurida)
1. select pygmaea_Micranurida from the species list and submit the query
2. go back and edit the species field to 'pygmaea_Anurida'
and submit the query again
You should get the same result in both cases.

As with the biogeographical regions query, you can get a list of all recent
publications of all species of Folsomia by editing the
species field as such: '%_Folsomia'

'nival%_%' will give you all species of all (sub)genera that begin
with 'nival'. This is handy in case you do not remember the
exact inflexion of a name (was it nivalis, nivalus, nivala, nivalum,...?).

Please, note that you should never enter two or more search patterns
in the species field. You can enter %_Entomobrya or
nivalis_%, but never at the same time!

In principle this % thing is nothing more than a simple way to
describe a pattern that should match with the database entries.
The basic pattern to search for species is: 'species_Genus'.
% is the 'joker' character which allows you to construct a
pattern that can act as a kind of filter, a mask.
You always have to use the basic pattern to construct your
filter. So '%_Entomobrya nivalis_%' will not work because it
does not follow the basic pattern 'species_Genus'.
(the basic pattern assumed in '%_Entomobrya nivalis_%'
is 'species_Genus species_Genus').

Therefore
%_Genus matches with all species of that Genus
species_% matches with all genera having a species with name species
%_% matches with all species of all genera

These examples are just the most simple patterns.
Examples of some more 'advanced' patterns:
mar%_% matches with all species that begin with mar
mar%_X% matches with all species that begin with mar of all genera
that begin with X
%iti%_% matches with all species that contain the string iti

It may seem complicated, but it is a powerfull way to allow all
kind of different queries based on a simple pattern recognition
mechanism.

Return to FAQ Overview







































9) Q: Supplements : In the supplement I found maritima only once. Where else is it?

Just run the query maritima_% to get a list of all recent records.

Return to FAQ Overview