DOI: 10.16904/envidat.652
title: Data supporting ‘Examining honeybee (Apis mellifera) dominance patterns within urban bee communities worldwide’

description: The following repository contains the data and code to reproduce the figures analyses of the paper "Examining honeybee (Apis mellifera) dominance patterns within urban bee communities worldwide". It contains three datasets and one .R file
---
The data results from a literature review on abundance distribution of urban bee communities worldwide, aiming at obtaining studies reporting total abundances of honeybees and wildbees in a given city, and species abundances of wildbees and honeybees in a given city. 
---
1. **Data**: 
- *20240308_cities_coords.csv*: the data contains the latitude and longitude of the included cities in the study. It is used for making the world map with the cities.
- *20241201_proportion_HB_WB.csv*: the data contains the total wild bee and honeybee abundances per city/urban aggregation, and the proportions.
- *20241201_rad_bees.csv*: the data contains the species abundances per city/urban aggregation
2. **Script**:
- *HoneybeeDominance_Analyses_Figures.R*: the script to run the analyses and make the plots. Analyses were done in R version 4.2.1, using the packages ggplot2, glmmTMB, multcomp, wesanderson, terra.
description: Resource Title: Dataset coordinates study cities
 Size: 2196 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/683ed266-c67f-40db-84cd-e8599f075126/resource/9a73209e-98c0-4fee-a208-c726bf957efa/download/20240308_cities_coords.csv
 Description: The data contains the latitude and longitude of the studied cities / urban aggregations. It contains the following columns:
- Continent
-Country
- City
- Lat: Latitude
- Lon: Longitude
description: Resource Title: Dataset proportion honeybees and wild bees
 Size: 14245 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/683ed266-c67f-40db-84cd-e8599f075126/resource/90c4bffd-bfc1-4100-99f5-a2ad3e9503a8/download/20241201_proportion_hb_wb.csv
 Description: The dataset provide the main features for each included dataset from published and unpublished research works. Each row represents a dataset, which provides bee community data in one city / urban aggregation. Overall, it contains 68 datasets from 46 cities in 15 countries and five continents. The data is organised in the following columns:
- Article_ID: id used in the study 
- DOI: doi of the publication, when available 
- Authors 
- Year: of publication 
- Duration sampling (years) 
- Start_sampling: month of the year 
- End_sampling: month of the year 
- Continent 
- Country 
- N. cities: number of cities included in the publication 
- City 
- Sampling type: active, passive or both 
- Sampling methodology: within each sampling type. 
- Habitats: list of sampling habitats 
- N_habitats: number of sampling habitats 
- Parks_similar: binnary (1 = yes; 0 = no) 
- Agriculture: binnary (1 = yes; 0 = no) 
- Private_gardens: binnary (1 = yes; 0 = no) 
- Green_roofs: binnary (1 = yes; 0 = no) 
- seminatural_natural_wasteland: binnary (1 = yes; 0 = no) 
- other_unspecified: binnary (1 = yes; 0 = no) 
- Number sites 
- Abundance honeybees 
- Abundance wild bees 
- Total bees 
- Proportion honeybees 
- Proportion wildbees 
- Area:. of the studied city/urban aggregation
description: Resource Title: Dataset species abundance
 Size: 598032 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/683ed266-c67f-40db-84cd-e8599f075126/resource/a4e637d3-911b-4806-b0ba-cbbd17a34309/download/20241201_rad_bees.csv
 Description: This data resource provides the individual species abundance per city / urban aggregation. It contains data from 41 datasets from 37 studies collected in 33 cities / urban aggregations. It contains the following columns:
 - Article_ID 
- DOI 
- Authors 
- Year 
- Continent 
- Country 
- City 
- Bee genus 
- Bee species 
- Bee merged 
- Bee full 
- Abundance 
- Bee_ID_per_study: ID for the study
description: Resource Title: R script for analyses and plots
 Size: 17744 bytes
 Format: application/octet-stream
 URL: https://www.envidat.ch/dataset/683ed266-c67f-40db-84cd-e8599f075126/resource/2f39336d-f343-4325-8207-38372826ecf4/download/honeybeedominance_analyses_figures.r
 Description: