Environmental Data: Figures perspective urban beekeeping
Description
Data and code from the perspective paper "When honeybees comes to town" The .r file provides the code to generate the figures. In addition, this reposi...
Citation
Casanelles Abella, J., Baldock, K., Leonhardt, S., Moretti, M., Patterson, M., Egerer, M. (2024). Figures perspective urban beekeeping. EnviDat. https://www.doi.org/10.16904/envidat.504.
Resources
Results literature review
The file shows the results from the literature review. Briefly, we searched papers using google scholar search engine using the following query: (“WILD BEE OR WILDBEE”)(“URBAN” OR “CITY”), and limited the time span from 2010-2023. The search query returned 200 candidate papers. In addition, we complemented the candidate papers from the literature research performed by Ferrari & Polidori (2022), adding 22 additional candidate papers. To select papers, we checked that (1) were conducted in urban areas; (2) sampled the whole bee community; (3) provided data on abundance of wildbees; (4) provided data on honeybees; and (5) provided individual abundance data of each wild bee species. The dataset contains the following: -Article_ID: ID for the specific article in the form "A1", "A2"..."An" - Title: of the article - Year: of publication - Journal: of publication - Publisher: - Link: link to the publication - DOI: when applicable - Total abundance wild bees reported: was the total number of collected bees reported? Logical (Y/N) - Honey bee abundance reported: was thenumber of honeybees collected reported? Logical (Y/N) - Abundance per wild bee species: was the number of wildbee species sampled provided? Logical (Y/N) - Select proportion: paper selected to calculate the proportion of honeybees and wildbees. - Select RAD: paper selected to compute the rank-abundance distribution diagram Comment: comments on the papers, data availability, etc.
Results literature reviewDEPRECATED. Data growth urban beekeeping
DEPRECATED. Data growth urban beekeepingCoordinates studied cities
Coordinates (LatLon format) of the cities where data from urban bee ecology studies was used.
Coordinates studied citiesProportion honeybees and wildbees
Outdated, use the new resource "Propotion urban honeybees and wildbees"
Proportion honeybees and wildbeesData rank-abundance distribution urban bees
Outdated, use the new resource
Data rank-abundance distribution urban beesDEPRECATED. Distirbution beehives among beekeepers
The dataset contains the number of beehives per registered beekeeper ID (annonymised) in four Swiss cities (Bern, Lausanne, Geneve, Zurich).
DEPRECATED. Distirbution beehives among beekeepersNDVI values within 3 buffers in hives in Zurich
The dataset contains the average NDVI values around beehives in Zurich at three spatial scales (250, 500 and 1000 m). It contains 3 columns_ - buffer: indicating the spatial scale - ID: hive ID (annonymised) - mean.NDVI: mean NDVI value
NDVI values within 3 buffers in hives in ZurichLocal overheating values within 3 buffers in hives in Zurich
The dataset contains the average overheating values around beehives in Zurich at three spatial scales (250, 500 and 1000 m). It contains 4 columns: - buffer: indicating the spatial scale -ID: hive ID (annonymised) - mean.overwarming: mean overheating value, expressed in degrees Kelvin -mena.overwarming.cor = transformed values do degrees Celsius
Local overheating values within 3 buffers in hives in ZurichR script for the figures V1
Deprecated version of the R script
R script for the figures V1R script for the figures V2
R script for the figures
R script for the figures V2Distribution beehives among beekeepers
The dataset contains the number of beehives per registered beekeeper ID (annonymised) in four Swiss cities (Bern, Lausanne, Geneve, Zurich) and Paris.
Distribution beehives among beekeepersData growth urban beekeeping
The dataset contains the data of the growth of urban beekeeping in different cities. For each city in a given year, it contains the following: Continent. Country. City: the name of the city Year: the year when the information was collected Area: of the city Total N. beekeepers: when available, the estimated number of beekeepers in that city for that given year Total N. hives: when available, the estimated number of beehives in that city for that given year Density: the total number of hives divided by the city area Reference: the source of the information.
Data growth urban beekeepingProportion urban honeybees and wildbees
The dataset contains the proportion of wildbees and honeybees in the different studies obtained from the literature review. Article_ID: ID for each article DOI Authors Year: publication year Duration sampling (years): numerical Start_sampling: numerical, date End_sampling: numerical, date Continent Country N. cities: number of cities sampled in the article. Numerical. City Sampling type: categorical. Levels: active (e.g., Hand-netting); passive (e.g., pantraps. trap-nests); both (combination of passive and active methods). Sampling methodology: categorical. Levels: direct observations, hand-netting, pantraps, interception traps, vane traps. Number sites: total number of study sites. Abundance honeybees: number of honeybees recorded Abundance wild bees: number of wildbees recorded Total bees: total number of bees recorded. Proportion honeybees: Abundance of honeybees / Total number of bees Proportion wildbees: Abundance of wildbees / Total number of bees
Proportion urban honeybees and wildbeesSpecies-abundance data
Abundance data at the species level per used dataset for the rank abundance distribution (RAD). 40 datasets used.
Species-abundance data