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=367 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=367SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=164SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=367 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='maculatus' OR junior_species='maculatus')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='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='togoensis' OR junior_species='togoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='togoensis' OR species='togoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='togoensis' OR species='togoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='togoensis' OR junior_species='togoensis')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='togoensis' OR species='togoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnirana' 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='Amnirana' AND (species='albolabris' OR species='albolabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amnirana' AND (species='albolabris' OR species='albolabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnirana' 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='Amnirana' AND (species='albolabris' OR species='albolabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnirana' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amnirana' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amnirana' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnirana' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Amnirana' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='aequiplicata' OR junior_species='aequiplicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychadena' AND (species='aequiplicata' OR species='aequiplicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychadena' AND (species='aequiplicata' OR species='aequiplicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='aequiplicata' OR junior_species='aequiplicata')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='aequiplicata' OR species='aequiplicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='longirostris' OR junior_species='longirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychadena' AND (species='longirostris' OR species='longirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychadena' AND (species='longirostris' OR species='longirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='longirostris' OR junior_species='longirostris')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='longirostris' OR species='longirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='accraensis' OR junior_species='accraensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='accraensis' OR species='accraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='accraensis' OR species='accraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='accraensis' OR junior_species='accraensis')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='accraensis' OR species='accraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='alleni' OR junior_species='allenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='alleni' OR species='allenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='alleni' OR species='allenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='alleni' OR junior_species='allenii')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='alleni' OR species='allenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='fraterculus' OR junior_species='fraterculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='fraterculus' OR species='fraterculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='fraterculus' OR species='fraterculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='fraterculus' OR junior_species='fraterculus')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='fraterculus' OR species='fraterculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='guineensis' OR junior_species='guineensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='guineensis' OR species='guineensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='guineensis' OR species='guineensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='guineensis' OR junior_species='guineensis')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='guineensis' OR species='guineensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='liberiensis' OR junior_species='liberiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='liberiensis' OR species='liberiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='liberiensis' OR species='liberiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='liberiensis' OR junior_species='liberiensis')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='liberiensis' OR species='liberiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='plicatus' OR junior_species='plicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='plicatus' OR species='plicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='plicatus' OR species='plicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='plicatus' OR junior_species='plicatus')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='plicatus' OR species='plicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='phyllophilus' OR junior_species='phyllophilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='phyllophilus' OR species='phyllophilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='phyllophilus' OR species='phyllophilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='phyllophilus' OR junior_species='phyllophilus')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='phyllophilus' OR species='phyllophilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='tokba' OR junior_species='tokba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='tokba' OR species='tokba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='tokba' OR species='tokba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='tokba' OR junior_species='tokba')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='tokba' OR species='tokba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='villiersi' OR junior_species='villiersii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='villiersi' OR species='villiersii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='villiersi' OR species='villiersii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='villiersi' OR junior_species='villiersii')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='villiersi' OR species='villiersii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astylosternus' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astylosternus' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astylosternus' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astylosternus' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Astylosternus' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthroleptis' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arthroleptis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arthroleptis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthroleptis' AND (junior_species='sp.' OR junior_species='sp.')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='Arthroleptis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthroleptis' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arthroleptis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arthroleptis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthroleptis' AND (junior_species='sp.' OR junior_species='sp.')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='Arthroleptis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardioglossa' AND (junior_species='leucomystax' OR junior_species='leucomystax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardioglossa' AND (species='leucomystax' OR species='leucomystax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardioglossa' AND (species='leucomystax' OR species='leucomystax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardioglossa' AND (junior_species='leucomystax' OR junior_species='leucomystax')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='Cardioglossa' AND (species='leucomystax' OR species='leucomystax') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=367 The Ecological Register: Tai National Park (secondary forest)
Tai National Park (secondary forest)
Basic information
Sample name: Tai National Park (secondary forest)

Reference: R. Ernst and M.-O. Rödel. 2006. Community assembly and structure of tropical leaf-litter amphibians. Ecotropica 12:113-129 [ER 164]
Geography
Country: Ivory Coast


Coordinate: 5° 45' N, 5° 7' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Tai National Park

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Protection: national/state park

Substrate: leaf litter

Disturbance: selective logging

MAT: 25.9

MAP: 1893.0

Habitat comments: leaf litter
disturbance consisted of "selective logging, coffee and cacao plantations"
climate data based on Anderson et al. (2005, Biotropica); daily min/max 21.7/30.1

Methods
Life forms: frogs

Site length: 600

Site width: 1

Sampling methods: belt transect,hand capture

Sample size: 3677 individuals

Years: 1999, 2000

Sampling comments: 6 600 x 1 m transects

Metadata
Sample number: 367

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-13 20:39:06

Modified: 2014-07-13 08:26:26

Abundance distribution
19 species
6 singletons
total count 3677
extrapolated richness: 30.4
Fisher's α: 2.622
geometric series k: 0.6584
Hurlbert's PIE: 0.6549
Shannon's H: 1.3628
Good's u: 0.9984
Each square represents a species. Square sizes are proportional to counts.
Register