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=522 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=522SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=257SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=522 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oplurus' AND (junior_species='saxicola' OR junior_species='saxicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oplurus' AND (species='saxicola' OR species='saxicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oplurus' AND (species='saxicola' OR species='saxicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oplurus' AND (junior_species='saxicola' OR junior_species='saxicola')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='Oplurus' AND (species='saxicola' OR species='saxicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oplurus' AND (junior_species='quadrimaculatus' OR junior_species='quadrimaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oplurus' AND (species='quadrimaculatus' OR species='quadrimaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oplurus' AND (species='quadrimaculatus' OR species='quadrimaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oplurus' AND (junior_species='quadrimaculatus' OR junior_species='quadrimaculatus')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='Oplurus' AND (species='quadrimaculatus' OR species='quadrimaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' 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='Hemidactylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' 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='Hemidactylus' 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='aureopunctata' OR junior_species='aureopunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='aureopunctata' OR species='aureopunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='aureopunctata' OR species='aureopunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='aureopunctata' OR junior_species='aureopunctata')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='aureopunctata' OR species='aureopunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' 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='Phelsuma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' 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='Phelsuma' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='igneocaudatus' OR junior_species='igneocaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiglossus' AND (species='igneocaudatus' OR species='igneocaudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiglossus' AND (species='igneocaudatus' OR species='igneocaudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='igneocaudatus' OR junior_species='igneocaudatus')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='igneocaudatus' OR species='igneocaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Androngo' AND (junior_species='trivittatus' OR junior_species='trivittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Androngo' AND (species='trivittatus' OR species='trivittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Androngo' AND (species='trivittatus' OR species='trivittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Androngo' AND (junior_species='trivittatus' OR junior_species='trivittatus')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='Androngo' AND (species='trivittatus' OR species='trivittatus') 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='Pareodura' AND (junior_species='androyensis' OR junior_species='androyensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareodura' AND (species='androyensis' OR species='androyensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareodura' AND (species='androyensis' OR species='androyensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareodura' AND (junior_species='androyensis' OR junior_species='androyensis')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='Pareodura' AND (species='androyensis' OR species='androyensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oplurus' AND (junior_species='cyclurus' OR junior_species='cyclurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oplurus' AND (species='cyclurus' OR species='cyclurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oplurus' AND (species='cyclurus' OR species='cyclurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oplurus' AND (junior_species='cyclurus' OR junior_species='cyclurus')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='Oplurus' AND (species='cyclurus' OR species='cyclurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tracheloptychus' 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='Tracheloptychus' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tracheloptychus' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tracheloptychus' 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='Tracheloptychus' AND (species='madagascariensis' OR species='madagascariensis') 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='Pareodura' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareodura' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareodura' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareodura' AND (junior_species='pictus' OR junior_species='pictus')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='Pareodura' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=522 The Ecological Register: Bevia (forest)
Bevia (forest)
Basic information
Sample name: Bevia (forest)

Reference: D. M. Scott, D. Brown, S. Mahood, B. Denton, A. Silburn, and F. Rakotondraparany. 2006. The impacts of forest clearance on lizard, small mammal and bird communities in the arid spiny forest, southern Madagascar. Biological Conservation 127(1):72-87 [ER 257]
Geography
Country: Madagascar


Coordinate: 24° 50' S, 46° 27' E
Coordinate basis: stated in text

Geography comments: altitude 0 to 100 m

Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

Disturbance: grazing,selective logging

WMT: 27.0

CMT: 22.5

MAP: 700.0

Habitat comments: "spiny forest" with mostly low-level grazing and wood cutting
CMT min/max 15/30, WMT min/max 21/33
precip "less than 700 mm"

Methods
Life forms: lizards

Sampling methods: timed,drift fences,pitfall traps,visual

Sample size: 198 individuals

Years: 2003

Sampling comments: "drift lines with pitfall trapping and time-constrained searches"

Metadata
Sample number: 522

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-22 11:39:39

Modified: 2014-03-22 00:42:32

Abundance distribution
13 species
3 singletons
total count 198
extrapolated richness: 19.4
Fisher's α: 3.121
geometric series k: 0.6941
Hurlbert's PIE: 0.7604
Shannon's H: 1.8235
Good's u: 0.9848
Each square represents a species. Square sizes are proportional to counts.
Register