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=438 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=438SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=212SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=438 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='fuscus' OR species='fuscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='fuscus' OR junior_species='fuscus')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='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='labyrinthicus' OR junior_species='labyrinthicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='labyrinthicus' OR species='labyrinthicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='labyrinthicus' OR species='labyrinthicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='labyrinthicus' OR junior_species='labyrinthicus')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='labyrinthicus' OR species='labyrinthicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='podicipinus' OR junior_species='podicipinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='podicipinus' OR species='podicipinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='podicipinus' OR species='podicipinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='podicipinus' OR junior_species='podicipinus')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='podicipinus' OR species='podicipinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='furnarius' OR junior_species='furnarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='furnarius' OR species='furnarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='furnarius' OR species='furnarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='furnarius' OR junior_species='furnarius')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='furnarius' OR species='furnarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopaludicola' AND (junior_species='mystacalis' OR junior_species='mystacalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopaludicola' AND (species='mystacalis' OR species='mystacalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopaludicola' AND (species='mystacalis' OR species='mystacalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopaludicola' AND (junior_species='mystacalis' OR junior_species='mystacalis')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='Pseudopaludicola' AND (species='mystacalis' OR species='mystacalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopaludicola' AND (junior_species='falcipes' OR junior_species='falcipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopaludicola' AND (species='falcipes' OR species='falcipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopaludicola' AND (species='falcipes' OR species='falcipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopaludicola' AND (junior_species='falcipes' OR junior_species='falcipes')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='Pseudopaludicola' AND (species='falcipes' OR species='falcipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='cuvieri' OR junior_species='cuvierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Physalaemus' AND (species='cuvieri' OR species='cuvierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Physalaemus' AND (species='cuvieri' OR species='cuvierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='cuvieri' OR junior_species='cuvierii')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='Physalaemus' AND (species='cuvieri' OR species='cuvierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='centralis' OR junior_species='centralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Physalaemus' AND (species='centralis' OR species='centralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Physalaemus' AND (species='centralis' OR species='centralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='centralis' OR junior_species='centralis')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='Physalaemus' AND (species='centralis' OR species='centralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupemphix' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupemphix' AND (species='nattereri' OR species='nattererii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupemphix' AND (species='nattereri' OR species='nattererii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupemphix' AND (junior_species='nattereri' OR junior_species='nattererii')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='Eupemphix' AND (species='nattereri' OR species='nattererii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='fuscovarius' OR junior_species='fuscovarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='fuscovarius' OR species='fuscovarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='fuscovarius' OR species='fuscovarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='fuscovarius' OR junior_species='fuscovarius')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='fuscovarius' OR species='fuscovarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='similis' OR junior_species='similis')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='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='fuscomarginatus' OR junior_species='fuscomarginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='fuscomarginatus' OR species='fuscomarginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='fuscomarginatus' OR species='fuscomarginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='fuscomarginatus' OR junior_species='fuscomarginatus')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='fuscomarginatus' OR species='fuscomarginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='nanus' OR junior_species='nanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='nanus' OR species='nanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='nanus' OR species='nanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='nanus' OR junior_species='nanus')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='nanus' OR species='nanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='elianeae' OR junior_species='elianeae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='elianeae' OR species='elianeae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='elianeae' OR species='elianeae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='elianeae' OR junior_species='elianeae')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='elianeae' OR species='elianeae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='minutus' OR junior_species='minutus')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='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='albopunctatus' OR junior_species='albopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='albopunctatus' OR species='albopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='albopunctatus' OR species='albopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='albopunctatus' OR junior_species='albopunctatus')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='albopunctatus' OR species='albopunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elachistocleis' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elachistocleis' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elachistocleis' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elachistocleis' AND (junior_species='bicolor' OR junior_species='bicolor')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='Elachistocleis' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='schneideri' OR junior_species='schneiderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='schneideri' OR species='schneiderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='schneideri' OR species='schneiderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='schneideri' OR junior_species='schneiderii')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='Rhinella' AND (species='schneideri' OR species='schneiderii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=438 The Ecological Register: Icem
Icem
Basic information
Sample name: Icem

Reference: R. A. Silva, I. Alves Martins, and D. C. Rossa-Feres. 2008. Bioacústica e sítio de vocalização em taxocenoses de anuros de área aberta no noroeste paulista. Biota Neotropica 8(3):123-134 [ER 212]
Geography
Country: Brazil

State: Sao Paulo


Coordinate: 20° 20' 31" S, 49° 11' 42" W
Coordinate basis: stated in text

Geography comments: coordinate given in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: pasture

Substrate: water edge

MAT: 25.0

MAP: 1175.0

Habitat comments: "The native vegetation consists of Semi-deciduous Forest and Cerrado patches" and is "heavily devastated by agriculture, due to its fertile soil" and these sites are in pastures (Silva et al. 2011)
Köppen zone Cwa-Aw (between humid subtropical and tropical savanna) with a cold and dry winter
precip given as 1100 to 1250 mm; MAT based on Barbosa et al. (2010, Revista Brasileira de Entomologia)

Methods
Life forms: frogs

Sampling methods: no design,call recordings

Sample size: 284 individuals

Sampling comments: acoustic survey of six ponds

Metadata
Sample number: 438

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-16 22:21:34

Modified: 2015-07-07 06:58:31

Abundance distribution
18 species
1 singleton
total count 284
extrapolated richness: 21.3
Fisher's α: 4.274
geometric series k: 0.8061
Hurlbert's PIE: 0.9078
Shannon's H: 2.5731
Good's u: 0.9965
Each square represents a species. Square sizes are proportional to counts.
Register