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=523 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=523SELECT 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=523 ORDER BY register_no ASCSELECT 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geckolepis' 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='Geckolepis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geckolepis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geckolepis' 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='Geckolepis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=523 The Ecological Register: Bevia (cleared)
Bevia (cleared)
Basic information
Sample name: Bevia (cleared)

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

Altered habitat: pasture

Substrate: ground surface

Disturbance: grazing,selective logging

WMT: 27.0

CMT: 22.5

MAP: 700.0

Habitat comments: previously "spiny forest" that has been ">90%... cut down and subsequently burnt or cleared" for "crops" (mostly "planned" at this point) and grazing
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: 87 individuals

Years: 2003

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

Metadata
Sample number: 523

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-22 11:44:35

Modified: 2014-03-22 00:44:35

Abundance distribution
7 species
2 singletons
total count 87
extrapolated richness: 11.3
Fisher's α: 1.794
geometric series k: 0.5774
Hurlbert's PIE: 0.7296
Shannon's H: 1.4609
Good's u: 0.9770
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Mabuya gravenhorstii1
Pareodura androyensis1
Oplurus cyclurus5
Tracheloptychus madagascariensis27
Mabuya elegans27
Pareodura pictus23
Geckolepis sp.3