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=443 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=443SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=215SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=443 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamptophryne' AND (junior_species='boliviana' OR junior_species='boliviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamptophryne' AND (species='boliviana' OR species='boliviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamptophryne' AND (species='boliviana' OR species='boliviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamptophryne' AND (junior_species='boliviana' OR junior_species='boliviana')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='Hamptophryne' AND (species='boliviana' OR species='boliviana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='reichlei' OR junior_species='reichleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='reichlei' OR species='reichleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='reichlei' OR species='reichleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='reichlei' OR junior_species='reichleii')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='Pristimantis' AND (species='reichlei' OR species='reichleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' 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='Leptodactylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' 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='Leptodactylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='carvalhoi' OR junior_species='carvalhoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='carvalhoi' OR species='carvalhoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='carvalhoi' OR species='carvalhoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='carvalhoi' OR junior_species='carvalhoii')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='Pristimantis' AND (species='carvalhoi' OR species='carvalhoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='didymus' OR junior_species='didymus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='didymus' OR species='didymus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='didymus' OR species='didymus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='didymus' OR junior_species='didymus')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='Leptodactylus' AND (species='didymus' OR species='didymus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='buccinator' OR junior_species='buccinator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='buccinator' OR species='buccinator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='buccinator' OR species='buccinator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='buccinator' OR junior_species='buccinator')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='Pristimantis' AND (species='buccinator' OR species='buccinator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomedusa' AND (junior_species='vaillanti' OR junior_species='vaillantii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllomedusa' AND (species='vaillanti' OR species='vaillantii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllomedusa' AND (species='vaillanti' OR species='vaillantii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomedusa' AND (junior_species='vaillanti' OR junior_species='vaillantii')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='Phyllomedusa' AND (species='vaillanti' OR species='vaillantii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='fuscoauratus' OR junior_species='fuscoauratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='fuscoauratus' OR species='fuscoauratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='fuscoauratus' OR species='fuscoauratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='fuscoauratus' OR junior_species='fuscoauratus')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='Anolis' AND (species='fuscoauratus' OR species='fuscoauratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')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='Anolis' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='geographicus' OR junior_species='geographicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='geographicus' OR species='geographicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='geographicus' OR species='geographicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='geographicus' OR junior_species='geographicus')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='Hypsiboas' AND (species='geographicus' OR species='geographicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='ictericus' OR junior_species='ictericus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='ictericus' OR species='ictericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='ictericus' OR species='ictericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='ictericus' OR junior_species='ictericus')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='Scinax' AND (species='ictericus' OR species='ictericus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiasmocleis' AND (junior_species='ventrimaculata' OR junior_species='ventrimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chiasmocleis' AND (species='ventrimaculata' OR species='ventrimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chiasmocleis' AND (species='ventrimaculata' OR species='ventrimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiasmocleis' AND (junior_species='ventrimaculata' OR junior_species='ventrimaculata')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='Chiasmocleis' AND (species='ventrimaculata' OR species='ventrimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='fasciatus' OR junior_species='fasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='fasciatus' OR species='fasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='fasciatus' OR species='fasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='fasciatus' OR junior_species='fasciatus')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='Hypsiboas' AND (species='fasciatus' OR species='fasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='garbei' OR junior_species='garbeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='garbei' OR species='garbeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='garbei' OR species='garbeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='garbei' OR junior_species='garbeii')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='Scinax' AND (species='garbei' OR species='garbeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratophrys' AND (junior_species='cornuta' OR junior_species='cornuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratophrys' AND (species='cornuta' OR species='cornuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratophrys' AND (species='cornuta' OR species='cornuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratophrys' AND (junior_species='cornuta' OR junior_species='cornuta')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='Ceratophrys' AND (species='cornuta' OR species='cornuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Edalorhina' AND (junior_species='perezi' OR junior_species='perezii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Edalorhina' AND (species='perezi' OR species='perezii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Edalorhina' AND (species='perezi' OR species='perezii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Edalorhina' AND (junior_species='perezi' OR junior_species='perezii')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='Edalorhina' AND (species='perezi' OR species='perezii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='leptodactyloides' OR junior_species='leptodactyloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='leptodactyloides' OR species='leptodactyloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='leptodactyloides' OR species='leptodactyloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='leptodactyloides' OR junior_species='leptodactyloides')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='Leptodactylus' AND (species='leptodactyloides' OR species='leptodactyloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='hahneli' OR junior_species='hahnelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameerega' AND (species='hahneli' OR species='hahnelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameerega' AND (species='hahneli' OR species='hahnelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='hahneli' OR junior_species='hahnelii')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='Ameerega' AND (species='hahneli' OR species='hahnelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='allenorum' OR junior_species='allenorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='allenorum' OR species='allenorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='allenorum' OR species='allenorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='allenorum' OR junior_species='allenorum')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='Dendropsophus' AND (species='allenorum' OR species='allenorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='koechlini' OR junior_species='koechlinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='koechlini' OR species='koechlinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='koechlini' OR species='koechlinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='koechlini' OR junior_species='koechlinii')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='Dendropsophus' AND (species='koechlini' OR species='koechlinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='knudseni' OR junior_species='knudsenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='knudseni' OR species='knudsenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='knudseni' OR species='knudsenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='knudseni' OR junior_species='knudsenii')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='Leptodactylus' AND (species='knudseni' OR species='knudsenii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=443 The Ecological Register: Los Amigos Research Center (floodplain along trail)
Los Amigos Research Center (floodplain along trail)
Basic information
Sample name: Los Amigos Research Center (floodplain along trail)

Reference: R. von May and M. A. Donnelly. 2009. Do trails affect relative abundance estimates of rainforest frogs and lizards?. Austral Ecology 34:613-620 [ER 215]
Geography
Country: Peru


Coordinate: 12° 34' S, 70° 6' W
Coordinate basis: stated in text

Geography comments: coordinate stated in text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 26.9

CMT: 22.4

MAP: 1924.0

Habitat comments: "floodplain forest"
climate data based on station 84658 (Puerto Maldonado)

Methods
Life forms: lizards,frogs

Site length: 1000

Sampling methods: line transect

Sample size: 97 individuals

Years: 2003

Sampling comments: 10 100 m transects on major trails

Metadata
Sample number: 443

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-17 12:40:32

Modified: 2014-04-26 10:49:56

Abundance distribution
21 species
9 singletons
total count 97
extrapolated richness: 51.7
Fisher's α: 8.247
geometric series k: 0.8326
Hurlbert's PIE: 0.8017
Shannon's H: 2.2494
Good's u: 0.9081
Each square represents a species. Square sizes are proportional to counts.
Register