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=2840 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2840SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2527SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2840 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caluromys' AND (junior_species='philander' OR junior_species='philander')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caluromys' AND (species='philander' OR species='philander') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caluromys' AND (junior_species='philander' OR junior_species='philander')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='Caluromys' AND (species='philander' OR species='philander') 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='Gracilinanus' AND (junior_species='agilis' OR junior_species='agilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gracilinanus' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gracilinanus' AND (junior_species='agilis' OR junior_species='agilis')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='Gracilinanus' AND (species='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' AND (junior_species='demerarae' OR junior_species='demerarae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmosa' AND (species='demerarae' OR species='demerarae') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' AND (junior_species='demerarae' OR junior_species='demerarae')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='demerarae' OR species='demerarae') 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='Philander' AND (junior_species='opossum' OR junior_species='opossum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philander' AND (species='opossum' OR species='opossum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philander' AND (junior_species='opossum' OR junior_species='opossum')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='Philander' AND (species='opossum' OR species='opossum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calomys' AND (junior_species='callosus' OR junior_species='callosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calomys' AND (species='callosus' OR species='callosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calomys' AND (junior_species='callosus' OR junior_species='callosus')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='Calomys' AND (species='callosus' OR species='callosus') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeamys' AND (junior_species='megacephalus' OR junior_species='megacephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylaeamys' AND (species='megacephalus' OR species='megacephalus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeamys' AND (junior_species='megacephalus' OR junior_species='megacephalus')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='Hylaeamys' AND (species='megacephalus' OR species='megacephalus') 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='Oecomys' AND (junior_species='mamorae' OR junior_species='mamorae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oecomys' AND (species='mamorae' OR species='mamorae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oecomys' AND (species='mamorae' OR species='mamorae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='mamorae' OR junior_species='mamorae')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='Oecomys' AND (species='mamorae' OR species='mamorae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='roberti' OR junior_species='robertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oecomys' AND (species='roberti' OR species='robertii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='roberti' OR junior_species='robertii')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='Oecomys' AND (species='roberti' OR species='robertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoryzomys' AND (junior_species='nigripes' OR junior_species='nigripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligoryzomys' AND (species='nigripes' OR species='nigripes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoryzomys' AND (junior_species='nigripes' OR junior_species='nigripes')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='Oligoryzomys' AND (species='nigripes' OR species='nigripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thrichomys' AND (junior_species='pachyurus' OR junior_species='pachyurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thrichomys' AND (species='pachyurus' OR species='pachyurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thrichomys' AND (species='pachyurus' OR species='pachyurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thrichomys' AND (junior_species='pachyurus' OR junior_species='pachyurus')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='Thrichomys' AND (species='pachyurus' OR species='pachyurus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2840 The Ecological Register: Fazenda Aparecida
Fazenda Aparecida
Basic information
Sample name: Fazenda Aparecida

Sample aka: Pirizal

Reference: M. Aragona and J. Marinho-Filho. 2009. História natural e biologia reprodutiva de marsupiais no Pantanal, Mato Grosso, Brasil. Zoologia 26(2):220-230 [ER 2527]
Geography
Country: Brazil

State: Mato Grosso


Coordinate: 16° 14' 19" S, 56° 22' 51" W
Coordinate basis: stated in text

Geography comments: "a Fazenda Aparecida, Localidade de Pirizal... Município de
Nossa Senhora do Livramento, Pantanal de Poconé"

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 25.8

MAP: 1400.0

Habitat comments: climate data are for "the Pirizal ecoregion" at 16º15'24" S, 56º36'24" W: "The climate is characterized by a pronounced dry season from May to September and a rainy season from October to April. Mean annual precipitation is ca. 1400 mm with maximum rainfall in January and minimum rainfall in July (Fig. 2).
Mean annual temperature is 25.8 °C" (da Cunha and Junk 2004, Applied Vegetation Science)

Methods
Life forms: rodents,other small mammals

Sampling methods: quadrat,baited,cage traps,Sherman traps

Sample size: 729 individuals

Years: 2006, 2007

Net or trap nights: 38635

Sampling comments: "Os marsupiais foram estudados em nove grades amostrais de três fisionomias florestais características da regiäo do Pantanal de Poconé: cambarazal, cordilheira e landi. As coletas ocorreram mensalmente entre fevereiro de 2006 e agosto de 2007, excetuando os meses de janeiro e abril de 2007, totalizando 17 meses... três réplicas em cada tipo de habitat... Cada grade era composta de 100 pontos amostrais (10 x 10) distantes 15 m entre si... As nove grades tiveram a
primeira linha de pontos de armadilhamento nos primeiros 5 m dentro da fisionomia florestal em relaçäo á transiçäo com o campo. Dois modelos de armadilhas de captura viva, tipo sherman (9,5 x 8 x 25 cm, doravante referidas apenas como shermans) e gaiola de gancho (16,5 x 16,5 x 35 cm, doravante referidas apenas como gaiolas), foram utilizadas. Um pedaço de fruta, bana-
na nas shermans e abacaxi nas gaiolas, e uma mistura de pasta de amendoim, fubâ e sardinha foram usados como iscas... Um esforço de 38.635 armadilhas-noite "

Metadata
Sample number: 2840

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-12-02 09:56:15

Modified: 2017-12-01 22:56:15

Abundance distribution
14 species
3 singletons
total count 729
extrapolated richness: 20.0
Fisher's α: 2.458
geometric series k: 0.6560
Hurlbert's PIE: 0.8216
Shannon's H: 1.9860
Good's u: 0.9959
Each square represents a species. Square sizes are proportional to counts.
Register