 | ||||
|
||||
|
|
Database resources used on this site |
Lepidoptera
This is the basic lookup reference for species names used on this site. Included are scientific and vernacular names plus Bradley and Fletcher code numbers for all UK recorded Lepidoptera. Sub-species and forms etc. are excluded. Also provided is a field to identify the micro, macro and butterfly groups.
Field Name | Type (size) | Indexing | Notes |
| Taxon | VARCHAR (64) | Unique Primary Key | Scientific name of species |
| Authority | VARCHAR (64) | Authority for scientific name | |
| Vernacular | VARCHAR (64) | Unique | Common name for species |
| Family | VARCHAR (32) | Family name for species | |
| Type | INT | Non-unique | 0=micro, 1=macro, 2=butterfly |
| BFCode | VARCHAR (5) | Unique | Bradley & Fletcher Code Number |
Sample row:
| Taxon | Authority | Vernacular | Family | Type | BFCode |
|---|---|---|---|---|---|
| Olethreutes schulziana | (Fabricius, 1777) | Tortricidae | 0 | 1073 |
Number of entries: 2637
Source: MapMate 216 with Patches to 334 inclusive. Used with permission.
SomersetList
This is 'The Somerset List' and includes all species of Lepidoptera recorded in VC5 and 6.
The Status description is a short statement based on information in our database. If there are no recent (post 1980) records this is stated. If the species is known from only one record this is shown and annotated if unconfirmed. Otherwise the species is put into 1 of 4 abundance classes (Common, Frequent, Occasional and Rare) and 1 of 4 distribution classes (Widespread, Generally distributed, Local and Very local).
Field Name | Type (size) | Indexing | Notes |
| Taxon | VARCHAR (64) | Unique Primary Key | Scientific name of species |
| Confirmed | CHAR (1) | Non-unique | Y=yes, N=no, indicating that record is confirmed |
| VC5 | CHAR (1) | Non-unique | Y=yes, N=no, indicating recorded in VC5 |
| VC6 | CHAR (1) | Non-unique | Y=yes, N=no, indicating recorded in VC6 |
| Status | VARCHAR (64) | Full Text | Current status of this species |
Sample row:
| Taxon | Confirmed | VC5 | VC6 | Status |
|---|---|---|---|---|
| Idaea dimidiata | Y | Y | Y | Common and widespread |
Number of entries: 1774
Source: Somerset Moth Group Dataset. Draft Issue of 29th March 2006.
Turner
Provides Turner's 1955 checklist with his comments on status. Scientific names are exactly as used in this publication and are resolved using the TurnerTranslation Table. Where Turner has noted that a species perhaps shouldn't be included (i.e. it is enclosed in square brackets in his list) then the comments are annotated with a †.
Field Name | Type (size) | Indexing | Notes |
| ID | INT | Unique Primary Key | ID for this entry being sequence in his list |
| Name | VARCHAR (64) | Unique | Name used for species |
| Authority | VARCHAR (64) | Given author for species name | |
| Page | INT | Page reference for this species | |
| Comments | VARCHAR (255) | Full Text | His status description |
Sample row:
| ID | Name | Authority | Page | Comments |
|---|---|---|---|---|
| 1187 | Elachista gangabella | Zell. | 165 | Recorded from the north of the county many years ago. |
Number of entries: 1434
Source: Turner, A. H., 1955, Lepidoptera of Somerset, Somerset Archaeological and Natural History Society, Taunton. Used with publishers permission. Copyright note: The copyright for this list is, we believe, with the estate of A. H. Turner (1895-1962) until 2038. Although attempts have been made, we have been unable to contact any member of his estate to seek further permission and trust that making his list available in this way is acceptable.
TurnerTranslation
Provides a translation from Turner's 1955 checklist to current valid names (as provided in the Lepidoptera Table). Notes on how the names were interpreted or resolved are provided for each entry.
Field Name | Type (size) | Indexing | Notes |
| Name | VARCHAR (64) | Unique Primary Key | Name used for species by Turner |
| Taxon | VARCHAR (64) | Non-unique | Resolved name for species (Lepidoptera.Taxon) |
| Notes | VARCHAR (255) | Full Text | Note on interpretation of name |
Sample row:
| Name | Taxon | Notes |
|---|---|---|
| Pseudoterpna pruinata | Pseudoterpna pruinata | Valid name. |
Number of entries: 1434
Source: Turner, A. H., 1955, Lepidoptera of Somerset, Somerset Archaeological and Natural History Society, Taunton. See also notes on the Turner Table above.
Records
Provides a summary of all records in the Somerset Moth Group database with date, positional information and further details. Used for distribution mapping, flight-time analysis, what's on the wing etc.
Field Name | Type (size) | Indexing | Notes |
| ID | VARCHAR (16) | Unique Primary Key | Unique MapMate record key |
| Taxon | VARCHAR (64) | Non-unique | Scientific name of species |
| Quantity | INT | Quantity recorded | |
| Sex | CHAR(1) | Sex of taxon (m, f etc) | |
| TaxonStageID | SMALLINT | Non-unique | ID for Stage |
| Xpos | INT | Non-unique | X position (m) centroid |
| Ypos | INT | Non-unique | Y position (m) centroid |
| Prec | SMALLINT | Non-unique | Precision of position (m) |
| Location | VARCHAR (64) | Location for this record | |
| Position | VARCHAR (64) | Geo-position (typically a grid-reference) | |
| VC | VARCHAR (8) | Vice County number (5 or 6) | |
| SiteID | VARCHAR (8) | Non-unique | ID for Site record |
| Recorder | VARCHAR (64) | Recorder for this record | |
| Determiner | VARCHAR (64) | Determiner for this record | |
| Year | SMALLINT | Non-unique | Year of record |
| Date | VARCHAR (16) | Date in conventional format | |
| Week | SMALLINT | Non-unique | Week Number (Standard Weeks) |
| Source | VARCHAR (8) | MapMate CUK of data provider | |
| Version | INT | Record version flag |
Number of entries: 737354
Source: Somerset Moth Group MapMate database. Continually Updated from Hub Database.
|
|