GrylTett database 3 Jan 2003Page 1
GrylTett database
Names for tables and fields as of 22 Oct 2003
GrylTett.mdb is a database for storing the information on crickets and katydids accumulated by Thomas J. Walker, University of Florida, from 1955 to date. The current version is in Microsoft Access 2000. Until January 2003, the database was in Access 1997. The most recent version that can be used with Access 1997 is OldGrylTett.mdb. It was last updated 31 Dec 2002.
Tables
tblAbbreviations [abbreviations used in other tables; 73 records]
AbbrevID
Table
Field
Abbreviation
Meaning
Notes
tblCommonNames [of higher categories; 102 records]
Name
CommonName
Level [family, subfamily, genus]
DateAdded
DateEdited
tblFieldNotes[1443 records]
FieldNoteID
CollDate
CollNo
Country
State
County
GeographID
Locality
Habitat
Collector
SourceNo
Notes
DateAdded
DateEdited
tblFieldNoteSources [where hardcopy of field notes can be found; 10 records]
SourceNo
Description
tblGeographIDs [includes FIPS codes for USA states and counties; 3145 records]
GeographID
Country
State
StateCode [Federal Information Processing Standards (FIPS) codes for USA states]
County
CountyCode [FIPS codes for USA counties]
Locality
Notes
DateAdded
DateEdited
tblSpecies [names of species of N. Amer. & West Indian katydids and crickets; 459 records]
SpeciesNo [numbers assigned to species in Walker Tape Library; later expanded to include all North American species (even if not tape recorded)]
Genus
SpecificName
Author
Bracket [for denoting whether author originally placed species in a genus other than its present one]
Year [of original description]
Superfamily
FamOrSubfamily
Codon
OSFO2No [taxon number from Orthoptera Species File Online, version 2]
SINA [“yes” means taxon is listed in Singing Insects of North America [SINA]; “(no)” means that the taxon occurs in the region covered by SINA, but that it currently represents no species listed in SINA; “no” means that taxon is not known to occur in region covered by SINA.]
CommonName
Synonyms
Notes
DateAdded
DateEdited
tblRecordedSongs [records in Walker Tape Library; 9627 records]
RSongID
Year
CutNo
Codon
Genus
Specific Name
SpeciesNo
IndivNo
Take
Notes
Country
State
County
Locality
GeographID
CollDate [name of field not always descriptive; individuals taped in field were often not collected]
CollNo
Habitat
Collector
Specimen
Sex
TapeDate
TempC
Place
Conditions
TapedBy
Parabola
Microphone
Recorder
Timing
Quality
Background
NotesOnTape
RecNo [from Access 97 database]
RecPrefix [always RS]
FlagNo [always 2]
MLNS [status of archiving by Macaulay Library of Natural Sounds, Cornell University]
LNSCatNo [ID No. of digitized song in MLNS]
CDNo [ID No. of CD-ROM that has the digitized song (with taped specimens in FSCA)]
DateAdded
DateEdited
tblMain [24,254 records]
MainRecID
RecPrefix
RecNo [from Access 97 database]
Genus
SpecificName
SpeciesNo
Country
State
County
GeographID
Locality
Individuals
CollDate [name of field sometimes misleading: HS specimens and some LN and RS specimens were not collected; recordings of free insects assigned CollDate that equals TapeDate]
CollNo [refers to tblFieldNotes]
CollEndingDate [last date of range of dates]
NSDateBegin [nonstandard date begin]
NSDateEnd [nonstandard date end]
Collector [for HS records and some LN and RS records, specimens not collected]
Source [museum or collection; used only for SP records
Origin [intermediate or final source of record= where record was copied from or , if new, who entered it]
AuthorName [LN records only; includes authors of notes]
PubDate [LN records only; includes years of notes]
Page [LN records only and only for literature records]
Notes
FlagNo
DateAdded
DateEdited