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=549 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=549SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=274SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=549 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='macrocercus' OR junior_species='macrocercus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiglossus' AND (species='macrocercus' OR species='macrocercus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiglossus' AND (species='macrocercus' OR species='macrocercus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='macrocercus' OR junior_species='macrocercus')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='Amphiglossus' AND (species='macrocercus' OR species='macrocercus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' 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='Amphiglossus' AND (species='melanopleura' OR species='melanopleura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiglossus' AND (species='melanopleura' OR species='melanopleura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' 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='Amphiglossus' AND (species='melanopleura' OR species='melanopleura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='ornaticeps' OR junior_species='ornaticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiglossus' AND (species='ornaticeps' OR species='ornaticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiglossus' AND (species='ornaticeps' OR species='ornaticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='ornaticeps' OR junior_species='ornaticeps')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='Amphiglossus' AND (species='ornaticeps' OR species='ornaticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ebenavia' AND (junior_species='inunguis' OR junior_species='inunguis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ebenavia' AND (species='inunguis' OR species='inunguis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ebenavia' AND (species='inunguis' OR species='inunguis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ebenavia' AND (junior_species='inunguis' OR junior_species='inunguis')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='Ebenavia' AND (species='inunguis' OR species='inunguis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Furcifer' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Furcifer' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='lateralis' OR junior_species='lateralis')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='Furcifer' AND (species='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='oustaleti' OR junior_species='oustaletii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Furcifer' AND (species='oustaleti' OR species='oustaletii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Furcifer' AND (species='oustaleti' OR species='oustaletii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='oustaleti' OR junior_species='oustaletii')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='Furcifer' AND (species='oustaleti' OR species='oustaletii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mercatorius' OR junior_species='mercatorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='mercatorius' OR species='mercatorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='mercatorius' OR species='mercatorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mercatorius' OR junior_species='mercatorius')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='mercatorius' OR species='mercatorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophidium' AND (junior_species='torquatum' OR junior_species='torquatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophidium' AND (species='torquatum' OR species='torquatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophidium' AND (species='torquatum' OR species='torquatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophidium' AND (junior_species='torquatum' OR junior_species='torquatum')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='Liophidium' AND (species='torquatum' OR species='torquatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' 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='Lygodactylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' 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='Lygodactylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='elegans' OR junior_species='elegans')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='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='gravenhorstii' OR junior_species='gravenhorsti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='gravenhorstii' OR species='gravenhorsti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='gravenhorstii' OR species='gravenhorsti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='gravenhorstii' OR junior_species='gravenhorsti')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='gravenhorstii' OR species='gravenhorsti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madagascarophis' AND (junior_species='colubrinus' OR junior_species='colubrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Madagascarophis' AND (species='colubrinus' OR species='colubrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Madagascarophis' AND (species='colubrinus' OR species='colubrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madagascarophis' AND (junior_species='colubrinus' OR junior_species='colubrinus')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='Madagascarophis' AND (species='colubrinus' OR species='colubrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimophis' AND (junior_species='mahfalensis' OR junior_species='mahfalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimophis' AND (species='mahfalensis' OR species='mahfalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimophis' AND (species='mahfalensis' OR species='mahfalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimophis' AND (junior_species='mahfalensis' OR junior_species='mahfalensis')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='Mimophis' AND (species='mahfalensis' OR species='mahfalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='lineata' OR junior_species='lineata')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='Phelsuma' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='modesta' OR junior_species='modesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='modesta' OR species='modesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='modesta' OR species='modesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='modesta' OR junior_species='modesta')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='Phelsuma' AND (species='modesta' OR species='modesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='quadriocellata' OR junior_species='quadriocellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='quadriocellata' OR species='quadriocellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='quadriocellata' OR species='quadriocellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='quadriocellata' OR junior_species='quadriocellata')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='Phelsuma' AND (species='quadriocellata' OR species='quadriocellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterixalus' AND (junior_species='boettgeri' OR junior_species='boettgerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterixalus' AND (species='boettgeri' OR species='boettgerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterixalus' AND (species='boettgeri' OR species='boettgerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterixalus' AND (junior_species='boettgeri' OR junior_species='boettgerii')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='Heterixalus' AND (species='boettgeri' OR species='boettgerii') 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='bicalcaratus' OR junior_species='bicalcaratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='bicalcaratus' OR species='bicalcaratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='bicalcaratus' OR species='bicalcaratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='bicalcaratus' OR junior_species='bicalcaratus')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='bicalcaratus' OR species='bicalcaratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' 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='Mantidactylus' AND (species='boulengeri' OR species='boulengerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='boulengeri' OR species='boulengerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' 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='Mantidactylus' AND (species='boulengeri' OR species='boulengerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='depressiceps' OR junior_species='depressiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='depressiceps' OR species='depressiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='depressiceps' OR species='depressiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='depressiceps' OR junior_species='depressiceps')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='depressiceps' OR species='depressiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='punctatus' OR junior_species='punctatus')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='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=549 The Ecological Register: Mandena (1999)
Mandena (1999)
Basic information
Sample name: Mandena (1999)

Reference: R. M. Lehtinen, J.-B. Ramanamanjato, and J. G. Raveloarison. 2003. Edge effects and extinction proneness in a herpetofauna from Madagascar. Biodiversity and Conservation 12:1357-1370 [ER 274]
Geography
Country: Madagascar


Coordinate: 24° 57' S, 47° 2' E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Substrate: ground surface

Disturbance: recent fire,grazing,selective logging

MAT: 26.8

MAP: 1750.0

Habitat comments: "historically littoral (coastal) rainforest" but now "littoral rainforest fragments in a matrix of extremely degraded anthropogenic sand-scrub" that results from "forest clearing, burning, and attempts at cattle grazing"
precip 1500 -2000
MAT is for Farafangana and is from Ménard et al. (2010, PNAS)

Methods
Life forms: lizards,snakes,frogs

Sampling methods: belt transect,auditory,hand capture,visual

Sample size: 334 captures or sightings

Years: 1999

Sampling comments: 50 x 6 m transects with visual and auditory searches and hand capturing with all specimens released except for vouchers; the number of transects in 1999 is not clear

Metadata
Sample number: 549

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-24 20:22:47

Modified: 2014-07-13 07:20:00

Abundance distribution
22 species
1 singleton
total count 334
extrapolated richness: 26.8
Fisher's α: 5.286
geometric series k: 0.8285
Hurlbert's PIE: 0.9213
Shannon's H: 2.7541
Good's u: 0.9970
Each square represents a species. Square sizes are proportional to counts.
Register