| Year | Site | Block | High_Low | Nest_hole_number | Nest_ID | Cell_number | Taxon | Bee_genus | Bee_species | Colour_marking | Individual_code | Approx_date_cell_constructed | Earliest_date_cell_constructed | Latest_date_cell_constructed | Pollen_taxon | Pollen_taxon_simplified | Pollen_family | Major_minor | Observer | Checked_by | Notes | Check_notes | JF_notes |
---|
Column Name: | Year
| Site
| Block
| High_Low
| Nest_hole_number
| Nest_ID
| Cell_number
| Taxon
| Bee_genus
| Bee_species
| Colour_marking
| Individual_code
| Approx_date_cell_constructed
| Earliest_date_cell_constructed
| Latest_date_cell_constructed
| Pollen_taxon
| Pollen_taxon_simplified
| Pollen_family
| Major_minor
| Observer
| Checked_by
| Notes
| Check_notes
| JF_notes
|
Definition: | Year of observation | Two- or three-character site code. See Trapnest coordinates table (above) for interpretation. | Letter code identifier for nesting block ("trapnest"), unique within a site. 14 blocks per site were used at all sites other than RP from 2013 to 2016 (labelled A–N). At the RP site, 24 blocks were used from 2013 to 2015 and 14 blocks in 2016. 12 blocks per site were used at all sites, including RP, from 2017 on (labelled A–L). | For site RP in years 2013-2015, trapnests were attached at two heights to each of 12 trees ("H" = ~1.25 m, "L" = ~0.5 m above ground level) | Normally 1 to 10, corresponding to the 10 holes per nesting block, but later nests constructed in the same nest hole receive a letter suffix, e.g. 7b | Concatenation of site, block, and nest hole number | Brood cell number within a nest. Numbering is sequential, starting with the innermost brood cell (=1). Occasionally, cell numbering was uncertain; these cells are "NA". | Taxon of trap-nest occupant (identified to genus or species) | Genus of the trapnest occupant | Species of the trapnest occupant (sometimes "unknown", "sp." or "NA"; uncertain IDs include a "?") | Colour marking, or combination of colours, applied to the nesting bee. Markings should be unique within an individual site and year. Where multiple colours were used, the order of colours is not meaningful, and different colours are separated here by a "/" or a hyphen. Sometimes the bee’s colour marking was uncertain; this is indicated by "probably", "likely", or "?". | Concatenation of site, bee species, and colour marking. | Estimated date on which the sampled brood cell was constructed. Recorded in 2013-2016; later replaced by the next two columns. | Earliest estimated date on which the brood cell was constructed. Recorded from 2017 on. | Latest estimated date on which the brood cell was constructed. Recorded from 2017 on. | Genus, tribe, or family of the pollen type identified, as entered by the observer. Includes some "?" entries. See footnotes 1-2. | Simplified pollen taxon: "?"s and several other entries changed to "unknown"; pollen types identified to genus changed to tribe IDs where genera can’t be reliably distinguished. This column or the next should be used for analysis. | Plant family to which the pollen taxon belongs. Note that Hydrophyllaceae is treated here as a distinct family (not as a subfamily of Boraginaceae), because pollen of the two taxa can be distinguished. | "Major": the taxon is judged to make up 25% or more of the pollen contents of the sample "Minor": the taxon makes up less than 25% of the sample "Contaminant": the taxon is judged to represent contamination. See footnotes 3-4. | Initials of the person who identified the pollen taxon | Initials of the person who checked the pollen identification | Notes recorded by the Observer during data entry | Notes recorded by the person who checked the pollen identification | Notes entered by J. Forrest |
Storage Type: | float
| string
| string
| string
| string
| string
| float
| string
| string
| string
| string
| string
| dateTime
| dateTime
| dateTime
| string
| string
| string
| string
| string
| string
| string
| string
| string
|
Measurement Type: | ratio | nominal | nominal | nominal | nominal | nominal | ratio | nominal | nominal | nominal | nominal | nominal | dateTime | dateTime | dateTime | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal |
Measurement Values Domain: | Unit | nominalYear | Type | integer |
| Definition | Two- or three-character site code. See Trapnest coordinates table (above) for interpretation. |
| Definition | Letter code identifier for nesting block ("trapnest"), unique within a site. 14 blocks per site were used at all sites other than RP from 2013 to 2016 (labelled A–N). At the RP site, 24 blocks were used from 2013 to 2015 and 14 blocks in 2016. 12 blocks per site were used at all sites, including RP, from 2017 on (labelled A–L). |
| Definition | For site RP in years 2013-2015, trapnests were attached at two heights to each of 12 trees ("H" = ~1.25 m, "L" = ~0.5 m above ground level) |
| Definition | Normally 1 to 10, corresponding to the 10 holes per nesting block, but later nests constructed in the same nest hole receive a letter suffix, e.g. 7b |
| Definition | Concatenation of site, block, and nest hole number |
| Unit | dimensionless | Type | real |
| Definition | Taxon of trap-nest occupant (identified to genus or species) |
| Definition | Genus of the trapnest occupant |
| Definition | Species of the trapnest occupant (sometimes "unknown", "sp." or "NA"; uncertain IDs include a "?") |
| Definition | Colour marking, or combination of colours, applied to the nesting bee. Markings should be unique within an individual site and year. Where multiple colours were used, the order of colours is not meaningful, and different colours are separated here by a "/" or a hyphen. Sometimes the bee’s colour marking was uncertain; this is indicated by "probably", "likely", or "?". |
| Definition | Concatenation of site, bee species, and colour marking. |
| Format | YYYY-MM-DD | Precision | |
| Format | YYYY-MM-DD | Precision | |
| Format | YYYY-MM-DD | Precision | |
| Definition | Genus, tribe, or family of the pollen type identified, as entered by the observer. Includes some "?" entries. See footnotes 1-2. |
| Definition | Simplified pollen taxon: "?"s and several other entries changed to "unknown"; pollen types identified to genus changed to tribe IDs where genera can’t be reliably distinguished. This column or the next should be used for analysis. |
| Definition | Plant family to which the pollen taxon belongs. Note that Hydrophyllaceae is treated here as a distinct family (not as a subfamily of Boraginaceae), because pollen of the two taxa can be distinguished. |
| Definition | "Major": the taxon is judged to make up 25% or more of the pollen contents of the sample "Minor": the taxon makes up less than 25% of the sample "Contaminant": the taxon is judged to represent contamination. See footnotes 3-4. |
| Definition | Initials of the person who identified the pollen taxon |
| Definition | Initials of the person who checked the pollen identification |
| Definition | Notes recorded by the Observer during data entry |
| Definition | Notes recorded by the person who checked the pollen identification |
| Definition | Notes entered by J. Forrest |
|
Missing Value Code: | | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Report: | | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | | | | | | | | | |