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=3267 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3267SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3027SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3267 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mazama' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' AND (junior_species='americana' OR junior_species='americana')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='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicotyles' AND (junior_species='tajacu' OR junior_species='tajacu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicotyles' AND (species='tajacu' OR species='tajacu') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicotyles' AND (junior_species='tajacu' OR junior_species='tajacu')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='Dicotyles' AND (species='tajacu' OR species='tajacu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atelocynus' AND (junior_species='microtis' OR junior_species='microtis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atelocynus' AND (species='microtis' OR species='microtis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atelocynus' AND (species='microtis' OR species='microtis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atelocynus' AND (junior_species='microtis' OR junior_species='microtis')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='Atelocynus' AND (species='microtis' OR species='microtis') 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='Puma' AND (junior_species='concolor' OR junior_species='concolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Puma' AND (species='concolor' OR species='concolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Puma' AND (junior_species='concolor' OR junior_species='concolor')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='Puma' AND (species='concolor' OR species='concolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eira' AND (junior_species='barbara' OR junior_species='barbara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eira' AND (species='barbara' OR species='barbara') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eira' AND (junior_species='barbara' OR junior_species='barbara')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='Eira' AND (species='barbara' OR species='barbara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasua' AND (junior_species='nasua' OR junior_species='nasua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nasua' AND (species='nasua' OR species='nasua') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasua' AND (junior_species='nasua' OR junior_species='nasua')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='nasua' OR species='nasua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cabassous' AND (junior_species='unicinctus' OR junior_species='unicinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cabassous' AND (species='unicinctus' OR species='unicinctus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cabassous' AND (junior_species='unicinctus' OR junior_species='unicinctus')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='Cabassous' AND (species='unicinctus' OR species='unicinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='kappleri' OR junior_species='kapplerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasypus' AND (species='kappleri' OR species='kapplerii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='kappleri' OR junior_species='kapplerii')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='kappleri' OR species='kapplerii') 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='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='Sylvilagus' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvilagus' AND (species='brasiliensis' OR species='brasiliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')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='brasiliensis' OR species='brasiliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirus' AND (junior_species='terrestris' OR junior_species='terrestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapirus' AND (species='terrestris' OR species='terrestris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirus' AND (junior_species='terrestris' OR junior_species='terrestris')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='Tapirus' AND (species='terrestris' OR species='terrestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecophaga' AND (junior_species='tridactyla' OR junior_species='tridactyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmecophaga' AND (species='tridactyla' OR species='tridactyla') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecophaga' AND (junior_species='tridactyla' OR junior_species='tridactyla')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='Myrmecophaga' AND (species='tridactyla' OR species='tridactyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamandua' AND (junior_species='tetradactyla' OR junior_species='tetradactyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamandua' AND (species='tetradactyla' OR species='tetradactyla') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamandua' AND (junior_species='tetradactyla' OR junior_species='tetradactyla')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='tetradactyla' OR species='tetradactyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leontocebus' AND (junior_species='weddelli' OR junior_species='weddellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leontocebus' AND (species='weddelli' OR species='weddellii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leontocebus' AND (junior_species='weddelli' OR junior_species='weddellii')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='Leontocebus' AND (species='weddelli' OR species='weddellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cebus' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cebus' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cebus' AND (species='unicolor' OR species='unicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cebus' AND (junior_species='unicolor' OR junior_species='unicolor')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='Cebus' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saimiri' AND (junior_species='boliviensis' OR junior_species='boliviensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saimiri' AND (species='boliviensis' OR species='boliviensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saimiri' AND (species='boliviensis' OR species='boliviensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saimiri' AND (junior_species='boliviensis' OR junior_species='boliviensis')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='Saimiri' AND (species='boliviensis' OR species='boliviensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuniculus' AND (junior_species='paca' OR junior_species='paca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuniculus' AND (species='paca' OR species='paca') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuniculus' AND (junior_species='paca' OR junior_species='paca')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='Cuniculus' AND (species='paca' OR species='paca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyprocta' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')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='Dasyprocta' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myoprocta' AND (junior_species='pratti' OR junior_species='prattii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myoprocta' AND (species='pratti' OR species='prattii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myoprocta' AND (junior_species='pratti' OR junior_species='prattii')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='Myoprocta' AND (species='pratti' OR species='prattii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='spadiceus' OR junior_species='spadiceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='spadiceus' OR species='spadiceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciurus' AND (species='spadiceus' OR species='spadiceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='spadiceus' OR junior_species='spadiceus')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='Sciurus' AND (species='spadiceus' OR species='spadiceus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3267 The Ecological Register: Purus Project
Purus Project
Basic information
Sample name: Purus Project

Reference: A. L. M. Botelho, L. H. M. Borges, and B. McFarland. 2018. Abundance and composition of the medium to large-sized mammals in a private area of a REDD+ project in Acre, Brazil. Biota Neotropica 18(e20170487):1-9 [ER 3027]
Geography
Country: Brazil

State: Acre


Coordinate: -9.04° S, -69.47° W
Coordinate basis: estimated from map

Geography comments: "in an area of REDD+ known as the Purus Project, located in a forest area of 34,702 ha in the municipality of Manoel Urbano"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: other protected area

Substrate: ground surface

Habitat comments: "The project area is divided into two plots (Seringal Itatinga and Seringal Porto Central) located along the Purus River... with only 1.4% of the forest area being converted into an open area or pasture with more than 98% forest... Two main vegetable typologies were identified in the area: Open Forest with Palm of Alluvial Influence, which is smaller and concentrated in areas near the river and Open Forest with Bamboo and Palms covers the largest area of the Purus Project area"

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

Sampling methods: line transect,automatic cameras

Sample size: 182 captures or sightings

Years: 2013, 2014

Days: 270

Nets or traps: 10

Net or trap nights: 1859

Camera type: digital

Cameras paired: no

Trap spacing: 1

Sampling comments: "The community... was inventoried with the use of 10 BUSHNELL TROPHY CAM HD traps... tree-tied approximately 30 to 40 cm above the ground... . The sampling stations were installed at regular distances of 1 km from each other, in two lines of 4.5 to 5 km... No baits were used... The traps operated continuously (24 hours a day) for 120 days in the first sampling campaign (June 2013 to September 2013) and 150 days during the second campaign (December 2013 to May 2014)... Each record was considered independent if: (1) the interval between consecutive photos of the same species is greater than 1 h; (2) photographs of different individuals of the same species when differentiation was possible"

Metadata
Sample number: 3267

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-03-12 19:21:10

Modified: 2019-03-12 08:21:10

Abundance distribution
22 species
7 singletons
total count 182
extrapolated richness: 37.6
Fisher's α: 6.547
geometric series k: 0.8518
Hurlbert's PIE: 0.9081
Shannon's H: 2.6301
Good's u: 0.9616
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Mazama americana2226 kg frugivore-browser
Dicotyles tajacu2921 kg
"Pecari tajacu"
Atelocynus microtis12
Leopardus pardalis108.4 kg carnivore
Puma concolor449 kg carnivore
Eira barbara134.3 kg frugivore-carnivore
Nasua nasua54.4 kg invertivore-frugivore
Cabassous unicinctus12.1 kg
Dasypus kappleri19.9 kg invertivore-carnivore
Dasypus novemcinctus94.4 kg invertivore
Didelphis marsupialis21.0 kg
Sylvilagus brasiliensis1
Tapirus terrestris11198 kg browser-frugivore
Myrmecophaga tridactyla429 kg insectivore
Tamandua tetradactyla14.8 kg insectivore
Leontocebus weddelli1375 g
"Saguinus weddelli"
Cebus unicolor1
Saimiri boliviensis1
Cuniculus paca87.4 kg frugivore
Dasyprocta fuliginosa284.9 kg
Myoprocta pratti11600 g
Sciurus spadiceus7
"Hadrosciurus spadiceus"