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=1911 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1911SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1714SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1911 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucopternis' AND (junior_species='melanops' OR junior_species='melanops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucopternis' AND (species='melanops' OR species='melanops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucopternis' AND (species='melanops' OR species='melanops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucopternis' AND (junior_species='melanops' OR junior_species='melanops')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='Leucopternis' AND (species='melanops' OR species='melanops') 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='Pipile' AND (junior_species='pipile' OR junior_species='pipile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipile' AND (species='pipile' OR species='pipile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipile' AND (species='pipile' OR species='pipile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipile' AND (junior_species='pipile' OR junior_species='pipile')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='Pipile' AND (species='pipile' OR species='pipile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitu' AND (junior_species='salvini' OR junior_species='salvinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mitu' AND (species='salvini' OR species='salvinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mitu' AND (species='salvini' OR species='salvinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitu' AND (junior_species='salvini' OR junior_species='salvinii')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='salvini' OR species='salvinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophia' AND (junior_species='crepitans' OR junior_species='crepitans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psophia' AND (species='crepitans' OR species='crepitans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psophia' AND (species='crepitans' OR species='crepitans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophia' AND (junior_species='crepitans' OR junior_species='crepitans')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='crepitans' OR species='crepitans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columba' AND (junior_species='plumbea' OR junior_species='plumbea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columba' AND (species='plumbea' OR species='plumbea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columba' AND (species='plumbea' OR species='plumbea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columba' AND (junior_species='plumbea' OR junior_species='plumbea')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='Columba' AND (species='plumbea' OR species='plumbea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ara' AND (junior_species='macao' OR junior_species='macao')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ara' AND (species='macao' OR species='macao') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ara' AND (species='macao' OR species='macao')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ara' AND (junior_species='macao' OR junior_species='macao')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='Ara' AND (species='macao' OR species='macao') 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='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='Ateles' AND (junior_species='belzebuth' OR junior_species='belzebuth')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ateles' AND (species='belzebuth' OR species='belzebuth') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ateles' AND (species='belzebuth' OR species='belzebuth')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateles' AND (junior_species='belzebuth' OR junior_species='belzebuth')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='Ateles' AND (species='belzebuth' OR species='belzebuth') 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='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='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='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='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='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='Sciurus' AND (junior_species='igniventris' OR junior_species='igniventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='igniventris' OR species='igniventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciurus' AND (species='igniventris' OR species='igniventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='igniventris' OR junior_species='igniventris')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='igniventris' OR species='igniventris') 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='Proechimys' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proechimys' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proechimys' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proechimys' AND (junior_species='spp.' OR junior_species='spp.')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='Proechimys' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1911 The Ecological Register: Chorongo
Chorongo
Basic information
Sample name: Chorongo

Sample aka: Tiputini Biodiversity Station

Reference: J. G. Blake, D. Mosquera, J. Guerra, B. A. Loiselle, D. Romo, and K. Swing. 2011. Mineral licks as diversity hotspots in lowland forest of eastern Ecuador. Diversity 3(2):217-234 [ER 1714]
Geography
Country: Ecuador

State: Orellana


Coordinate: 0° 38' 4" S, 76° 8' 53" W
Coordinate basis: stated in text

Geography comments: "within the ~1.7-million ha Yasuní Biosphere Reserve"
elevation 190 to 270 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: biosphere reserve

Substrate: ground surface

MAT: 25.0

MAP: 2860.0

Habitat comments: "undisturbed lowland rainforest" and specifically "terra firme forest"
climate data are for the Tiputini Biodiversity Station and are from Renninger and Phillips (2011, Oecologia)

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

Sampling methods: no design,automatic cameras

Sample size: 1598 captures or sightings

Nets or traps: 2

Net or trap nights: 1214

Camera type: both

Cameras paired: no

Sampling comments: "We used both digital (Snapshot Sniper, LLC) and film-based (Highlander PhotoscoutTM, PTC Technologies) camera traps triggered by an infrared motion-and-heat detector"
dates of field work and number of cameras are not indicated, but it is presumed that only two cameras deployed because the site is a single salt lick

Metadata
Sample number: 1911

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-10 21:16:05

Modified: 2018-06-30 11:25:58

Abundance distribution
21 species
6 singletons
total count 1598
extrapolated richness: 32.8
Fisher's α: 3.414
geometric series k: 0.7361
Hurlbert's PIE: 0.8129
Shannon's H: 1.9246
Good's u: 0.9962
Each square represents a species. Square sizes are proportional to counts.
Register