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=2252 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2252SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2214SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2252 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='aegypti' OR junior_species='aegyptii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='aegypti' OR species='aegyptii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='aegypti' OR species='aegyptii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='aegypti' OR junior_species='aegyptii')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='aegypti' OR species='aegyptii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='subpictus' OR junior_species='subpictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='subpictus' OR species='subpictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='subpictus' OR species='subpictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='subpictus' OR junior_species='subpictus')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='subpictus' OR species='subpictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Armigeres' AND (junior_species='subalbatus' OR junior_species='subalbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Armigeres' AND (species='subalbatus' OR species='subalbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Armigeres' AND (species='subalbatus' OR species='subalbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Armigeres' AND (junior_species='subalbatus' OR junior_species='subalbatus')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='Armigeres' AND (species='subalbatus' OR species='subalbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='quinquefasciatus' OR junior_species='quinquefasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='quinquefasciatus' OR species='quinquefasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='quinquefasciatus' OR species='quinquefasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='quinquefasciatus' OR junior_species='quinquefasciatus')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='quinquefasciatus' OR species='quinquefasciatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2252 The Ecological Register: Keela Arunachalapuram (September 2007)
Keela Arunachalapuram (September 2007)
Basic information
Sample name: Keela Arunachalapuram (September 2007)

Reference: S. Chandrasekar, C. Sundaravadivelan, S. P. Sevarkodiyone, M. Mariselvan, and U. Ramesh. 2012. Study on the density of mosquitoes in a dry area from Keela Arunachalapuram, Vilathikulam Taluk, Tamil Nadu, India. International Journal of Environmental Sciences 2(4):2167-2172 [ER 2214]
Geography
Country: India

State: Tamil Nadu


Coordinate: 9° 19' N, 78° 11' E
Coordinate basis: based on nearby landmark

Geography comments: in "Vilathikulam Taluk, Thoothukudi District" (coordinate based on Keela Arunachalapuram)

•
Environment
Habitat: tropical/subtropical savanna

Altered habitat: cropland

Protection: unprotected

Substrate: ground surface

MAT: 29.4

MAP: 660.0

Habitat comments: "Keela arunachalapuram is a typical rural area, and also a dry area depends only on rainwater for practicing agricultural activities"
habitat not entirely clear, but Thoothukudi has rainfall in the range of a savanna
climate data are for Kovilpatti and are from Pal et al. (2006, Geoderma)

Methods
Life forms: mosquitoes

Sampling methods: no design

Sample size: 284 individuals

Years: 2007

Sampling comments: "The study was conducted for six months from September 2007 to February 2008... A systematic weekly collection of adult female mosquitoes was made for twelve hours at ground level" (sampling effort and exact methods unclear)

Metadata
Sample number: 2252

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-09-04 10:26:21

Modified: 2020-01-14 07:35:13

Abundance distribution
4 species
0 singletons
total count 284
extrapolated richness: 4.2
Fisher's α: 0.659
geometric series k: 0.4127
Hurlbert's PIE: 0.6522
Shannon's H: 1.1516
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 aegypti9
Anopheles subpictus55
Armigeres subalbatus92
Culex quinquefasciatus128