back
-
Species
Genera Literature Translations -
Images
-
predator-prey database

predator-prey database
by Dr. Robert Lavigne
Download the predator-prey database (4 MB, Excel) - Last saved: October 27 2003

Predator-Prey Database for the family Asilidae (Hexapoda: Diptera)

Prepared by Dr. Robert Lavigne, Professor Emeritus, University of Wyoming, USA
and Dr. Jason Londt (Natal Museum, Pietermaritzburg)

This asilid predator/prey database began life in the original dBase and subsequently evolved through dBase II into dBase V. It was then transformed into Paradox versions 7, 8 and currently 9. It can be downloaded and imported into dBase IV & V, in Paradox 7, 8, 9, in Excel'97 and in Access (MS Office 2000). The database currently contains 13,445 records, most of which were derived from searching through the literature. A few individuals, such as Greg Daniels, have kindly provided me with unpublished records. The database will be intermittently upgraded, as well as corrected, as more prey records becomes available. It is a searchable database with 14 fields as follows: PREDATOR, PREDSPECIES, ORIGDESIGN, ORDER, FAMILY, GENUS, SPECIES, COMONAME, PREDSEX, SOURCE, SOURCE2, COUNTRY, NO.EATEN, CANNIBALISM. Thus, 1/ PREDATOR refers to the genus of the present genus of the asilid, 2/ PREDSPECIES refers to the species and authority of the asilid, 3/ ORIGDESIGN provides the name of the asilid in the original publication, 4-7/ ORDER, FAMILY, GENUS, SPECIES refer to the species of prey [where I am aware that names have changed it is so indicated in this column], 8/ COMONAME refers to common name of the prey [and is not complete], 9/ PREDSEX refers to the sex of the predator [where indicated in the original publication], 10/ SOURCE refers to the original publication, 11/ SOURCE2 contains secondary sources for the same record which was published in a subsequent publication, 12/ COUNTRY refers to the country in which individual records were obtained, 13/ NO.EATEN is included where there are multiple records provided by the original author, 14/ CANNIBALISM is included since there have been many cases of males and/or females feeding members of the same species. Complete literature citations can be obtained by visiting the University of Wyoming web site: at http://www.uwyo.edu/ces/rangemgt.htm and downloading SM-36 and SM-55. You would need Acrobat Reader to read the files, but that can be downloaded free.

Promachus sp. [Skaife et al. 1981]
A syrphid fly as prey of a Promachus sp. [Skaife et al. 1981]

Lavigne, R., S. Dennis and J. A. Gowen. 1978. Asilid literature update 1956-1976 including a brief review of robber fly biology. University of Wyoming Agricultural Experiment Station Science Monograph 36. 134 pp. [Revised slightly in 2000]
Lavigne, R. J. 1999. Bibliography update 1977-1995 for the Asilidae (Insecta: Diptera), including short translations from Japanese and Russian. University of Wyoming Agricultural Experiment Station Science Monograph 55. 91 pp.
Complete literature citations are also available in Fritz Geller-Grimm's literature database, but at this reading, but as of this date, June 2000, multiple publications in the same year are not alphabetically designated, making it impossible to determine which publication contains the prey record. This will be rectified some time this year. It is also hoped that the database will be published on a CD Rom in the future.

Tips: Once downloaded, the database can be searched for individual words by search engines, using the convention: ..word.. In the various versions of Paradox, a 'Query' can be initiated to sort for specific groupings, such as all prey records for a particular family or genus.
In Access 2000, if you right click field title and click on column width, a box appears with a "best fit" option. By clicking on the "best fit" option, all the data in the column becomes visible.

 

Re: Additional projects

A similar database for asilid species dealing with various aspects of biology/behavior is being developed. A paper on courtship behaviour was recently published in Studia Dipterologica as follows: Lavigne, R.J. (2003): Evolution of courtship behaviour among the Asilidae (Diptera), with a review of courtship and mating. - Studia dipterologica 9(2)(2002): 703-742; Halle (Saale).

Records from this predator-prey database can be used without limitation with the proviso that, if recognized, existing errors should be reported to me for the benefit of future users of the database. I would greatly appreciate receiving new records to add to the database [ Send to robertlavigne@bigpond.com]. It is absolutely prohibited to use the offered data for commercial purposes.

Contact:
Dr. Robert Lavigne
P.O. Box 1010
Mount Barker
South Africa 5251
robertlavigne@bigpond.com



back  top 





Contents: Dr. R. Lavigne
Layout: F. Geller-Grimm