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=481 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=481SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=236SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=481 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietophrynus' AND (junior_species='garmani' OR junior_species='garmanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amietophrynus' AND (species='garmani' OR species='garmanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amietophrynus' AND (species='garmani' OR species='garmanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietophrynus' AND (junior_species='garmani' OR junior_species='garmanii')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='Amietophrynus' AND (species='garmani' OR species='garmanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='agama' OR junior_species='agama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agama' AND (species='agama' OR species='agama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agama' AND (species='agama' OR species='agama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='agama' OR junior_species='agama')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='Agama' AND (species='agama' OR species='agama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='mascareniensis' OR junior_species='mascareniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychadena' AND (species='mascareniensis' OR species='mascareniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychadena' AND (species='mascareniensis' OR species='mascareniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='mascareniensis' OR junior_species='mascareniensis')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='Ptychadena' AND (species='mascareniensis' OR species='mascareniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='quinquetaeniata' OR junior_species='quinquetaeniata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='quinquetaeniata' OR species='quinquetaeniata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='quinquetaeniata' OR species='quinquetaeniata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='quinquetaeniata' OR junior_species='quinquetaeniata')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='Mabuya' AND (species='quinquetaeniata' OR species='quinquetaeniata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='planifrons' OR junior_species='planifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='planifrons' OR species='planifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='planifrons' OR species='planifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='planifrons' OR junior_species='planifrons')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='Mabuya' AND (species='planifrons' OR species='planifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='picturatus' OR junior_species='picturatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygodactylus' AND (species='picturatus' OR species='picturatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='picturatus' OR species='picturatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='picturatus' OR junior_species='picturatus')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='Lygodactylus' AND (species='picturatus' OR species='picturatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='anchietae' OR junior_species='anchietae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychadena' AND (species='anchietae' OR species='anchietae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychadena' AND (species='anchietae' OR species='anchietae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='anchietae' OR junior_species='anchietae')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='Ptychadena' AND (species='anchietae' OR species='anchietae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='rueppelli' OR junior_species='rueppellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agama' AND (species='rueppelli' OR species='rueppellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agama' AND (species='rueppelli' OR species='rueppellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='rueppelli' OR junior_species='rueppellii')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='Agama' AND (species='rueppelli' OR species='rueppellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliobolus' AND (junior_species='spekii' OR junior_species='speki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliobolus' AND (species='spekii' OR species='speki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliobolus' AND (species='spekii' OR species='speki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliobolus' AND (junior_species='spekii' OR junior_species='speki')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='Heliobolus' AND (species='spekii' OR species='speki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latastia' AND (junior_species='longicaudata' OR junior_species='longicaudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Latastia' AND (species='longicaudata' OR species='longicaudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Latastia' AND (species='longicaudata' OR species='longicaudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latastia' AND (junior_species='longicaudata' OR junior_species='longicaudata')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='Latastia' AND (species='longicaudata' OR species='longicaudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='mabouia' OR species='mabouia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')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='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygosoma' AND (junior_species='sundevalli' OR junior_species='sundevallii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygosoma' AND (species='sundevalli' OR species='sundevallii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygosoma' AND (species='sundevalli' OR species='sundevallii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygosoma' AND (junior_species='sundevalli' OR junior_species='sundevallii')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='Lygosoma' AND (species='sundevalli' OR species='sundevallii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='brookii' OR junior_species='brooki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='brookii' OR species='brooki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='brookii' OR species='brooki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='brookii' OR junior_species='brooki')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='Hemidactylus' AND (species='brookii' OR species='brooki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietia' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amietia' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amietia' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietia' AND (junior_species='angolensis' OR junior_species='angolensis')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='Amietia' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tomopterna' AND (junior_species='cryptotis' OR junior_species='cryptotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tomopterna' AND (species='cryptotis' OR species='cryptotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tomopterna' AND (species='cryptotis' OR species='cryptotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tomopterna' AND (junior_species='cryptotis' OR junior_species='cryptotis')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='Tomopterna' AND (species='cryptotis' OR species='cryptotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='mababiensis' OR junior_species='mababiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='mababiensis' OR species='mababiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='mababiensis' OR species='mababiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='mababiensis' OR junior_species='mababiensis')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='Phrynobatrachus' AND (species='mababiensis' OR species='mababiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeleo' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chamaeleo' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chamaeleo' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeleo' AND (junior_species='gracilis' OR junior_species='gracilis')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='Chamaeleo' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemisus' AND (junior_species='marmoratus' OR junior_species='marmoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemisus' AND (species='marmoratus' OR species='marmoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemisus' AND (species='marmoratus' OR species='marmoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemisus' AND (junior_species='marmoratus' OR junior_species='marmoratus')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='Hemisus' AND (species='marmoratus' OR species='marmoratus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=481 The Ecological Register: Engare Ondare River
Engare Ondare River
Basic information
Sample name: Engare Ondare River

Reference: L. M. Hardy and A. C. Crnkovic. 2006. Diet of amphibians and reptiles from the Engare Ondare river region of central Kenya, during the dry season. African Journal of Herpetology 55(2):143-159 [ER 236]
Geography
Country: Kenya


Coordinate: 0° 22' N, 37° 25' E
Coordinate basis: estimated from map

Geography comments: coordinate estimated from map in Hardy 1993
elevation 1120 - 1140 m according to Hardy 1993

Environment
Habitat: tropical/subtropical savanna

Altered habitat: pasture

Substrate: ground surface

WMT: 20.6

CMT: 17.1

MAP: 750.0

Habitat comments: "arid scrub dominated by Acacia forest" with intensive goat grazing in the area
precip 0.5 - 1 m; CMT and WMT based on climate station 63740 (Nairobi airport)

Methods
Life forms: lizards,frogs

Sampling methods: no design,hand capture

Sample size: 177 individuals

Years: 1987

Sampling comments: from five separate localities mostly within a few km of each other

Metadata
Sample number: 481

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-19 15:07:37

Modified: 2014-04-26 08:29:53

Abundance distribution
18 species
3 singletons
total count 177
extrapolated richness: 28.2
Fisher's α: 5.010
geometric series k: 0.7926
Hurlbert's PIE: 0.8413
Shannon's H: 2.2258
Good's u: 0.9833
Each square represents a species. Square sizes are proportional to counts.
Register