Find Specimen Records 2356596 recordsTab into search form

Basic Search Help

This help applies to the basic specimen search and some other search forms in MCZbase. Many fields are autocompletes, values can be selected off of the picklist, or a partial match can be entered in the field. Most fields will accept search operators, described below, which alter the behaviour of the search. .

Special operators that are entered in the field by themselves with no other value

NULL: Find records where this field is empty.
NOT NULL: Find records where this field contains some non-empty value.

Operators entered as the first character in a field, followed by a search term (e.g. =Murex).

=: Perform a (case insensitive, in most cases) exact match search. Fields which take this operator append a wild card to the beginning and end of the search term unless this operator is used.
!: Perform a (case insensitive, in most cases) exact match not search. Will find records where the value in the field does not match the specified search term.
~: Find nearby strings. Finds matches where the value in the field is a small number of character substitutions away from the provided search term. Makes the comparison using the jaro winkler string distance, with a threshold set, depending on the search, on 0.80 or 0.90.
$: Find sound alike strings. Finds matches where the value in the field sounds like the provided search term. Makes the comparison using the soundex algorithm.

Wild cards that may be accepted where a search can take a = operator, but that operator is not used.

%: Match any number of characters. (added at the beginning and end of strings for all fields that can take an = operator where that operator is not used).
_: Match exactly one character.

Guidance for specific fields

Catalog Number: Catalog number accepts single numbers (e.g. 1100), ranges of numbers (e.g. 100-110), comma separated lists of number (or search, e.g. 100,110), ranges of numbers with prefixes (e.g. R-200-210 or R-200-R-210), or ranges of numbers with suffixes (e.g. 1-a-50 or 1-a-50-a). Wildcards are not added to catalog number searches (so =1 and 1 return the same result). To search with wildcards or to limit both prefixes and suffixes, use the search builder.
Other Number: Other number accepts single numbers, ranges of numbers, comma separated lists of numbers, and ranges of numbers, but for most cases with prefixes, search for just a single prefixed number with an exact match search (e.g. =BT-782)
Taxonomy and Higher Geography Fields: Search for a substring (e.g. murex), an exact match (e.g. =Murex), or a comma separated list (e.g. Vulpes,Urocyon).
Any Geography (keyword) Field: This field runs a keyword search on a large set of geography fields. See the Keyword Search Help for guidance.
Keyword Search Field: This field does the same thing as the Keyword Search. See the Keyword Search Help for guidance.
Dates: Collecting Events are stored in two date fields (date began and date ended), plus a verbatim field. Date Collected searches on both the began date and end date for collecting events. A range search on Date Collected (e.g. 1980/1985) will find all cataloged items where both the date began and date ended fall within the specified range. Usually you will want to search on Date Collected. The began date and ended date fields can be searched separately for special cases, in particular cases where the collecting date range is poorly constrained. Search on Began Date 1700-01-01 Ended Date 1800-01-01/1899-12-31 to find all material where the began date is not known, but the end date has been constrained to sometime in the 1800s (contrast with Date Collected 1800-01-01/1899-12-31 which finds material where both the start and end dates are in the 1800s).
Media Type: Click on (Any) to paste NOT NULL into the field, this will find records where there are any related media.

Results:

Keyword Search Help

This help applies only the keyword search, behavior and operators for other searches are different.

: When words are separated by spaces they form a phrase and it is this phrase which is searched for, not the individual words. For example Panama Bay searches for those two words found adjacent to each other (ignoring punctuation and capitalization). Use operators such as Panama & Bay or NEAR((Panama,Bay),3), described below, to find a broader scope of records.

Keyword Search Operators

&: The "and" operator, matches records where the search terms on both sides of the & are present somewhere in the record.
|: The "or" operator, matches words where at least one of the search terms is present somewhere in the record.
!: The exclamation mark finds records that contain the first term but not the second (e.g., Panama ! Canal). Results returned would include "Panama" but not "Canal".
NEAR((term,term2),distance): The NEAR((term,term2),distance) finds words that are nearby each other (e.g. NEAR((Panama,Bay),3) finds records where Panama and Bay are within three words of each other). Example of results: "San Miguel Id Bay of Panama" and "Bay of Panama, Dan Miguel Id".
=: The word equivalence operator, either word is interchangeable in the phrase (e.g., Taboga Island=Id). The results would return rows with "Taboga Island" or "Taboga Id".
FUZZY(term): This finds words that are a fuzzy match to the specified term, fuzzy matching can include variations (e.g. misspellings, typos) anywhere in the term (e.g., FUZZY(Taboga)).
$: The soundex symbol "$" finds words that sound like the specified term, unlike fuzzy matching, soundex tends to find words that are similar in the first few letters and vary at the end (e.g., $Rongelap finds records that contain words which sound like Rongelap. Soundex can be good for finding alternate endings on specific epithets of taxa).
#: The stem operator finds words with the same linguistic stem as the search term, e.g. #forest finds words with the same stem as forest such as forested or forests.
( ): Parentheses can be used to group terms for complex operations (e.g. Basiliscus & (FUZZY(Honduras) | (Panama ! Canal)) will return results with a fuzzy match to Honduras, or Panama but not Canal).
%: The percent wildcard, matches any number of characters, e.g. %bridge matches Cambridge, bridge, and Stockbridge.
_: The underscore wildcard, matches exactly one character and allows for any character to takes its place.