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=424 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=424SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=201SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=424 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglyptodactylus' AND (junior_species='securifer' OR junior_species='securifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglyptodactylus' AND (species='securifer' OR species='securifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglyptodactylus' AND (species='securifer' OR species='securifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglyptodactylus' AND (junior_species='securifer' OR junior_species='securifer')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='Aglyptodactylus' AND (species='securifer' OR species='securifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laliostoma' AND (junior_species='labrosum' OR junior_species='labrosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laliostoma' AND (species='labrosum' OR species='labrosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laliostoma' AND (species='labrosum' OR species='labrosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laliostoma' AND (junior_species='labrosum' OR junior_species='labrosum')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='Laliostoma' AND (species='labrosum' OR species='labrosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stumpffia' 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='Stumpffia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stumpffia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stumpffia' 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='Stumpffia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantella' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantella' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantella' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantella' AND (junior_species='viridis' OR junior_species='viridis')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='Mantella' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='ardouini' OR junior_species='ardouinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiglossus' AND (species='ardouini' OR species='ardouinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiglossus' AND (species='ardouini' OR species='ardouinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiglossus' AND (junior_species='ardouini' OR junior_species='ardouinii')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='ardouini' OR species='ardouinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madascincus' AND (junior_species='intermedius' OR junior_species='intermedius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Madascincus' AND (species='intermedius' OR species='intermedius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Madascincus' AND (species='intermedius' OR species='intermedius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madascincus' AND (junior_species='intermedius' OR junior_species='intermedius')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='Madascincus' AND (species='intermedius' OR species='intermedius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brookesia' AND (junior_species='stumpffi' OR junior_species='stumpffii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brookesia' AND (species='stumpffi' OR species='stumpffii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brookesia' AND (species='stumpffi' OR species='stumpffii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brookesia' AND (junior_species='stumpffi' OR junior_species='stumpffii')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='Brookesia' AND (species='stumpffi' OR species='stumpffii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='petteri' OR junior_species='petterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Furcifer' AND (species='petteri' OR species='petterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Furcifer' AND (species='petteri' OR species='petterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='petteri' OR junior_species='petterii')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='petteri' OR species='petterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blaesodactylus' AND (junior_species='boivini' OR junior_species='boivinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blaesodactylus' AND (species='boivini' OR species='boivinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blaesodactylus' AND (species='boivini' OR species='boivinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blaesodactylus' AND (junior_species='boivini' OR junior_species='boivinii')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='Blaesodactylus' AND (species='boivini' OR species='boivinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geckolepis' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geckolepis' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geckolepis' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geckolepis' AND (junior_species='maculata' OR junior_species='maculata')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='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='heterurus' OR junior_species='heterurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygodactylus' AND (species='heterurus' OR species='heterurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='heterurus' OR species='heterurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='heterurus' OR junior_species='heterurus')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='heterurus' OR species='heterurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroedura' AND (junior_species='stumpffi' OR junior_species='stumpffii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paroedura' AND (species='stumpffi' OR species='stumpffii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paroedura' AND (species='stumpffi' OR species='stumpffii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroedura' AND (junior_species='stumpffi' OR junior_species='stumpffii')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='Paroedura' AND (species='stumpffi' OR species='stumpffii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' 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='Trachylepis' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' 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='Trachylepis' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='tavaratra' OR junior_species='tavaratra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='tavaratra' OR species='tavaratra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='tavaratra' OR species='tavaratra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='tavaratra' OR junior_species='tavaratra')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='Trachylepis' AND (species='tavaratra' OR species='tavaratra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' AND (junior_species='microcephalus' OR junior_species='microcephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Typhlops' AND (species='microcephalus' OR species='microcephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Typhlops' AND (species='microcephalus' OR species='microcephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' AND (junior_species='microcephalus' OR junior_species='microcephalus')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='Typhlops' AND (species='microcephalus' OR species='microcephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' 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='Typhlops' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Typhlops' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' 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='Typhlops' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='braminus' OR junior_species='braminus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphotyphlops' AND (species='braminus' OR species='braminus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphotyphlops' AND (species='braminus' OR species='braminus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='braminus' OR junior_species='braminus')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='Ramphotyphlops' AND (species='braminus' OR species='braminus') 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='Liophidium' AND (junior_species='therezieni' OR junior_species='therezienii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophidium' AND (species='therezieni' OR species='therezienii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophidium' AND (species='therezieni' OR species='therezienii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophidium' AND (junior_species='therezieni' OR junior_species='therezienii')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='therezieni' OR species='therezienii') 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='Pseudoxyrhopus' AND (junior_species='quinquelineatus' OR junior_species='quinquelineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoxyrhopus' AND (species='quinquelineatus' OR species='quinquelineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoxyrhopus' AND (species='quinquelineatus' OR species='quinquelineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoxyrhopus' AND (junior_species='quinquelineatus' OR junior_species='quinquelineatus')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='Pseudoxyrhopus' AND (species='quinquelineatus' OR species='quinquelineatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=424 The Ecological Register: Ampombofofo
Ampombofofo
Basic information
Sample name: Ampombofofo

Reference: S. Megson, P. Mitchell, J. Köhler, C. Marsh, M. Franzen, F. Glaw, and N. D'Cruze. 2009. A comprehensive survey of amphibians and reptiles in the extreme north of Madagascar. Herpetology Notes 2:31-44 [ER 201]
Geography
Country: Madagascar

State: Antsiranana


Coordinate: 12° 5' 53" S, 49° 19' 49" E
Coordinate basis: stated in text

Geography comments: "20 km north of the town of Antsiranana (Diego Suarez)"
coordinate stated in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

WMT: 26.6

CMT: 23.0

MAP: 1379.0

Habitat comments: "large patches of primary western dry forest fringed by primary coastal forest"
"a reliable wet season... followed by a pronounced dry season" of "up to seven months"
MAP figure of 980 mm given in text applies to Antsiranana; climate data are based instead on station 67009 (Antsiranana)

Methods
Life forms: lizards,snakes,frogs

Sampling methods: drift fences,pitfall traps

Sample size: 242 individuals

Years: 2006, 2007

Sampling comments: pitfall traps plus drift fences only

Metadata
Sample number: 424

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-16 08:54:42

Modified: 2014-04-27 00:49:49

Abundance distribution
21 species
8 singletons
total count 242
extrapolated richness: 46.8
Fisher's α: 5.522
geometric series k: 0.7846
Hurlbert's PIE: 0.6573
Shannon's H: 1.6209
Good's u: 0.9671
Each square represents a species. Square sizes are proportional to counts.
Register