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=2376 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2376SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2276SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2376 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='dominici' OR junior_species='dominicii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='dominici' OR species='dominicii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='dominici' OR species='dominicii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='dominici' OR junior_species='dominicii')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='dominici' OR species='dominicii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='leucocelaenus' OR junior_species='leucocelaenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='leucocelaenus' OR species='leucocelaenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='leucocelaenus' OR species='leucocelaenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='leucocelaenus' OR junior_species='leucocelaenus')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='leucocelaenus' OR species='leucocelaenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='serratus' OR junior_species='serratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='serratus' OR species='serratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='serratus' OR species='serratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='serratus' OR junior_species='serratus')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='serratus' OR species='serratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='terrens' OR junior_species='terrens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='terrens' OR species='terrens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='terrens' OR species='terrens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='terrens' OR junior_species='terrens')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='terrens' OR species='terrens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='boliviensis' OR junior_species='boliviensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='boliviensis' OR species='boliviensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='boliviensis' OR species='boliviensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='boliviensis' OR junior_species='boliviensis')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='boliviensis' OR species='boliviensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haemagogus' AND (junior_species='capricornii' OR junior_species='capricorni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haemagogus' AND (species='capricornii' OR species='capricorni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haemagogus' AND (species='capricornii' OR species='capricorni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haemagogus' AND (junior_species='capricornii' OR junior_species='capricorni')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='Haemagogus' AND (species='capricornii' OR species='capricorni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='ferox' OR junior_species='ferox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psorophora' AND (species='ferox' OR species='ferox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psorophora' AND (species='ferox' OR species='ferox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='ferox' OR junior_species='ferox')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='Psorophora' AND (species='ferox' OR species='ferox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='cyaneus' OR junior_species='cyaneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sabethes' AND (species='cyaneus' OR species='cyaneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sabethes' AND (species='cyaneus' OR species='cyaneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='cyaneus' OR junior_species='cyaneus')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='Sabethes' AND (species='cyaneus' OR species='cyaneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='belisarioi' OR junior_species='belisarioii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sabethes' AND (species='belisarioi' OR species='belisarioii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sabethes' AND (species='belisarioi' OR species='belisarioii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='belisarioi' OR junior_species='belisarioii')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='Sabethes' AND (species='belisarioi' OR species='belisarioii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethoides' AND (junior_species='imperfectus' OR junior_species='imperfectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sabethoides' AND (species='imperfectus' OR species='imperfectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sabethoides' AND (species='imperfectus' OR species='imperfectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethoides' AND (junior_species='imperfectus' OR junior_species='imperfectus')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='Sabethoides' AND (species='imperfectus' OR species='imperfectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoprosopon' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichoprosopon' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichoprosopon' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoprosopon' AND (junior_species='spp.' OR junior_species='spp.')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='Trichoprosopon' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='spp.' OR junior_species='spp.')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='Wyeomyia' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2376 The Ecological Register: Villavicencio
Villavicencio
Basic information
Sample name: Villavicencio

Reference: M. Bates. 1944. Observations on the distribution of diurnal mosquitoes in a tropical forest. Ecology 25(2):159-170 [ER 2276]
Geography
Country: Colombia


Coordinate: 4° 9' N, 73° 38' W
Coordinate basis: based on nearby landmark

Geography comments: "Most of the studies... were made in an area of foothill forest which we call La Forzosa" which is in the foothills and others at Ocoa, in the piedmont (coordinate based on Villavicencio)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 24.0

MAP: 4500.0

Habitat comments: "definitely of the rain forest type, with a total precipitation of between four and five meters annually... forest temperatures" have "means between 23º C. and 25º C."; the piedmont forest "probably originally extended from the base of the mountains (elevation about 450 meters above sea level) for about twenty kilometers into the plain... Much of this forest has been cleared in the vicinity of Villavicencio for plantings and pasture... the foothill forest... covers the base of the mountains"

Methods
Life forms: mosquitoes

Sites: 2

Sampling methods: no design,hand capture

Sample size: 7570 individuals

Sampling comments: "Mosquito captures... are made at fixed points... a letter is used to designate a particular tree... Each man catches the mosquitoes that come to him... The mosquitoes are caught separately in glass vials; suction tubes were abandoned because of the danger from Dermatobia"; counts are for two trees each at La Forzosa and Ocoa

Metadata
Sample number: 2376

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-19 13:40:27

Modified: 2016-12-19 02:40:27

Abundance distribution
12 species
0 singletons
total count 7570
extrapolated richness: 12.1
Fisher's α: 1.396
geometric series k: 0.6301
Hurlbert's PIE: 0.6556
Shannon's H: 1.5717
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aedes dominici185
Aedes leucocelaenus143
Aedes serratus299
Aedes terrens26
Anopheles boliviensis314
Haemagogus capricornii4184
Psorophora ferox252
Sabethes cyaneus220
Sabethes belisarioi179
Sabethoides imperfectus454
Trichoprosopon spp.36
Wyeomyia spp.1278