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=2251 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2251SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2213SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2251 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='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='stokesi' OR junior_species='stokesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='stokesi' OR species='stokesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='stokesi' OR species='stokesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='stokesi' OR junior_species='stokesii')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='stokesi' OR species='stokesii') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='vishnui' OR junior_species='vishnuii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='vishnui' OR species='vishnuii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='vishnui' OR species='vishnuii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='vishnui' OR junior_species='vishnuii')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='vishnui' OR species='vishnuii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='tritaeniorhynchus' OR junior_species='tritaeniorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='tritaeniorhynchus' OR species='tritaeniorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='tritaeniorhynchus' OR species='tritaeniorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='tritaeniorhynchus' OR junior_species='tritaeniorhynchus')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='tritaeniorhynchus' OR species='tritaeniorhynchus') 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='Anopheles' AND (junior_species='stephensi' OR junior_species='stephensii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='stephensi' OR species='stephensii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='stephensi' OR species='stephensii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='stephensi' OR junior_species='stephensii')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='stephensi' OR species='stephensii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='culiciformis' OR junior_species='culiciformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='culiciformis' OR species='culiciformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='culiciformis' OR species='culiciformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='culiciformis' OR junior_species='culiciformis')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='culiciformis' OR species='culiciformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='pseudotaeniatus' OR junior_species='pseudotaeniatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='pseudotaeniatus' OR species='pseudotaeniatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='pseudotaeniatus' OR species='pseudotaeniatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='pseudotaeniatus' OR junior_species='pseudotaeniatus')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='pseudotaeniatus' OR species='pseudotaeniatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2251 The Ecological Register: Vellore District
Vellore District
Basic information
Sample name: Vellore District

Reference: . Senthamarai Selvan. 2016. Studies on the mosquito diversity with special reference to dengue vectors in Vellore district, Tamil Nadu, India. International Journal of Zoology and Applied Biosciences 1(1):32-39 [ER 2213]
Geography
Country: India

State: Tamil Nadu


Coordinate: 12° 45' N, 79° 5' E
Coordinate basis: stated in text as range

Geography comments: "in Vellore district, in a total of 10 different pockets (either villages or areas in town or panchayath) under five randomly selected taluks viz., Arakkonam, Katpadi, Gudiyatham, Vellore and Thirupattur... between 12º 15' to 13º 15' North latitude and 78º 20' to 79º 50' East longitude"

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

WMT: 36.8

CMT: 18.2

MAP: 950.0

Habitat comments: "containers, stagnant pools, discarded tyres, cess pits, domestic runoffs and tree holes etc."
climate data are for the Tirupattur region of Vellore District and are from Sajil Kumar et al. (2015, Journal of Geochemical Exploration)

Methods
Life forms: mosquitoes

Sites: 10

Sampling methods: sweep nets,hand capture

Sample size: 696 individuals

Years: 2015

Sampling comments: "adult mosquitoes were collected with the help of suction tube and sweep net. Mosquito collections were carried out... in frequently twice per month between July, 2015 - December, 2015"

Metadata
Sample number: 2251

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-09-04 10:12:01

Modified: 2020-01-14 05:33:58

Abundance distribution
10 species
0 singletons
total count 696
extrapolated richness: 10.3
Fisher's α: 1.654
geometric series k: 0.7489
Hurlbert's PIE: 0.8252
Shannon's H: 1.9758
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register