INTERNATIONAL ODONATA RESEARCH INSTITUTE DATABASE FOR ODONATA:

THE I.O.R.I. data base was designed and written by Bill Mauffray in 1993 originally with Microsoft ACCESS 1.0. It has been upgraded several times and finally converted to Office 2000 access in 1999.

The database design is a relational database utilizing a main input "form" for each specimen. The "form" is based on an underlying "query" which draws from all the "tables" of data. These "tables" supply the data to the individual "fields" on the input "form" by "drop down selection boxes". This eliminates spelling errors and repetitive typing. The final filed out "form" supplies the data to the underlying main "Inventory" data base "Table".

Here is a list of the "tables" (called "databases" by some programs)

• INVENTORY NO: (this is a counter field)
• TAXON: (sub tables for Genera and species, derived from Charles Bridges' data base)
• LOCALITY DATA: (specific locality information including habitat, GPS, and Altitude, entered only once)
• LOCATION: (Country and sate/province codes) 4 characters utilizing ISO codes
• SEX/STAGE:
• COLLECTOR:
• COLLECTION:
• EXCOLLECTION:
• ON LOAN TO COLLECTION:
• LOT NAME:
• DET BY:
• TAX DONATION CODES: (US IRS DONATION CATEGORIES)
• DATE COLLECTED
• PROCESSED BY and DATE
• NO OF SPECIMENS

This database will allow us to do searches such as:

• 1. All the species (or specimens) from a certain county, province, state, or county.
• 2. All of the States/counties/provinces/countries from which we have a certain species.
• 3. Early and late date information
• 4. Automatic reports for any search perimeter
• 5. IRS tax credit information fro donations.

To view a sample input screen form click here

 
Comments or suggestions to : Bill Mauffray

====================================================================

Return to Odonata Information Network