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=1907 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1907SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1711SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1907 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerdocyon' AND (junior_species='thous' OR junior_species='thous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerdocyon' AND (species='thous' OR species='thous') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerdocyon' AND (junior_species='thous' OR junior_species='thous')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='Cerdocyon' AND (species='thous' OR species='thous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')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='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' AND (junior_species='gouazoubira' OR junior_species='gouazoubira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mazama' AND (species='gouazoubira' OR species='gouazoubira') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' AND (junior_species='gouazoubira' OR junior_species='gouazoubira')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='Mazama' AND (species='gouazoubira' OR species='gouazoubira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycalopex' AND (junior_species='gymnocercus' OR junior_species='gymnocercus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycalopex' AND (species='gymnocercus' OR species='gymnocercus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycalopex' AND (junior_species='gymnocercus' OR junior_species='gymnocercus')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='Lycalopex' AND (species='gymnocercus' OR species='gymnocercus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conepatus' AND (junior_species='chinga' OR junior_species='chinga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conepatus' AND (species='chinga' OR species='chinga') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conepatus' AND (junior_species='chinga' OR junior_species='chinga')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='Conepatus' AND (species='chinga' OR species='chinga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='europaeus' OR species='europaeus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')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='Lepus' AND (species='europaeus' OR species='europaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='geoffroyi' OR junior_species='geoffroyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopardus' AND (species='geoffroyi' OR species='geoffroyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='geoffroyi' OR junior_species='geoffroyii')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='Leopardus' AND (species='geoffroyi' OR species='geoffroyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphractus' AND (junior_species='sexcinctus' OR junior_species='sexcinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphractus' AND (species='sexcinctus' OR species='sexcinctus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphractus' AND (junior_species='sexcinctus' OR junior_species='sexcinctus')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='Euphractus' AND (species='sexcinctus' OR species='sexcinctus') 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 * FROM register WHERE sample_no=1907 The Ecological Register: Rivera (plantation)
Rivera (plantation)
Basic information
Sample name: Rivera (plantation)

Reference: M. J. Andrade-Núñez and T. M. Aide. 2010. Effects of habitat and landscape characteristics on medium and large mammal species richness and composition in northern Uruguay. Zoologia 27(6):909-917 [ER 1711]
Geography
Country: Uruguay


Coordinate: 31° 11' S, 55° 46' W
Coordinate basis: based on nearby landmark

Geography comments: "in the northwestern part of the department of Rivera... Study sites were located in ten properties of a forestry company" (coordinate is based on Tranqueras)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: plantation

Substrate: ground surface

MAT: 18.1

MAP: 1653.0

Habitat comments: "The climate is humid subtropical" and the sites are in "monocultures of Eucalyptus spp."; "Plantation sites varied in age from 2 to 18 years old"

Methods
Life forms: carnivores,ungulates,other large mammals,other small mammals

Sites: 10

Sampling methods: no design,baited,automatic cameras

Sample size: 103 captures or sightings

Years: 2008

Days: 24

Nets or traps: 40

Net or trap nights: 960

Camera type: digital

Cameras paired: no

Trap spacing: 0.06

Sampling comments: "The first survey was carried out from January to April, 2008, the second survey from June to August, 2008, and the third survey from September to December, 2008. Each site was surveyed for approximately 24 days... The direct method consisted of four digital camera traps (Cuddeback Excite Digital Camera, 2 Megapixels) for eight consecutive days in each site for a total of 96 camera/days per site (3 censuses x 4 cameras x 8 days). Camera traps were separated on average by 60 m... We used apples, bananas, sardines and vanilla as baits"

Metadata
Sample number: 1907

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-10 17:22:06

Modified: 2016-01-12 06:40:53

Abundance distribution
10 species
1 singleton
total count 103
extrapolated richness: 14.0
Fisher's α: 2.737
geometric series k: 0.6601
Hurlbert's PIE: 0.7736
Shannon's H: 1.8209
Good's u: 0.9907
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cerdocyon thous425.2 kg carnivore-frugivore
Dasypus novemcinctus114.4 kg invertivore
Mazama gouazoubira1514 kg frugivore-browser
Lycalopex gymnocercus115.6 kg carnivore-frugivore
"Pseudalopex gymnocercus"
Conepatus chinga91.9 kg invertivore
Lepus europaeus73.4 kg herbivore
Leopardus geoffroyi24.6 kg carnivore
"Oncifelis geoffroyi"
Sus scrofa154 kg herbivore
Euphractus sexcinctus34.7 kg
Didelphis albiventris2833 g