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=559 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=559SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=280SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=559 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anodonthyla' AND (junior_species='boulengeri' OR junior_species='boulengerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anodonthyla' AND (species='boulengeri' OR species='boulengerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anodonthyla' AND (species='boulengeri' OR species='boulengerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anodonthyla' AND (junior_species='boulengeri' OR junior_species='boulengerii')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='Anodonthyla' AND (species='boulengeri' OR species='boulengerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')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='Boophis' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='pyrrhus' OR junior_species='pyrrhus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='pyrrhus' OR species='pyrrhus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='pyrrhus' OR species='pyrrhus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='pyrrhus' OR junior_species='pyrrhus')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='Boophis' AND (species='pyrrhus' OR species='pyrrhus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='betsileanus' OR junior_species='betsileanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='betsileanus' OR species='betsileanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='betsileanus' OR species='betsileanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='betsileanus' OR junior_species='betsileanus')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='Mantidactylus' AND (species='betsileanus' OR species='betsileanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='femoralis' OR junior_species='femoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='femoralis' OR species='femoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='femoralis' OR species='femoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='femoralis' OR junior_species='femoralis')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='Mantidactylus' AND (species='femoralis' OR species='femoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='majori' OR junior_species='majorii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='majori' OR species='majorii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='majori' OR species='majorii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='majori' OR junior_species='majorii')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='Mantidactylus' AND (species='majori' OR species='majorii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='melanopleura' OR junior_species='melanopleura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='melanopleura' OR species='melanopleura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='melanopleura' OR species='melanopleura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='melanopleura' OR junior_species='melanopleura')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='Mantidactylus' AND (species='melanopleura' OR species='melanopleura') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=559 The Ecological Register: Ifanadiana (visual survey)
Ifanadiana (visual survey)
Basic information
Sample name: Ifanadiana (visual survey)

Reference: M. Vences, Y. Chiari, M. Teschke, R.-D. Randrianiaina, L. Raharivololoniaina, P. Bora, D. R. Vieites, and F. Glaw. 2008. Which frogs are out there? A preliminary evaluation of survey techniques and identification reliability of Malagasy amphibians. Monografie del Museo Regionale di Scienze Naturali Amphibians of Madagascar di Torino 45:233-252 [ER 280]
Geography
Country: Madagascar


Coordinate: 21° 21' 13" S, 47° 36' 28" E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Substrate: water edge

Disturbance: selective logging

MAT: 26.8

MAP: 2000.0

Habitat comments: "a stream in highly degraded low-altitude forest"
climate data are based on Ménard et al. (2010, PNAS) and are for Farafangana (altitude 900 m)

Methods
Life forms: frogs

Sampling methods: no design,visual

Sample size: 14 individuals

Metadata
Sample number: 559

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-25 20:42:16

Modified: 2014-07-13 07:19:18

Abundance distribution
7 species
3 singletons
total count 14
extrapolated richness: 20.3
Fisher's α: 5.571
geometric series k: 0.7937
Hurlbert's PIE: 0.8022
Shannon's H: 1.8095
Good's u: 0.8056
Each square represents a species. Square sizes are proportional to counts.
Register