DOI: 10.16904/envidat.504
title: 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 repository contains the data for the figures 1-3. 
For Figure 4, part of the data is confidential, Please, refer to the contacts provided:
- For the distribution of hives in Zurich (2018): https://www.zh.ch/de/gesundheitsdirektion/veterinaeramt.html
- For the overheating map of Zurich: Prof. Dr. Eberhard Parlow / Stadt Zurich (https://www.zh.ch/de/umwelt-tiere/umweltschutz/umweltpraxis/definitionsseite/2012/68/zup068_2012_a0030_klimaanalyse-pdf.html)
description: Resource Title: Results literature review
 Size: 55017 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/5ba02a31-5914-4bba-ad65-58cb93030b07/download/20240301_literature_review_paper_selection.csv
 Description: 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.
description: Resource Title: DEPRECATED. Data growth urban beekeeping
 Size: 7219 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/7a0a508a-5b79-4eb6-810d-d75c7aac1ea4/download/20240308_growth_beekeeping.csv
 Description:
description: Resource Title: Coordinates studied cities
 Size: 1626 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/a5320430-d384-4451-8cd7-5dfc49a9b427/download/20240308_cities_coords.csv
 Description: Coordinates (LatLon format) of the cities where data from urban bee ecology studies was used.
description: Resource Title: Proportion honeybees and wildbees
 Size: 7771 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/40fc5176-f9bd-4406-bdaa-ec5777d59bc7/download/20240301_proportion_hb_wb.csv
 Description: Outdated, use the new resource "Propotion urban honeybees and wildbees"
description: Resource Title: Data rank-abundance distribution urban bees
 Size: 501180 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/7ab40a8e-a8b5-45e0-a56c-b3ef34373ed9/download/20240308_rad_bees.csv
 Description: Outdated, use the new resource
description: Resource Title: DEPRECATED. Distirbution beehives among beekeepers
 Size: 17986 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/bb5d9722-2054-4cf3-8c14-8233f78c367a/download/20240417_rad_beehives_beekeepers.csv
 Description: The dataset contains the number of beehives per registered beekeeper ID (annonymised) in four Swiss cities (Bern, Lausanne, Geneve, Zurich).
description: Resource Title: NDVI values within 3 buffers in hives in Zurich
 Size: 17341 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/efd9c5a4-9b8f-4473-b5c6-c6c6c65c22c5/download/ndvi.hives.buffers.csv
 Description: 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
description: Resource Title: Local overheating values within 3 buffers in hives in Zurich
 Size: 23921 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/1362115c-fced-4573-af08-2923b1fcfe5c/download/overwarming.hives.buffers.csv
 Description: 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
description: Resource Title: R script for the figures V1
 Size: 10919 bytes
 Format: application/octet-stream
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/3c95679c-2933-458c-babf-58b043ef7930/download/20240320_cleaned_script_envidat.r
 Description: Deprecated version of the R script
description: Resource Title: R script for the figures V2
 Size: 12560 bytes
 Format: application/octet-stream
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/ce87ae36-0f02-4997-ae60-33dba79604a8/download/20240320_cleaned_script_envidat.r
 Description: R script for the figures
description: Resource Title: Distribution beehives among beekeepers 
 Size: 26599 bytes
 Format: application/vnd.ms-excel
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/5f514458-36af-4c5c-a3b2-fefe670ebdb3/download/20240417_rad_beehives_beekeepers.csv
 Description: The dataset contains the number of beehives per registered beekeeper ID (annonymised) in four Swiss cities (Bern, Lausanne, Geneve, Zurich) and Paris.
description: Resource Title: Data growth urban beekeeping 
 Size: 8945 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/979f7e0b-d069-4f73-8978-da6a25021681/download/20240308_growth_beekeeping.csv
 Description: 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.
description: Resource Title: Proportion urban honeybees and wildbees
 Size: 11547 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/2cbc89cf-9a61-470d-9782-d06683905aec/download/20241201_proportion_hb_wb.csv
 Description: 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
description: Resource Title: Species-abundance data
 Size: 597001 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/152adc29-96fd-4616-851c-39d3e30d159d/resource/017ec9fb-051e-44b5-802b-c2a9ebb519f3/download/20241201_rad_bees.csv
 Description: Abundance data at the species level per used dataset for the rank abundance distribution (RAD).
40 datasets used.