About this Dataset

Data From: Comparing Three Collection Methods For Pollinating Insects Within Electric Transmission Rights-of-ways

Insect pollinator community data collected from three types of insect traps/collecting methods (colored pan traps, blue vane traps, targeted sweep netting) from four power line right of ways in Alabama. Data are from one growing season (May-October 2018), and collection methods were employed once per month. Data include: 1) insect pollinator community composition data; 2) relative diversity calculations by insect Order; 3) overall insect pollinator community diversity summary by trap type/collecting method and month. These data reflect the community as sampled through different means in the same time period.

Resources in this dataset:

Resource title: Insect Pollinator Community Composition Matrix File name: Pollinator communty matrix.csv Resource description: Pollinator community composition (taxon, abundance) by site, insect trap type, and season. See Supplemental Table 1 in Campbell et al. 2023 for detailed taxa information.
Resource title: Insect Pollinator Community Diversity by Order File name: Pollinator community diversity by Order.csv Resource description: Insect Pollinator community diversity metrics separated by Order for each site, for each insect trap type and season.
Resource title: Summary of Overall Insect Pollinator Community Diversity File name: Overall Pollinator community diversity.csv Resource description: Overall Insect Pollinator community diversity summarized by trap type and season.
Resource title: Dataset key File name: Dataset key table.pdf Resource description: Column titles and variable descriptions for three datasets, of: 1) Pollinator Community Composition; 2) Pollinator Community Diversity by Order; and 3) Overall Pollinator Community Diversity summarized by Trap Type and Season
Organization: Department of Agriculture
Last updated: 2024-04-10T09:13:17.685255
Tags: ars, beneficial-insects, blue-vane-traps, buprestidae, colored-bowl-traps, conopidae, data-gov, native-bees, np304, pollinators, sweep-net-sampling, syphidae, trapping

Tables

Overall Pollinator Community Diversity

@usgov.usda_gov_data_from_comparing_three_collection_methods__8abd1585.overall_pollinator_community_diversity

8.88 kB
12 rows
11 columns

CREATE TABLE overall_pollinator_community_diversity (
  "trap" VARCHAR,
  "catmonth" VARCHAR,
  "coverage" DOUBLE,
  "richness" DOUBLE,
  "hill_shan" DOUBLE,
  "hill_simp" DOUBLE,
  "abundance" BIGINT,
  "cvr_se" DOUBLE,
  "r_se" DOUBLE,
  "shn_se" DOUBLE,
  "simp_se" DOUBLE
);

Pollinator Community Diversity By Order

@usgov.usda_gov_data_from_comparing_three_collection_methods__8abd1585.pollinator_community_diversity_by_order

20.23 kB
66 rows
24 columns

CREATE TABLE pollinator_community_diversity_by_order (
  "site" BIGINT,
  "trap" VARCHAR,
  "catmonth" VARCHAR,
  "month" VARCHAR,
  "diptera" BIGINT,
  "coleoptera" BIGINT,
  "lepidoptera" BIGINT,
  "hy_wasp" BIGINT,
  "hy_bees" BIGINT,
  "r_dip" BIGINT,
  "r_col" BIGINT,
  "r_lep" BIGINT,
  "r_wasp" BIGINT,
  "r_bee" BIGINT,
  "sh_dip" DOUBLE,
  "sh_col" DOUBLE,
  "sh_lep" DOUBLE,
  "sh_wasp" DOUBLE,
  "sh_bee" DOUBLE,
  "si_dip" DOUBLE,
  "si_col" DOUBLE,
  "si_lep" DOUBLE,
  "si_wasp" DOUBLE,
  "si_bee" DOUBLE
);