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=3823 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3823SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3483SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3823 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='marsupialis' OR junior_species='marsupialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didelphis' AND (species='marsupialis' OR species='marsupialis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='marsupialis' OR junior_species='marsupialis')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='marsupialis' OR species='marsupialis') 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='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='Tamandua' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamandua' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamandua' AND (junior_species='mexicana' OR junior_species='mexicana')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='Tamandua' AND (species='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')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='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='latrans' OR species='latrans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')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='Canis' AND (species='latrans' OR species='latrans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpailurus' AND (junior_species='yagouaroundi' OR junior_species='yagouaroundii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpailurus' AND (species='yagouaroundi' OR species='yagouaroundii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpailurus' AND (junior_species='yagouaroundi' OR junior_species='yagouaroundii')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='Herpailurus' AND (species='yagouaroundi' OR species='yagouaroundii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopardus' AND (species='pardalis' OR species='pardalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='pardalis' OR junior_species='pardalis')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='pardalis' OR species='pardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')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='Procyon' AND (species='lotor' OR species='lotor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasua' AND (junior_species='narica' OR junior_species='narica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nasua' AND (species='narica' OR species='narica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasua' AND (junior_species='narica' OR junior_species='narica')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='Nasua' AND (species='narica' OR species='narica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galictis' AND (junior_species='vittata' OR junior_species='vittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galictis' AND (species='vittata' OR species='vittata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galictis' AND (junior_species='vittata' OR junior_species='vittata')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='Galictis' AND (species='vittata' OR species='vittata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')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='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3823 The Ecological Register: Sierra Region (oil palm)
Sierra Region (oil palm)
Basic information
Sample name: Sierra Region (oil palm)

Reference: J. L. Knowlton, E. E. Mata Zayas, A. J. Ripley, B. Valenzuela-Cordova, and R. Collado-Torres. 2019. Mammal diversity in oil palm plantations and forest fragments in a highly modified landscape in southern Mexico. Frontiers in Forests and Global Change 2:67 [ER 3483]
Geography
Country: Mexico

State: Tabasco


Coordinate: 17° 13' 40" N, 92° 51' 5" W
Coordinate basis: stated in text

Geography comments: "We conducted this study in the southern part of the Mexican state of Tabasco, close to the border with Chiapas, in the municipalities of Teapa, Tacotalpa and Jalapa"
"This area is called the Sierra Region"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: plantation

Protection: unprotected

Substrate: ground surface

Disturbance: agriculture

MAT: 26.0

MAP: 3250.0

Habitat comments: "The climate is hot, humid, and rainy, with the average temperature and precipitation ranging from 24 to 28°C and 2,500–4,000 mm, respectively"
"The landscape is composed of fragments of high and medium subperennifolia tropical forest, secondary vegetation, annual crops, and forest plantations and pastures, with the latter being the dominant matrix"

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

Sampling methods: no design,automatic cameras

Sample size: 1010 captures or sightings

Years: 2017, 2018

Days: 178

Nets or traps: 36

Net or trap nights: 2136

Camera type: digital

Cameras paired: no

Sampling comments: "We identified and selected nine secondary forest fragments and nine mature oil palm plantations (>10 years old) for the mammal surveys"
"Within each of these sites we placed four camera traps (Browning Strike Force™ HD PRO, United States) ≥200 m from one another at a height of 0.5 m from the ground and secured with a cable lock"
"All cameras were configured to medium sensitivity and one-second intervals between consecutive photographs (four per trigger)"
"All sites were not sampled simultaneously, but rather surveys were organized sequentially in different sessions to cover the three main seasons of the region: cold fronts, dry, and wet"
"The first sampling session took place from 15 December 2017 to 15 February 2018; the second from 19 April to 3 July 2018, and the third from 19 October to 17 December 2018"
"During each sampling session 24 cameras were active within six different sites: three oil palm plantations and three forest fragments"
Consequently, there were a total of 36 camera traps across the nine oil palm plantations (4 traps x 3 sites x 3 sessions), with three different oil palm plantation sites sampled in each session (nine sites total)

Metadata
Sample number: 3823

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2021-06-17 14:00:00

Modified: 2021-06-17 04:00:00

Abundance distribution
12 species
3 singletons
total count 1010
extrapolated richness: 18.9
Fisher's α: 1.914
geometric series k: 0.5819
Hurlbert's PIE: 0.7246
Shannon's H: 1.4692
Good's u: 0.9970
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Didelphis marsupialis3861.0 kg
Philander opossum173451 g
Dasypus novemcinctus334.4 kg invertivore
Tamandua mexicana24.5 kg
Sylvilagus floridanus61.1 kg herbivore
Canis latrans10012 kg carnivore-insectivore
Herpailurus yagouaroundi15.4 kg carnivore
Leopardus pardalis18.4 kg carnivore
Procyon lotor3015.5 kg carnivore-granivore
Nasua narica14.6 kg frugivore-invertivore
Galictis vittata31.5 kg
Odocoileus virginianus375 kg herbivore