Diversity and turnover of wild bee and ornamental plant assemblages in commercial plant nurseries

# Diversity and turnover of wild bee and ornamental plant assemblages in commercial plant nurseries | sheet name | variable name | type of variable | possible values | description of variable | | :--------------- | :------------ | :--------------------- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :-------------------------------------------------------------------------------------------- | | bees | year | factor | 2016, 2017, 2018 | calendar year in which the bee was collected | | season | factor | spring, summer, autumn | season in which the bee was collected | | | nursery.code | factor | various | the nursery at which the bee was collected | | | nursery.nativity | factor | conventional, native | the type of nursery | | | trap.method | factor | bvt, netting | whether the bee was captured via blue vane traps ("bvt") or sweep netting | | | species.code | factor | various | unique code denoting the species of bee | | | remove | factor | \[blank], yes | whether to remove the specimen ("yes") prior to running statistical models on the data; these 11 bees were from blue vane traps that were unintentionally disturbed (knocked over) while deployed, and are thus inappropriate to include in quantitative models | | | plants | year | factor | 2016, 2017, 2018 | calendar year in which the plant was recorded | | season | factor | spring, summer, autumn | season in which the plant was recorded | | | nursery.code | factor | various | the nursery at which the plant was recorded | | | plot | factor | 1 to 12 | the sampling plot at the nursery | | | taxon | factor | various | the plant taxon | | | net\_samplings | year | factor | 2016, 2017, 2018 | calendar year in which the bee was collected | | season | factor | spring, summer, autumn | season in which the bee was collected | | | date.collected | factor | various | calendar date on which bee was collected | | | nursery.code | factor | various | the nursery at which the bee was collected | | | nursery.nativity | factor | conventional, native | the type of nursery | | | temp | numeric | various | temperature (°F) | | | plant.richness | numeric | various | average plot-level blooming plant richness for that sampling event | | | floral.cover | numeric | 0 to 100 | average plot-level % floral cover for that sampling event | | | nat.area.1km | numeric | 0 to 1 | proportion of natural area surrounding nursery at 1-km buffer | | | nursery.area | numeric | various | area of nursery, in hectares (ha) | | | nat.resids | numeric | various | average plot-level proportion of blooming plant richness represented by native taxa (residuals) | | | shannon.index | numeric | various | Shannon diversity index (H') for sweep netted bees | | | evenness | numeric | various | Pielou's evenness index (J') for sweep netted bees | | | bvt\_samplings | year | factor | 2016, 2017, 2018 | calendar year in which the bee was collected | | season | factor | spring, summer, autumn | season in which the bee was collected | | | nursery.code | factor | various | the nursery at which the bee was collected | | | nursery.nativity | factor | conventional, native | the type of nursery | | | retrieve.date | factor | various | calendar date on which vane trap was collected | | | plant.richness | numeric | various | average plot-level blooming plant richness for that sampling event | | | floral.cover | numeric | 0 to 100 | average plot-level % floral cover for that sampling event | | | nat.area.1km | numeric | 0 to 1 | proportion of natural area surrounding nursery at 1-km buffer | | | nursery.area | numeric | various | area of nursery, in hectares (ha) | | | nat.resids | numeric | various | averate plot-level proportion of blooming plant richness represented by native taxa (residuals) | | | temp.resids | numeric | various | temperature (residuals) | | | shannon.div | numeric | various | Shannon diversity index (H') for vane trapped bees | | | evenness | numeric | various | Pielou's evenness index (J') for vane trapped bees | | | turnover | time.numeric | factor | 1 to 7 | earlier of the two seasons being comparied (1=spring 2016, 2=summer 2016, \[…] 7=spring 2018) | | time.numeric2 | factor | 1 to 7 | the latter of two seasons being compared | | | nursery.code | factor | various | the nursery at which seasons are being compared | | | gains\_bees | numeric | various | proportional gains in bee species between time periods | | | losses\_bees | numeric | various | proportional losses in bee species between time periods | | | year | factor | 2016, 2017 | calendar year of earlier time period | | | season | factor | spring, summer, autumn | season of earlier time period | | | nursery.nativity | factor | conventional, native | the type of nursery | | | gains\_plants | numeric | various | proportional gains in blooming plant species between time periods | | | losses\_plants | numeric | various | proportional losses in blooming plant species between time periods | | ## Code/Software This is an optional, freeform section for describing any code in your submission and the software used to run it. Describe any scripts, code, or notebooks (e.g., R, Python, Mathematica, MatLab) as well as the software versions (including loaded packages) that you used to run those files. If your repository contains more than one file whose relationship to other scripts is not obvious, provide information about the workflow that you used to run those scripts and notebooks.

# 商业苗圃中野生蜂类与观赏植物组合的多样性及周转动态
| 工作表名称 | 变量名 | 变量类型 | 可能取值 | 变量说明 |
| :--------- | :--------------------- | :--------------------- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :-------------------------------------------------------------------------------------------- |
| bees | year | 因子型（factor） | 2016, 2017, 2018 | 野生蜂类的采集公历年份 |
| bees | season | 因子型（factor） | spring, summer, autumn | 野生蜂类的采集季节 |
| bees | nursery.code | 因子型（factor） | various | 野生蜂类采集所在的苗圃编码 |
| bees | nursery.nativity | 因子型（factor） | conventional, native | 苗圃的经营类型 |
| bees | trap.method | 因子型（factor） | bvt, netting | 野生蜂类的捕获方式：蓝色叶片诱捕器（blue vane traps，简称bvt）或扫网法 |
| bees | species.code | 因子型（factor） | various | 野生蜂类物种的唯一编码 |
| bees | remove | 因子型（factor） | [blank], yes | 是否在统计建模前移除该样本：该11头蜂类来自部署时被意外碰倒的蓝色叶片诱捕器，因此不适用于定量建模 |
| plants | year | 因子型（factor） | 2016, 2017, 2018 | 植物记录的公历年份 |
| plants | season | 因子型（factor） | spring, summer, autumn | 植物记录的季节 |
| plants | nursery.code | 因子型（factor） | various | 植物记录所在的苗圃编码 |
| plants | plot | 因子型（factor） | 1 to 12 | 苗圃内的采样样地编号 |
| plants | taxon | 因子型（factor） | various | 植物分类单元 |
| net_samplings | year | 因子型（factor） | 2016, 2017, 2018 | 野生蜂类的采集公历年份 |
| net_samplings | season | 因子型（factor） | spring, summer, autumn | 野生蜂类的采集季节 |
| net_samplings | date.collected | 因子型（factor） | various | 野生蜂类的采集公历日期 |
| net_samplings | nursery.code | 因子型（factor） | various | 野生蜂类采集所在的苗圃编码 |
| net_samplings | nursery.nativity | 因子型（factor） | conventional, native | 苗圃的经营类型 |
| net_samplings | temp | 数值型（numeric） | various | 采集时的温度，单位为华氏度（°F） |
| net_samplings | plant.richness | 数值型（numeric） | various | 该采样事件样地水平的开花植物平均丰富度 |
| net_samplings | floral.cover | 数值型（numeric） | 0 to 100 | 该采样事件样地水平的开花植物平均盖度百分比 |
| net_samplings | nat.area.1km | 数值型（numeric） | 0 to 1 | 苗圃周边1公里缓冲区的自然用地比例 |
| net_samplings | nursery.area | 数值型（numeric） | various | 苗圃面积，单位为公顷（ha） |
| net_samplings | nat.resids | 数值型（numeric） | various | 样地水平开花植物丰富度中本土类群占比的残差项 |
| net_samplings | shannon.index | 数值型（numeric） | various | 扫网捕获蜂类的香农多样性指数（Shannon diversity index，H'） |
| net_samplings | evenness | 数值型（numeric） | various | 扫网捕获蜂类的皮卢均匀度指数（Pielou's evenness index，J'） |
| bvt_samplings | year | 因子型（factor） | 2016, 2017, 2018 | 野生蜂类的采集公历年份 |
| bvt_samplings | season | 因子型（factor） | spring, summer, autumn | 野生蜂类的采集季节 |
| bvt_samplings | nursery.code | 因子型（factor） | various | 野生蜂类采集所在的苗圃编码 |
| bvt_samplings | nursery.nativity | 因子型（factor） | conventional, native | 苗圃的经营类型 |
| bvt_samplings | retrieve.date | 因子型（factor） | various | 蓝色叶片诱捕器的回收公历日期 |
| bvt_samplings | plant.richness | 数值型（numeric） | various | 该采样事件样地水平的开花植物平均丰富度 |
| bvt_samplings | floral.cover | 数值型（numeric） | 0 to 100 | 该采样事件样地水平的开花植物平均盖度百分比 |
| bvt_samplings | nat.area.1km | 数值型（numeric） | 0 to 1 | 苗圃周边1公里缓冲区的自然用地比例 |
| bvt_samplings | nursery.area | 数值型（numeric） | various | 苗圃面积，单位为公顷（ha） |
| bvt_samplings | nat.resids | 数值型（numeric） | various | 样地水平开花植物丰富度中本土类群占比的残差项 |
| bvt_samplings | temp.resids | 数值型（numeric） | various | 温度的残差项 |
| bvt_samplings | shannon.div | 数值型（numeric） | various | 蓝色诱捕器捕获蜂类的香农多样性指数（Shannon diversity index，H'） |
| bvt_samplings | evenness | 数值型（numeric） | various | 蓝色诱捕器捕获蜂类的皮卢均匀度指数（Pielou's evenness index，J'） |
| 无 | turnover | 数值型因子（time.numeric） | 1 to 7 | 待比较的两个季节中较早的一季：1=spring 2016, 2=summer 2016, … 7=spring 2018 |
| 无 | time.numeric2 | 数值型因子 | 1 to 7 | 待比较的两个季节中较晚的一季 |
| 无 | nursery.code | 因子型（factor） | various | 进行季节比较的苗圃编码 |
| 无 | gains_bees | 数值型（numeric） | various | 两个时间段间野生蜂类物种的比例增益 |
| 无 | losses_bees | 数值型（numeric） | various | 两个时间段间野生蜂类物种的比例损失 |
| 无 | year | 因子型（factor） | 2016, 2017 | 较早时间段的公历年份 |
| 无 | season | 因子型（factor） | spring, summer, autumn | 较早时间段的季节 |
| 无 | nursery.nativity | 因子型（factor） | conventional, native | 苗圃的经营类型 |
| 无 | gains_plants | 数值型（numeric） | various | 两个时间段间开花植物物种的比例增益 |
| 无 | losses_plants | 数值型（numeric） | various | 两个时间段间开花植物物种的比例损失 |

## 代码与软件说明
本板块为可选自由格式内容，用于说明提交内容中涉及的代码与运行所用软件。请详细描述所使用的脚本、代码或Notebook（例如R、Python、Mathematica、MatLab）及其版本（包括加载的软件包）。若您的代码仓库包含多个文件且其与其他脚本的关联关系不明确，请说明运行这些脚本与Notebook的完整工作流程。

搜集汇总

背景与挑战

背景概述

该数据集记录了2016年至2018年间美国加州南部13个商业苗圃中野生蜜蜂和开花观赏植物的多样性和周转数据，通过蓝瓶陷阱和扫网法采集。数据集包含多个变量，如季节、苗圃类型、植物丰富度、景观特征等，用于分析本地和景观因素如何影响蜜蜂群落的季节变化，并发现本地植物栽培与蜜蜂多样性呈正相关。