About this Dataset

Data From: Field Estimates Of Attraction Of Ceratitis Capitata To Trimedlure And Bactrocera Dorsalis (Diptera: Tephritidae) To Methyl Eugenol In Varying Environments

This package includes the data from field experiments to measure the range of attraction of two "male lures" on two different pest fruit fly species via Mark-Release-Recapture (MRR). These values will be of importance to those seeking to optimize fruit fly detection networks or other networks of traps. Methyl eugenol is found to be more attractive to Bactrocera dorsalis compared with trimedlure to Ceratitis capitata. Data consists of number released, proportion responsive, quality control assay results, and recaptures in traps set in a grid pattern after the release.

Resources in this dataset:

Resource Title: Trap positions File Name: coords_grids.csv Resource Description: Lat/long data for each of the traps in the three grids used for MRR experiments.
Resource Title: Temperature and Humidity data for experimental dates in each site File Name: all_weather_data.csv Resource Description: Mean and min/max values of temp and humidity for "Island Princess" and "Puuwaawaa" sites on the dates of experiments.
Resource Title: All trap capture data File Name: all_recapture_data.csv Resource Description: Each row is the number of marked male flies released on a particular date and recaptured in a given trap on a subsequent date.
Resource Title: Metadata File Name: metadata.pdf Resource Description: From a previous package, EML metadata. Useful for reference.
Organization: Department of Agriculture
Last updated: 2024-04-10T09:13:33.061250
Tags: ars, attraction-range, data-gov, mark-release-recapture, np304, pheromone-lure, tephritidae

Tables

All Recapture Data

@usgov.usda_gov_data_from_field_estimates_of_attraction_of_ce_c919d8b8.all_recapture_data

7.54 KB
768 rows
6 columns


CREATE TABLE all_recapture_data (
  "trap" VARCHAR,
  "row" VARCHAR,
  "col" BIGINT,
  "recapture_date" TIMESTAMP,
  "release_date" TIMESTAMP,
  "number" BIGINT
);

All Weather Data

@usgov.usda_gov_data_from_field_estimates_of_attraction_of_ce_c919d8b8.all_weather_data

400.78 KB
13558 rows
16 columns


CREATE TABLE all_weather_data (
  "date_time" TIMESTAMP,
  "dt" BIGINT,
  "mg" BIGINT,
  "tr" BIGINT,
  "ws" DOUBLE,
  "cw" DOUBLE,
  "hw" DOUBLE,
  "tp" DOUBLE,
  "wc" DOUBLE,
  "rh" DOUBLE,
  "hi" DOUBLE,
  "dp" DOUBLE,
  "wb" DOUBLE,
  "bp" DOUBLE,
  "al" BIGINT,
  "da" BIGINT
);