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=2426 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2426SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2300SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2426 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='mcintoshi' OR junior_species='mcintoshii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='mcintoshi' OR species='mcintoshii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='mcintoshi' OR species='mcintoshii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='mcintoshi' OR junior_species='mcintoshii')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='mcintoshi' OR species='mcintoshii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='ochraceus' OR junior_species='ochraceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='ochraceus' OR species='ochraceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='ochraceus' OR species='ochraceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='ochraceus' OR junior_species='ochraceus')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='ochraceus' OR species='ochraceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='tricholabis' OR junior_species='tricholabis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='tricholabis' OR species='tricholabis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='tricholabis' OR species='tricholabis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='tricholabis' OR junior_species='tricholabis')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='tricholabis' OR species='tricholabis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='sudanensis' OR junior_species='sudanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='sudanensis' OR species='sudanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='sudanensis' OR species='sudanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='sudanensis' OR junior_species='sudanensis')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='sudanensis' OR species='sudanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mansonia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mansonia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')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='Mansonia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens' OR junior_species='pipiens')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' OR species='pipiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='pipiens' OR species='pipiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens' OR junior_species='pipiens')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' OR species='pipiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedimorphus' AND (junior_species='vittatus' OR junior_species='vittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedimorphus' AND (species='vittatus' OR species='vittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedimorphus' AND (species='vittatus' OR species='vittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedimorphus' AND (junior_species='vittatus' OR junior_species='vittatus')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='Aedimorphus' AND (species='vittatus' OR species='vittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedimorphus' AND (junior_species='hirsutus' OR junior_species='hirsutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedimorphus' AND (species='hirsutus' OR species='hirsutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedimorphus' AND (species='hirsutus' OR species='hirsutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedimorphus' AND (junior_species='hirsutus' OR junior_species='hirsutus')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='Aedimorphus' AND (species='hirsutus' OR species='hirsutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedeomyia' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedeomyia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedeomyia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedeomyia' AND (junior_species='africana' OR junior_species='africana')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='Aedeomyia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedimorphus' AND (junior_species='tarsalis' OR junior_species='tarsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedimorphus' AND (species='tarsalis' OR species='tarsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedimorphus' AND (species='tarsalis' OR species='tarsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedimorphus' AND (junior_species='tarsalis' OR junior_species='tarsalis')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='Aedimorphus' AND (species='tarsalis' OR species='tarsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedeomyia' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedeomyia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedeomyia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedeomyia' AND (junior_species='africana' OR junior_species='africana')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='Aedeomyia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2426 The Ecological Register: Haney
Haney
Basic information
Sample name: Haney

Reference: S. O. Arum, C. W. Weldon, B. Orindi, T. Landmann, D. P. Tchouassi, H. D. Affognon, and R. Sang. 2015. Distribution and diversity of the vectors of Rift Valley fever along the livestock movement routes in the northeastern and coastal regions of Kenya. Parasites & Vectors 8(294):1-9 [ER 2300]
Geography
Country: Kenya


Coordinate: 0° 29' S, 40° 0' E
Coordinate basis: estimated from map

Geography comments: no details given

Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

Disturbance: grazing

Habitat comments: "This study was conducted along nomadic livestock movement routes (LMR) established by the tracking of a sentinel herd" and the site is "in the semi arid zone (Zone VI), which is characterized bydry woodland vegetation and wooded or bushed grassland. Trees in the semi arid zone are typically Acacia species. The vegetation in this ecological zone is patchily distributed"

Methods
Life forms: mosquitoes

Sites: 1

Sampling methods: no design,baited,light traps

Sample size: 282 individuals

Years: 2012 - 2014

Days: 18

Seasons: wet or monsoon

Nets or traps: 10

Net or trap nights: 180

Sampling comments: "Mosquito surveys were conducted using CO2-baited CDC light traps... during the long rains (April – June) and short rains (November – December)... between November 2012 and August 2014... sampling was conducted three times during the short rains in November and long rainy season between April and May, leading to three replicates for each site per season and a total of six replicates... During each trapping period, ten traps were set at 1800 h and retrieved at 0600 h the following day for three consecutive sampling days at each site"

Metadata
Sample number: 2426

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-28 11:11:07

Modified: 2020-05-29 10:35:20

Abundance distribution
11 species
0 singletons
total count 282
extrapolated richness: 12.2
Fisher's α: 2.279
geometric series k: 0.7201
Hurlbert's PIE: 0.8360
Shannon's H: 2.0354
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register