Data and code from: Establishment of a native cavity-nesting bee (Exoneura robusta) after translocation into an urban environment
Data files
May 06, 2026 version files 162.52 KB
-
README.md
10.45 KB
-
Supplementary_Data_Reedbee_2024Dec18.xlsx
9.90 KB
-
Supplementary_Data_Reedbee_2024Sep03.xlsx
9.56 KB
-
Supplementary_Data_Reedbee_2024Sep25.xlsx
9.68 KB
-
Supplementary_Data_Reedbee_2025April14.xlsx
9.70 KB
-
Supplementary_Data_Reedbee_2025August06.xlsx
9.64 KB
-
Supplementary_Data_Reedbee_GLM_analysis_ready.xls
22.02 KB
-
Supplementary_Data_Reedbee2024Nov08.xlsx
9.86 KB
-
Supplementary_Data_Reedbee2024Oct21.xlsx
10.01 KB
-
SupplementaryData_FlowerSurvey_2024Dec_24.xlsx
12.27 KB
-
SupplementaryData_FlowerSurvey_2024Oct_28.xlsx
13.50 KB
-
SupplementaryData_FlowerSurvey_2024Sep25.xlsx
13.28 KB
-
SupplementaryData_FlowerSurvey_2025April14.xlsx
11.01 KB
-
SupplementaryData_FlowerSurvey_2025August_06.xlsx
11.67 KB
Abstract
Urban environments are increasingly considered as potential sites for pollinator conservation, yet quantitative evaluations of insect translocations into cities remain limited. We report the outcome of a small-scale translocation of the native cavity-nesting bee Exoneura robusta from forest habitat into an urban campus in Melbourne, Australia. Adult bees from natural nests were relocated into artificial balsa-wood nests and installed across shaded and open microhabitats within an urban green space. Nest-level success was defined as the presence of brood in the first summer following translocation and the presence of adults the following winter, indicating completion of a full annual cycle. We hypothesized that the native cavity-nesting bee E. robusta can successfully establish in urban environments following translocation, and that nest success is associated with initial adult group size, canopy cover, or local floral richness. Of the eleven artificial nests established, six met this criterion for success. We used binomial generalized linear models to test whether initial adult group size, canopy cover, or local floral richness were associated with nest success. None of the measured variables showed strong support relative to a null model, suggesting that simple nest-level predictors did not explain variation in establishment outcomes within this small experimental dataset. Successful nests occurred across a range of urban microhabitats, including open sites adjacent to built infrastructure and locations beneath dense canopy. Our findings demonstrate that E. robusta can persist for at least one annual cycle following translocation into an urban environment. Although limited in scale, this study provides initial evidence that native cavity-nesting bees can establish within compact urban green spaces and highlights the need for larger experiments incorporating finer-scale biotic and microclimatic measurements.
Dataset DOI: 10.5061/dryad.79cnp5jbf
Description of the data and file structure
This dataset was generated during a small-scale translocation experiment of the native cavity-nesting bee Exoneura robusta from wet eucalypt forest in the Dandenong Ranges (Victoria, Australia) into an urban greenspace at the University of Melbourne’s Burnley Campus.
In August 2024, adult bees from natural stem nests were transferred into 11 standardised artificial balsa-wood nests (1.8 × 1.8 × 30 cm). These nests were installed inside protective “bee towers” at ten sites spanning both shaded (dense canopy) and open (sun-exposed) microhabitats. Nests were monitored at seven time points from August 2024 to August 2025 to assess colony establishment over one full annual cycle.
Key variables in this dataset include:
- Initial Colony Data: Adult group size (total, male, and female counts) at the time of translocation.
- Environmental Data: Canopy cover (estimated from smartphone photographs taken with the phone placed flat directly on the top plane of each tower) and local floral richness (count of flowering entomophilous plant species within a 10 m radius at multiple survey dates).
- Census Data: Repeated counts of adults and brood (eggs, larvae, pupae, callow adults) obtained via non-destructive surface inspections and two comprehensive nest dissections (December 2024 and August 2025).
To maintain colony integrity, all bees were transferred to new identical nests after each dissection. These data underpin the analyses reported in: “Establishment of a native cavity-nesting bee (Exoneura robusta) after translocation into an urban environment” (Research Note).
Files and variables
File: canopy_coveR.xlsx
Description: This file contains canopy cover estimates for the 11 artificial nest sites used in the Exoneura robusta translocation experiment. Canopy cover was estimated from smartphone photographs taken with the phone placed flat directly on the top plane of each bee tower. The photographs were processed using the R package coveR.
The workbook contains two sheets:
“canopy”: Final canopy cover values used for statistical analysis in the research note.
“canopy_photo_in_R”: Raw output from the coveR package image processing.
Variables
Sheet: canopy
- nest_id: Integer. Unique identifier for each artificial nest (1–11).
- canopy: Numeric (0–1). Proportion of canopy cover above the nest (0 = fully open / no canopy, 1 = complete canopy closure). Unitless proportion.
Sheet: canopy_photo_in_R
- FileName: Character. Filename of the original canopy photograph (e.g. _N1.jpg).
- FCOV: Numeric (0–1). Fraction of open canopy / sky visible calculated by coveR.
- GF: Numeric (0–1). Green fraction / vegetation cover proportion calculated by coveR. This column corresponds directly to the final canopy values used in the study.
File: SupplementaryData_FlowerSurvey_2024Dec_24.xlsx
File: SupplementaryData_FlowerSurvey_2024Oct_28.xlsx
File: SupplementaryData_FlowerSurvey_2024Sep25.xlsx
File: SupplementaryData_FlowerSurvey_2025April14.xlsx
File: SupplementaryData_FlowerSurvey_2025August_06.xlsx
Description: These five files contain floral survey data collected at different time points around the 11 artificial bee nest sites. Each file corresponds to one survey date and records all flowering entomophilous (insect-pollinated) plant species within a 10 m radius of each nest tower. These data were used to calculate local floral richness for the analyses in the research note.
Variables (identical structure across all five files):
- Nest_ID: Character. Unique nest identifier (e.g. N1). Blank cells indicate continuation of the plant list for the same nest.
- Common_Name: Character. Common name of the flowering plant species.
- Scientific_Name: Character. Scientific (binomial) name of the plant species (may be blank in some entries).
- Abundance_Range: Character. Estimated abundance category of the species at the site (e.g. “1-10”, “10-100”, “100-1000”, “1000-10000”).
- Abundance_Midpoint: Numeric. Midpoint value of the abundance range.
- Log10_Midpoint: Numeric. Log10-transformed abundance midpoint.
- SUM: Numeric. Total log10-transformed floral abundance index for that nest on the survey date (filled only in the first or last row of each nest group).
Missing values: None (blank cells are used only to indicate continuation of the same nest’s plant list).
File: Supplementary_Data_Reedbee_2024Dec18.xlsx
File: Supplementary_Data_Reedbee_2024Sep03.xlsx
File: Supplementary_Data_Reedbee_2024Sep25.xlsx
File: Supplementary_Data_Reedbee_2025April14.xlsx
File: Supplementary_Data_Reedbee_2025August06.xlsx
File: Supplementary_Data_Reedbee2024Nov08.xlsx
File: Supplementary_Data_Reedbee2024Oct21.xlsx
Description: These seven files contain the raw nest census data for the 11 artificial Exoneura robusta nests across all seven monitoring time points (September 2024 to August 2025). Each file corresponds to one survey date and records the number of adults and brood (pupae, larvae, eggs, callow adults) per nest, along with notes on living/dead individuals and additional observations. These data were used to determine nest success (presence of brood in December 2024 and presence of adults in August 2025) for the analyses in the research note.
Variables (identical structure across all seven files):
- Nest_ID (first column): Character. Nest identifier (N1 to N11).
- Adults: Character / Numeric. Count of adult bees (often recorded as e.g. “F2M3” indicating 2 females + 3 males; blank if zero).
- Pupae: Character / Numeric. Count of pupae.
- Larvae: Character / Numeric. Count of larvae.
- Eggs: Character / Numeric. Count of eggs.
- Callow: Character / Numeric. Count of callow (newly emerged) adults.
Each nest group starts with a header row containing the Nest_ID, followed by three specific rows: Living, Death, and Notes.
- Living: Counts of live individuals in each life stage.
- Death: Counts of dead individuals in each life stage (usually blank).
- Notes: Free-text observations (e.g. “F1M1 in the excavation”, “Not Robusta”, “4 pupae (other bee)”, sex ratios, excavation notes, etc.).
Missing values: Blank cells indicate zero counts or no observation. No “NA” values are used.
File: Supplementary_Data_Reedbee_GLM_analysis_ready.xls
Description: This file is a clean, analysis-ready dataset created by combining the relevant variables from the seven raw Supplementary_Data_Reedbee_*.xlsx files. It contains one row per artificial nest (N1–N11) and was specifically prepared for the binomial generalised linear models (GLMs) of nest success presented in the Research Note. All formatting has been removed and the data are provided in a simple tabular structure.
Variables:
- nest: Character. Nest identifier (N1 to N11).
- init_adult_female: Numeric. Number of adult females at the time of translocation.
- init_adult_male: Numeric. Number of adult males at the time of translocation.
- init_adult_Total: Numeric. Total initial adult colony size (the main predictor used in the GLM).
- canopy: Numeric. Proportion of canopy cover (0–1) estimated from hemispherical photographs taken above each nest.
- flower.richness.index: Numeric. Log-transformed floral richness/abundance index within a 10 m radius of each nest.
- PupLar_Dec: Numeric. Total number of pupae and larvae recorded in December 2024.
- adults_Dec: Numeric. Number of adults recorded in December 2024.
- Adult_Aug: Numeric. Number of adults recorded in August 2025.
- Success: Binary (0/1). Nest success indicator created in the R script (1 = brood present in December 2024 AND at least one adult present in August 2025). This is the response variable used in all binomial GLMs.
This dataset allows direct reproduction of the single-predictor binomial GLMs and AICc model selection reported in the Research Note.
Code/software
Code / Software
All data files are standard Microsoft Excel spreadsheets (.xlsx) and can be opened with any free or open spreadsheet software, including:
- Microsoft Excel
- LibreOffice Calc
- Google Sheets
No proprietary software is required to view the raw data.
All Excel files have been cleaned by removing unnecessary formatting (merged cells, highlighting, colored text, formulas, filtering, frozen panes, etc.) as requested by the Dryad curator. The data content, structure, and values remain completely unchanged.
Statistical analyses were performed in R (version 4.4.0). The following packages were used:
- MuMIn (version 1.48.11) – model selection using AICc
- coveR – processing of canopy photographs to estimate canopy cover
- Base R and standard packages (e.g. stats) for binomial generalised linear models
Workflow summary
- Canopy photographs were processed in R using the coveR package to generate the canopy_coveR.xlsx file.
- Floral survey data were recorded and fully processed in Excel, including calculation of abundance midpoints, log10 transformations, and the nest-level floral richness/abundance index (SUM column). The submitted flower survey files already contain all final calculated values.
- Nest census data from the seven monitoring dates were imported into R to determine nest success (binary outcome) and fit binomial generalised linear models.
Analysis scripts
The complete R analysis scripts are now included with this data deposit (uploaded via Zenodo integration for simultaneous publication).
They reproduce all binomial generalised linear model (GLM) analyses of nest success presented in the Research Note.
Access information
Other publicly accessible locations of the data:
- None. All data are provided exclusively in this data repository.
Data was derived from the following sources:
- Original field surveys and laboratory monitoring conducted by the authors in 2024–2025 at the University of Melbourne Burnley Campus and in the Dandenong Ranges, Victoria, Australia. No third-party or publicly derived datasets were used.
