BugsCEP Home

The Database

The BugsCEP software package consists of two main files:
- BugsCEP, software which contains the forms, queries and code that make up the user interface
- Bugsdata, the database which contains almost all of the actual data.
The latter is a relational database built in MS Access 2000, with about 43 tables which contain the data enumerated below.

The setup program will also install a number of support files as needed, including those necessary to run an Access database on a PC without the full software installed.

The vast majority of data has been input by Paul Buckland, including the extensive recent database update (see below).

Current geographical scope (but all data are welcome)


Map display from SEAD which uses Google maps © (Please note that this map is not always updated with the lateset data!)

Data (at time of writing - constantly increasing) - UPDATED 31st August 2012

Species related

  • 10506 Taxa
  • 6402 Synonyms
  • 803 Records of species association
  • 1748 UK RDB rarity records
  • 9143 Species attribute records (mainly size data)
Bibliographic

Fossil record and other sample based

  • 1103 Sites
  • 1192 abundance datasets/countsheets
  • 149210 Fossil record entries (which make up the 1192 countsheets)
  • 8474 Recorded dates of which: 1002 radiometric; 6218 period; 1254 calendar

Climate and Ecology

  • 436 MCR thermal envelopes
  • 29835 Ecology text excerpts
  • 30488 Distribution text excerpts
  • 8578 BugsEcoCode assignments
  • 13935 Koch Ecology Code assignments
  • 9867 UK Monthly activity records

Other

  • 400 Identification keys (by Peter Skidmore)

Click here to go to the BugsCEP download page.

Last edited:
April 15th 2011