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=1845 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1845SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1637SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1845 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectomys' AND (junior_species='squamipes' OR junior_species='squamipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectomys' AND (species='squamipes' OR species='squamipes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectomys' AND (junior_species='squamipes' OR junior_species='squamipes')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='Nectomys' AND (species='squamipes' OR species='squamipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Necromys' AND (junior_species='lasiurus' OR junior_species='lasiurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Necromys' AND (species='lasiurus' OR species='lasiurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Necromys' AND (junior_species='lasiurus' OR junior_species='lasiurus')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='Necromys' AND (species='lasiurus' OR species='lasiurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='rattus' OR species='rattus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')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='Rattus' AND (species='rattus' OR species='rattus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='albiventris' OR junior_species='albiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didelphis' AND (species='albiventris' OR species='albiventris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='albiventris' OR junior_species='albiventris')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='Didelphis' AND (species='albiventris' OR species='albiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monodelphis' AND (junior_species='domestica' OR junior_species='domestica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monodelphis' AND (species='domestica' OR species='domestica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monodelphis' AND (junior_species='domestica' OR junior_species='domestica')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='Monodelphis' AND (species='domestica' OR species='domestica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' 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='Marmosa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmosa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' 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='Marmosa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryoryzomys' AND (junior_species='lamia' OR junior_species='lamia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euryoryzomys' AND (species='lamia' OR species='lamia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euryoryzomys' AND (species='lamia' OR species='lamia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryoryzomys' AND (junior_species='lamia' OR junior_species='lamia')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='Euryoryzomys' AND (species='lamia' OR species='lamia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerradomys' AND (junior_species='subflavus' OR junior_species='subflavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerradomys' AND (species='subflavus' OR species='subflavus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerradomys' AND (junior_species='subflavus' OR junior_species='subflavus')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='Cerradomys' AND (species='subflavus' OR species='subflavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectomys' 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='Nectomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectomys' 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='Nectomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holochilus' AND (junior_species='sciureus' OR junior_species='sciureus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holochilus' AND (species='sciureus' OR species='sciureus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holochilus' AND (junior_species='sciureus' OR junior_species='sciureus')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='Holochilus' AND (species='sciureus' OR species='sciureus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1845
The Ecological Register: Refrigério and Tranqüilidade
Reference:S. P. Brandão-Filho, F. G. de Carvalho, M. E. F. de Brito, F. A. Almeida, and L. A. Nascimento. 1994. American cutaneous leishmaniasis in Penambuco, Brazil: eco-epidemiological aspects in 'Zona da Mata' region. Memórias do Instituto Oswaldo Cruz89(3):445-449 [ER 1637]
Geography
Country: Brazil
State: Pernambuco
Coordinate:8° 29' S, 35° 35' W
Coordinate basis: stated in text
Geography comments: "includes part of the municipalities of Amaraji and Cortes... Two neighboring localities (Refrigério and Tranqüilidade) were chosen for this study... Refrigério has 295 inhabitants while Tranqüilidade has 210. Most people work in agriculture"
Habitat comments: "sugar-cane, manioc, corn, banana plantations and remainders of Atlantic forest"
climate data are for the Reserva Ecológica Gurjaù and are from Oliveira et al. (2015, Braz J Biol)
Methods
Life forms: rodents,other small mammals
Sampling methods: no design,other traps
Sample size: 478 individuals
Years: 1991
Nets or traps: 65
Net or trap nights: 3425
Sampling comments: "50 standard traps [were used] for small rodents and 15 traps for larger animals... The traps were set 725 times in the domicile area and 2,700 in the extradomicile" (these are apparently trap-night figures)
Metadata
Sample number: 1845
Contributor: John Alroy
Enterer: John Alroy
Created: 2015-12-20 10:36:49
Modified: 2015-12-19 23:36:49
Abundance distribution
10 species
0 singletons
total count 478
extrapolated richness: 10.9
Fisher's α: 1.788
geometric series k: 0.6710
Hurlbert's PIE: 0.7793
Shannon's H: 1.7358
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.