exPt1 Aphid Abundance and Plant Damage 2004-2012

Post Date: 16 April 2013

These datasets (2 csv files) are for Katherine Muller. Katherine is mapping aphid infestations in the main common garden (cg1). These files include ant & aphid abundance, plant fitness, and foliar herbivore damage in all experiments in cg1 (excluding the 1999 South garden) from 2004-2012. See metadata from 7 February 2013 post.

1. plant measurement & ant/aphid data
Link to csv: plant & ant/aphid data

2. plant damage data
Link to csv: plant damage data

Post Date: 7 February 2013

These datasets (3 csv files) are for Katherine Muller who is assessing the relationship between aphid abundance,
plant fitness and foliar herbivore damage in experiments 1996, 1997, 1998, and 1999 in cg1.
The datasets include plant measurement and head data from the years 2004-2012.

1. plant measurement & insect data
Link to csv: plant & insect data

row — common garden location coordinate / easting or row coordinate in meters (numeric)
pos — common garden location coordinate / northing or position coordinate in meters (numeric)
cgPlaId — common garden plant Id (numeric)
expNm — experiment name / name of experiment within cg1 (text) *only numeric in this dataset
siteOfOriginPedigree — population of origin / remnant from which maternal plant originated (text)
measureYr — measure year / year plant was observed (numeric)
measureDt — measure data / date plant was measured yyyy-mm-dd (date)
plaStatusDesc — plant status description (text)
basalRosetteCt — basal rosette count (numeric)
floweringRosetteCt — flowering rosette count (numeric)
basalLfCt — basal leaf count (numeric)
longestBasalLf — longest basal leaf (numeric)
longestCaulineLf — longest cauline leaf (numeric)
hdct — head count / if flowering, count of capitula per plant; not including “dud” heads (numeric)
minHdHeight — minimum head height in cm (numeric)
maxHdHeight — maximum head height in cm (numeric)
wrinkledLvsPres — wrinkled leaves present indicator (1 or null; 1=yes) (numeric)
insects — insects present / list of insects separated by “;” generated by multiselection box on data entry form (text) **
**data from the field ‘insects’ are displayed in binary format in the following fields (1=observed, 0=not observed)
ant1 — 1 ant
ant2to10 — 2 to 10 ants
antGT10 — greater than 10 ants
aphid1 — 1 aphid
aphid2to10 — 2 to 10 aphids
aphid11to80 — 11 to 80 aphids
aphidGT80 — greater than 80 aphids
lfMiner — leaf miner
lfRolled — rolled leaf
antNest — ant nest
lfHopper — leaf hopper
pupa — pupa
eggSac — egg sac
beetle
grasshopper
spittle
whtFuzzy — white fuzzy
whtScary — white scary
other(Note) — other insect (see insectsNote)
insectsNote — insects note (text) / description of observed insect not included in multiselection field ‘insects’

2. plant damage data
Link to csv: plant damage data

This file contains foliar damage for LIVING plants in experiments 96-99 measured in the years 2004-2008.
cgPlaId — common garden plant Id (numeric)
measureYr — measure year / year plant was observed (numeric)
nibbles — nibbles present / 1 or null, 1 = yes (numeric)
holes — holes present / 1 or null, 1 = yes (numeric)
wrinkles — wrinkles present / 1 or null, 1 = yes (numeric)
totalMinorInsDam — count of leaves with minor (less than 25% of leaf damaged) insect damage (numeric)
totalHalfGoneInsDam — count of leaves half-gone (25% to 50% of leaf damaged) due to insect damage (numeric)
totalGoneInsDam — count of leaves gone (greater than 50% of leaf damaged) due to insect damage (numeric)
totalMinorOthDam — count of leaves with minor (less than 25% of leaf) damage, not caused by insects or cause unknown (numeric)
totalHalfGoneOthDam — count of leaves half-gone (25% to 50% of leaf) damage, not caused by insects or cause unknown (numeric)
totalGoneOthDam — count of leaves gone (greater than 50% of leaf) damage, not caused by insects or cause unknown (numeric)
totalCrisp — count of crisp leaves (numeric)

3. head data
Link to csv: head data

cgPlaId — common garden plant Id (numeric)
hdMeasureYr — head measure year (numeric)
hdStatus — head status (text)
hdDiseaseTxt — head disease (text)
hdNote — head note (text)
hdUseForCt — head use for count (1 = yes, 0 = no) / duds, vertical development only, etc. not counted in ‘hdct’ (binary)
hdDamageNote — head damage note (text)
hdInsects — head insects present / list of insects separated by “;” generated by multiselection box on data entry form (text) **
hdInsectsNote– head insects note (text) / description of observed insect not included in multiselection field ‘insects’
**data from the field ‘hdInsects’ are displayed in binary format in the following fields (1=observed, 0=not observed)
ant1 — 1 ant
ant2to10 — 2 to 10 ants
antGT10 — greater than 10 ants
aphid1 — 1 aphid
aphid2to10 — 2 to 10 aphids
aphid11to80 — 11 to 80 aphids
aphidGT80 — greater than 80 aphids
antNest — ant nest
whtGunk — white gunk
catFrass — caterpillar frass
thornHopper — thorn hopper
pupa
eggSac — egg sac
beetle
grasshopper
spittle
whtFuzzy — white fuzzy
whtScary — white scary
larva
shieldBug — shield bug
longLeggedBug — long-legged bug
cocoon
other(Note) — other insect (see hdInsectsNote)