SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=2216 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2216SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2186SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2216 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='albopictus' OR junior_species='albopictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='albopictus' OR species='albopictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='albopictus' OR species='albopictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='albopictus' OR junior_species='albopictus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aedes' AND (species='albopictus' OR species='albopictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='vexans' OR junior_species='vexans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='vexans' OR species='vexans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='vexans' OR species='vexans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='vexans' OR junior_species='vexans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aedes' AND (species='vexans' OR species='vexans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='punctipennis' OR junior_species='punctipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='punctipennis' OR species='punctipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='punctipennis' OR species='punctipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='punctipennis' OR junior_species='punctipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='punctipennis' OR species='punctipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='quadrimaculatus' OR junior_species='quadrimaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='quadrimaculatus' OR species='quadrimaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='quadrimaculatus' OR species='quadrimaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='quadrimaculatus' OR junior_species='quadrimaculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='quadrimaculatus' OR species='quadrimaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='walkeri' OR junior_species='walkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='walkeri' OR species='walkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='walkeri' OR species='walkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='walkeri' OR junior_species='walkerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='walkeri' OR species='walkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='erraticus' OR junior_species='erraticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='erraticus' OR species='erraticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='erraticus' OR species='erraticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='erraticus' OR junior_species='erraticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='erraticus' OR species='erraticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens/restuans' OR junior_species='pipiens/restuans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='pipiens/restuans' OR species='pipiens/restuans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='pipiens/restuans' OR species='pipiens/restuans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens/restuans' OR junior_species='pipiens/restuans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='pipiens/restuans' OR species='pipiens/restuans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='restuans' OR junior_species='restuans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='restuans' OR species='restuans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='restuans' OR species='restuans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='restuans' OR junior_species='restuans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='restuans' OR species='restuans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='japonicus' OR junior_species='japonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='japonicus' OR species='japonicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='japonicus' OR species='japonicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='japonicus' OR junior_species='japonicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ochlerotatus' AND (species='japonicus' OR species='japonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='triseriatus' OR junior_species='triseriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='triseriatus' OR species='triseriatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='triseriatus' OR species='triseriatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='triseriatus' OR junior_species='triseriatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ochlerotatus' AND (species='triseriatus' OR species='triseriatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='trivittatus' OR junior_species='trivittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='trivittatus' OR species='trivittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='trivittatus' OR species='trivittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='trivittatus' OR junior_species='trivittatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ochlerotatus' AND (species='trivittatus' OR species='trivittatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2216 The Ecological Register: Spindletop Farm (ground level)
Spindletop Farm (ground level)
Basic information
Sample name: Spindletop Farm (ground level)

Reference: R. T. Trout and G. C. Brown. 2009. Impact of residual insecticide applied to upper story vegetation on resting adult mosquitoes (Diptera: Culicidae). Florida Entomologist 92(1):91-98 [ER 2186]
Geography
Country: United States

State: Kentucky


Coordinate: 38° 4' N, 84° 28' W
Coordinate basis: stated in text

Geography comments: "Kentucky's Mosquito Research Center on Spindletop Farm of Lexington"

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 13.0

MAP: 1166.0

Habitat comments: none given
climate data are for the Spindletop Farm Education and Research Center and are from Iqbal et al. (2013, Plant Soil)

Methods
Life forms: mosquitoes

Sites: 2

Sampling methods: no design,baited,light traps

Sample size: 1251 individuals

Years: 2005

Days: 10

Seasons: summer,autumn

Sampling comments: there were "Two tree lines (~2.5 km apart)... The first tree line was divided into 2 blocks, while the second tree line was divided into 4 blocks... In each plot, 2 weeks before and 8 weeks after treatment, mosquito populations were monitored, totaling 10 sampling weeks (7-VII-7-IX-2005)... populations were monitored weekly with Centers for Disease Control (CDC) miniature light traps... at ground level (1.5 m)" and traps were baited with CO2

Metadata
Sample number: 2216

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-13 17:16:50

Modified: 2016-12-17 10:28:49

Abundance distribution
11 species
3 singletons
total count 1251
extrapolated richness: 17.9
Fisher's α: 1.660
geometric series k: 0.5027
Hurlbert's PIE: 0.3771
Shannon's H: 0.7940
Good's u: 0.9976
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aedes albopictus9
Aedes vexans10
Anopheles punctipennis3
Anopheles quadrimaculatus6
Anopheles walkeri2
Culex erraticus109
Culex pipiens/restuans971
most specimens are presumably pipiens because this is the "prevalent WNV vector"
Culex restuans138
Ochlerotatus japonicus1
Ochlerotatus triseriatus1
Ochlerotatus trivittatus1