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=432 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=432SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=208SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=432 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='regularis' OR junior_species='regularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='regularis' OR species='regularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='regularis' OR species='regularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='regularis' OR junior_species='regularis')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='Bufo' AND (species='regularis' OR species='regularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' 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='Bufo' AND (species='vittatus' OR species='vittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='vittatus' OR species='vittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' 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='Bufo' AND (species='vittatus' OR species='vittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='albolabris' OR junior_species='albolabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='albolabris' OR species='albolabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='albolabris' OR species='albolabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='albolabris' OR junior_species='albolabris')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='Hylarana' AND (species='albolabris' OR species='albolabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='kivuensis' OR junior_species='kivuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='kivuensis' OR species='kivuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='kivuensis' OR species='kivuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='kivuensis' OR junior_species='kivuensis')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='Hyperolius' AND (species='kivuensis' OR species='kivuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='nasutus' OR junior_species='nasutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='nasutus' OR species='nasutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='nasutus' OR species='nasutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='nasutus' OR junior_species='nasutus')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='Hyperolius' AND (species='nasutus' OR species='nasutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='quadrivittatus' OR junior_species='quadrivittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='quadrivittatus' OR species='quadrivittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='quadrivittatus' OR species='quadrivittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='quadrivittatus' OR junior_species='quadrivittatus')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='Hyperolius' AND (species='quadrivittatus' OR species='quadrivittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='viridiflavus' OR junior_species='viridiflavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='viridiflavus' OR species='viridiflavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='viridiflavus' OR species='viridiflavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='viridiflavus' OR junior_species='viridiflavus')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='Hyperolius' AND (species='viridiflavus' OR species='viridiflavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='viridiflavus' OR junior_species='viridiflavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='viridiflavus' OR species='viridiflavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='viridiflavus' OR species='viridiflavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='viridiflavus' OR junior_species='viridiflavus')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='Hyperolius' AND (species='viridiflavus' OR species='viridiflavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='natalensis' OR junior_species='natalensis')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='natalensis' OR species='natalensis') 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='Afrana' 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='Afrana' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Afrana' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afrana' 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='Afrana' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplobatrachus' AND (junior_species='occipitalis' OR junior_species='occipitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplobatrachus' AND (species='occipitalis' OR species='occipitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplobatrachus' AND (species='occipitalis' OR species='occipitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplobatrachus' AND (junior_species='occipitalis' OR junior_species='occipitalis')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='Hoplobatrachus' AND (species='occipitalis' OR species='occipitalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=432 The Ecological Register: Lake Nawampasa
Lake Nawampasa
Basic information
Sample name: Lake Nawampasa

Sample aka: Kyoga Lake Basin

Reference: M. Behangana. 2004. The diversity and status of amphibians and reptiles in the Kyoga Lake Basin. African Journal of Ecology 42:51-56 [ER 208]
Geography
Country: Uganda


Coordinate: 1° 16' N, 33° 20' E
Geography comments: coordinate based on Lake Nawampasa

Environment
Habitat: tropical/subtropical wetland

Substrate: water edge

Habitat comments: "a small lake surrounded by swamp vegetation" dominated by Miscanthidium

Methods
Life forms: frogs

Sampling methods: hand capture

Sample size: 100 individuals

Years: 1999

Sampling comments: time constrained counts

Metadata
Sample number: 432

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-16 16:24:07

Modified: 2014-03-16 05:24:07

Abundance distribution
12 species
1 singleton
total count 100
extrapolated richness: 16.9
Fisher's α: 3.561
geometric series k: 0.7135
Hurlbert's PIE: 0.7851
Shannon's H: 1.9703
Good's u: 0.9904
Each square represents a species. Square sizes are proportional to counts.
Register