| Home | Collection Info | People | Projects | Databases | Visits & Tours | Links |
 

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

 

This material is based upon work supported by the National Science Foundation under Grant Nos. 9971885 and 0117772. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author and do not necessarily reflect the views of the National Science Foundation.


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

Send comments on this web site to holze001@umn.edu
Last updated 2 December, 2009