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=1894 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1894SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1703SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1894 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='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='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='Priodontes' AND (junior_species='maximus' OR junior_species='maximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Priodontes' AND (species='maximus' OR species='maximus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Priodontes' AND (junior_species='maximus' OR junior_species='maximus')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='Priodontes' AND (species='maximus' OR species='maximus') 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='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='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='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='Leopardus' AND (junior_species='wiedii' OR junior_species='wiedi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopardus' AND (species='wiedii' OR species='wiedi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='wiedii' OR junior_species='wiedi')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='wiedii' OR species='wiedi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='onca' OR junior_species='onca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='onca' OR species='onca') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='onca' OR junior_species='onca')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='Panthera' AND (species='onca' OR species='onca') 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='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='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='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='Tayassu' AND (junior_species='pecari' OR junior_species='pecarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tayassu' AND (species='pecari' OR species='pecarii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tayassu' AND (junior_species='pecari' OR junior_species='pecarii')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='Tayassu' AND (species='pecari' OR species='pecarii') 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='Dasyprocta' AND (junior_species='punctata' OR junior_species='punctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyprocta' AND (species='punctata' OR species='punctata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' AND (junior_species='punctata' OR junior_species='punctata')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='punctata' OR species='punctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myoprocta' AND (junior_species='acouchy' OR junior_species='acouchy')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myoprocta' AND (species='acouchy' OR species='acouchy') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myoprocta' AND (junior_species='acouchy' OR junior_species='acouchy')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='acouchy' OR species='acouchy') 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='Crypturellus' AND (junior_species='undulaus' OR junior_species='undulaus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crypturellus' AND (species='undulaus' OR species='undulaus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crypturellus' AND (species='undulaus' OR species='undulaus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crypturellus' AND (junior_species='undulaus' OR junior_species='undulaus')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='Crypturellus' AND (species='undulaus' OR species='undulaus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitu' AND (junior_species='tuberosa' OR junior_species='tuberosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mitu' AND (species='tuberosa' OR species='tuberosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mitu' AND (species='tuberosa' OR species='tuberosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitu' AND (junior_species='tuberosa' OR junior_species='tuberosa')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='Mitu' AND (species='tuberosa' OR species='tuberosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penelope' AND (junior_species='jacquacu' OR junior_species='jacquacu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Penelope' AND (species='jacquacu' OR species='jacquacu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Penelope' AND (species='jacquacu' OR species='jacquacu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penelope' AND (junior_species='jacquacu' OR junior_species='jacquacu')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='Penelope' AND (species='jacquacu' OR species='jacquacu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophia' AND (junior_species='leucoptera' OR junior_species='leucoptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psophia' AND (species='leucoptera' OR species='leucoptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psophia' AND (species='leucoptera' OR species='leucoptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophia' AND (junior_species='leucoptera' OR junior_species='leucoptera')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='Psophia' AND (species='leucoptera' OR species='leucoptera') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1894 The Ecological Register: Los Amigos Conservation Concession (2005)
Los Amigos Conservation Concession (2005)
Basic information
Sample name: Los Amigos Conservation Concession (2005)

Reference: M. W. Tobler, S. E. Carrillo-Percastegui, R. Leite Pitman, R. Mares, and G. Powell. 2008. An evaluation of camera traps for inventorying large and medium-sized terrestrial rainforest mammals. Animal Conservation 11(3):169-178 [ER 1703]
Geography
Country: Peru


Coordinate: 12° 33' 0" S, 70° 5' 30" W
Coordinate basis: stated in text as range

Geography comments: "About two-thirds of the study site were within the Los Amigos Conservation Concession... a 1400 km2 privately managed protected area, with the remainder falling within two active logging concessions"
coordinate is the midpoint of ranges stated in the text
elevation 250 to 320 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: other protected area

Substrate: ground surface

MAT: 24.0

MAP: 3000.0

Habitat comments: "mostly primary lowland Amazonian moist forest" with cameras placed "in terra firme and floodplain forests only"
there is "a marked dry season from June to September and a rainy season during the months of November through February"
MAP 2500 to 3500

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

Site area: 5000

Sampling methods: quadrat,automatic cameras

Sample size: 428 captures or sightings

Years: 2005

Days: 60

Seasons: dry,wet or monsoon

Nets or traps: 24

Net or trap nights: 1440

Camera type: analog

Cameras paired: yes

Sampling comments: the survey was "carried out from 14 September to 13 November 2005... at the end of the dry season and the beginning of the rainy season... 24 camera stations were set out in a 2 km grid along the study site’s trail system... covering an area of c. 50 km2... Each camera station included paired cameras facing one another on respective sides of a trail... We used Deercam... passive infrared cameras... Cameras were operating 24h a day and were checked every 5 days to replace film and batteries if necessary"

Metadata
Sample number: 1894

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-09 16:05:54

Modified: 2018-06-30 11:18:19

Abundance distribution
25 species
3 singletons
total count 428
extrapolated richness: 34.4
Fisher's α: 5.792
geometric series k: 0.8272
Hurlbert's PIE: 0.8947
Shannon's H: 2.5925
Good's u: 0.9930
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Didelphis marsupialis211.0 kg
Tamandua tetradactyla14.8 kg insectivore
Dasypus kappleri29.9 kg invertivore-carnivore
Dasypus novemcinctus14.4 kg invertivore
Priodontes maximus538 kg insectivore
Atelocynus microtis4
Nasua nasua24.4 kg invertivore-frugivore
Eira barbara34.3 kg frugivore-carnivore
Herpailurus yagouaroundi15.4 kg carnivore
"Puma yagouaroundi"
Leopardus pardalis158.4 kg carnivore
Leopardus wiedii22.6 kg carnivore
Panthera onca1465 kg carnivore
Puma concolor1449 kg carnivore
Tapirus terrestris39198 kg browser-frugivore
Mazama americana826 kg frugivore-browser
Mazama gouazoubira1714 kg frugivore-browser
Tayassu pecari9529 kg browser
Dicotyles tajacu2321 kg
"Pecari tajacu"
Dasyprocta punctata502.7 kg frugivore
Myoprocta acouchy2984 g frugivore
Cuniculus paca147.4 kg frugivore
Crypturellus undulaus yapura4
Mitu tuberosa28 frugivore
Penelope jacquacu71.6 kg frugivore
Psophia leucoptera561.4 kg