UMSP Trichoptera Biota© database

Definitions and codes

Specimen code - Each specimen is assigned a unique alphanumetic identifier beginning with the prefix UMSP followed by 9 numerals, e.g. UMSP000394857. This code is associated with a barcode label affixed to the specimen or to multiple specimens preserved in a vial.

Species code - Each species is assigned a unique species code generally consisting of the first 4 letters of the genus name and the first 4 letters of the species name, e.g., Nectdors for Nectopsyche dorsalis.

Collection code - a collection is a single collection event at a locality during a period of time by one or more collectors. A collection is a unique event while a locality can be visited at diffferent times resulting in several collections at the same locality. Collection codes are usually formed from a 2 letter abbreviation for the country or state, etc., followed by the date, e.g., CR900809 or Costa Rica on the 9th of August, 1990.

Locality code -  a locality, a place where a collection occurs, is usually identified in the database by an abbreviation for the country and region followed by a suffix of numbers assigned by the database or manually.

General tips
Database Structure
Tables and fields
Troubleshooting
Examples

Return to Tutorial Main

Access UMSP Trichoptera database

© 2000-2008 by ADCS and the Regents of the University of Minnesota.