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=3169 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3169SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2964SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3169 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='gratiosa' OR junior_species='gratiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriocnemis' AND (species='gratiosa' OR species='gratiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriocnemis' AND (species='gratiosa' OR species='gratiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='gratiosa' OR junior_species='gratiosa')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='Agriocnemis' AND (species='gratiosa' OR species='gratiosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='glabrum' OR junior_species='glabrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceriagrion' AND (species='glabrum' OR species='glabrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceriagrion' AND (species='glabrum' OR species='glabrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='glabrum' OR junior_species='glabrum')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='Ceriagrion' AND (species='glabrum' OR species='glabrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='commoniae' OR junior_species='commoniae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='commoniae' OR species='commoniae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='commoniae' OR species='commoniae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='commoniae' OR junior_species='commoniae')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='Pseudagrion' AND (species='commoniae' OR species='commoniae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='massaicum' OR junior_species='massaicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='massaicum' OR species='massaicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='massaicum' OR species='massaicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='massaicum' OR junior_species='massaicum')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='Pseudagrion' AND (species='massaicum' OR species='massaicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='glauca' OR junior_species='glauca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='glauca' OR species='glauca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='glauca' OR species='glauca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='glauca' OR junior_species='glauca')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='Elattoneura' AND (species='glauca' OR species='glauca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' 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='Ictinogomphus' AND (species='ferox' OR species='ferox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictinogomphus' AND (species='ferox' OR species='ferox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' 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='Ictinogomphus' AND (species='ferox' OR species='ferox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='farinosa' OR junior_species='farinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesciothemis' AND (species='farinosa' OR species='farinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesciothemis' AND (species='farinosa' OR species='farinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='farinosa' OR junior_species='farinosa')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='Nesciothemis' AND (species='farinosa' OR species='farinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='annulata' OR junior_species='annulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='annulata' OR species='annulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='annulata' OR species='annulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='annulata' OR junior_species='annulata')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='Trithemis' AND (species='annulata' OR species='annulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='arteriosa' OR junior_species='arteriosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='arteriosa' OR species='arteriosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='arteriosa' OR species='arteriosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='arteriosa' OR junior_species='arteriosa')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='Trithemis' AND (species='arteriosa' OR species='arteriosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3169 The Ecological Register: Hunter's Lodge (reservoir, zone 2, 14 April 1991)
Hunter's Lodge (reservoir, zone 2, 14 April 1991)
Basic information
Sample name: Hunter's Lodge (reservoir, zone 2, 14 April 1991)

Reference: P. L. Miller and A. K. Miller. 1991. The dragonflies of Hunter's Lodge, Kenya, 1981-1991. Notulae odonatologicae 3(8):123-129 [ER 2964]
Geography
Country: Kenya


Coordinate: 2° 15' S, 37° 32' E
Coordinate basis: stated in text

Geography comments: "160 km south-east of Nairobi, close to the main road to Mombasa and near Makindu... Observations have been made along the first 0.6 km of the larger stream in the vicinity of a small hotel, Hunter's Lodge"
elevation "just over 900 m"

•
Environment
Habitat: tropical/subtropical savanna

Protection: unprotected

Substrate: ground surface

Habitat comments: "in a region of Guinea savanna... The main rains occur during April and May, with lesser amounts falling in November and December"

Methods
Life forms: odonates

Sampling methods: no design,visual

Sample size: 102 individuals

Days: 1

Sampling comments: no details given, but apparently based on visual survesy

Metadata
Sample number: 3169

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-01-02 19:40:58

Modified: 2019-01-02 08:40:58

Abundance distribution
9 species
3 singletons
total count 102
extrapolated richness: 16.6
Fisher's α: 2.380
geometric series k: 0.6164
Hurlbert's PIE: 0.6904
Shannon's H: 1.4726
Good's u: 0.9708
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Agriocnemis gratiosa1
Ceriagrion glabrum1
Pseudagrion commoniae nigerrimum2
Pseudagrion massaicum1
Elattoneura glauca48
Ictinogomphus ferox7
Nesciothemis farinosa14
Trithemis annulata3
Trithemis arteriosa25