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=3772 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3772SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3392SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3772 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='callipygus' OR junior_species='callipygus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalophus' AND (species='callipygus' OR species='callipygus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='callipygus' OR junior_species='callipygus')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='Cephalophus' AND (species='callipygus' OR species='callipygus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='dorsalis' OR junior_species='dorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalophus' AND (species='dorsalis' OR species='dorsalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='dorsalis' OR junior_species='dorsalis')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='Cephalophus' AND (species='dorsalis' OR species='dorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philantomba' AND (junior_species='monticola' OR junior_species='monticola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philantomba' AND (species='monticola' OR species='monticola') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philantomba' AND (junior_species='monticola' OR junior_species='monticola')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='Philantomba' AND (species='monticola' OR species='monticola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='silvicultor' OR junior_species='silvicultor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalophus' AND (species='silvicultor' OR species='silvicultor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='silvicultor' OR junior_species='silvicultor')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='Cephalophus' AND (species='silvicultor' OR species='silvicultor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragelaphus' AND (junior_species='spekii' OR junior_species='speki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tragelaphus' AND (species='spekii' OR species='speki') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragelaphus' AND (junior_species='spekii' OR junior_species='speki')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='Tragelaphus' AND (species='spekii' OR species='speki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mandrillus' AND (junior_species='sphinx' OR junior_species='sphinx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mandrillus' AND (species='sphinx' OR species='sphinx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mandrillus' AND (junior_species='sphinx' OR junior_species='sphinx')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='Mandrillus' AND (species='sphinx' OR species='sphinx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bdeogale' AND (junior_species='nigripes' OR junior_species='nigripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bdeogale' AND (species='nigripes' OR species='nigripes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bdeogale' AND (junior_species='nigripes' OR junior_species='nigripes')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='Bdeogale' AND (species='nigripes' OR species='nigripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenogale' AND (junior_species='naso' OR junior_species='naso')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenogale' AND (species='naso' OR species='naso') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenogale' AND (junior_species='naso' OR junior_species='naso')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='Xenogale' AND (species='naso' OR species='naso') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atherurus' AND (junior_species='africanus' OR junior_species='africanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atherurus' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atherurus' AND (junior_species='africanus' OR junior_species='africanus')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='Atherurus' AND (species='africanus' OR species='africanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phataginus' AND (junior_species='tricuspis' OR junior_species='tricuspis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phataginus' AND (species='tricuspis' OR species='tricuspis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phataginus' AND (junior_species='tricuspis' OR junior_species='tricuspis')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='Phataginus' AND (species='tricuspis' OR species='tricuspis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodonta' AND (junior_species='cyclotis' OR junior_species='cyclotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxodonta' AND (species='cyclotis' OR species='cyclotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodonta' AND (junior_species='cyclotis' OR junior_species='cyclotis')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='Loxodonta' AND (species='cyclotis' OR species='cyclotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funisciurus' AND (junior_species='isabella' OR junior_species='isabella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Funisciurus' AND (species='isabella' OR species='isabella') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funisciurus' AND (junior_species='isabella' OR junior_species='isabella')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='Funisciurus' AND (species='isabella' OR species='isabella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funisciurus' AND (junior_species='pyrropus' OR junior_species='pyrropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Funisciurus' AND (species='pyrropus' OR species='pyrropus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funisciurus' AND (junior_species='pyrropus' OR junior_species='pyrropus')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='Funisciurus' AND (species='pyrropus' OR species='pyrropus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='porcus' OR junior_species='porcus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potamochoerus' AND (species='porcus' OR species='porcus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='porcus' OR junior_species='porcus')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='Potamochoerus' AND (species='porcus' OR species='porcus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyemoschus' AND (junior_species='aquaticus' OR junior_species='aquaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyemoschus' AND (species='aquaticus' OR species='aquaticus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyemoschus' AND (junior_species='aquaticus' OR junior_species='aquaticus')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='Hyemoschus' AND (species='aquaticus' OR species='aquaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nandinia' AND (junior_species='binotata' OR junior_species='binotata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nandinia' AND (species='binotata' OR species='binotata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nandinia' AND (junior_species='binotata' OR junior_species='binotata')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='Nandinia' AND (species='binotata' OR species='binotata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guttera' AND (junior_species='pucherani' OR junior_species='pucheranii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guttera' AND (species='pucherani' OR species='pucheranii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guttera' AND (species='pucherani' OR species='pucheranii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guttera' AND (junior_species='pucherani' OR junior_species='pucheranii')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='Guttera' AND (species='pucherani' OR species='pucheranii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peliperdix' AND (junior_species='lathami' OR junior_species='lathamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peliperdix' AND (species='lathami' OR species='lathamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peliperdix' AND (species='lathami' OR species='lathamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peliperdix' AND (junior_species='lathami' OR junior_species='lathamii')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='Peliperdix' AND (species='lathami' OR species='lathamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picathartes' AND (junior_species='oreas' OR junior_species='oreas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picathartes' AND (species='oreas' OR species='oreas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picathartes' AND (species='oreas' OR species='oreas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picathartes' AND (junior_species='oreas' OR junior_species='oreas')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='Picathartes' AND (species='oreas' OR species='oreas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='reichenowi' OR junior_species='reichenowii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitta' AND (species='reichenowi' OR species='reichenowii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitta' AND (species='reichenowi' OR species='reichenowii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='reichenowi' OR junior_species='reichenowii')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='Pitta' AND (species='reichenowi' OR species='reichenowii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3772 The Ecological Register: Tsinguidi
Tsinguidi
Basic information
Sample name: Tsinguidi

Reference: J. Gaugris, L. Niemand, A. Thomas, B. Orban, R. Morley, H. Melville, K. Drescher, and C. A. Vasicek Gaugris. 2021. A snapshot camera trap assessment of mammals in Congo's Massif du Chaillu with a noteworthy record of grey-necked rockfowl Picathartes oreas. African Journal of Ecology In press:1-6 [ER 3392]
Geography
Country: Republic of the Congo

State: Niari Department


Coordinate: 2° 25' S, 12° 55' E
Coordinate basis: estimated from map

Geography comments: "The Tsinguidi Offset study area includes 250 km2 of the larger 750 km2 Tsinguidi Offset zone in the RoC Niari Département, south east of Mayoko village"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Protection: unprotected

Substrate: ground surface

Disturbance: selective logging

MAP: 1800.0

Dry months: 3

Habitat comments: "The altitude varies from 600 to 900 m and the area receives ca. 1800 mm of precipitation per annum"
"Mean day temperatures range from 21°C (July) to 25°C (March). The dry season lasts from mid-June to mid-August"
"Sections of the study area were logged commercially 10 – 15 years prior to the study"

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

Sampling methods: no design,automatic cameras

Sample size: 215 captures or sightings

Years: 2013

Days: 42

Seasons: wet or monsoon

Nets or traps: 29

Net or trap nights: 932

Camera type: digital

Cameras paired: no

Sampling comments: "To ensure adequate coverage of the 250 km2 study area, 50 x 0.25 km2 survey cells were sampled"
"A total of 22 passive infra-red triggered digital cameras (12 x Bushnell, 8 x Uway and 2 x Cuddeback) ... were deployed between 16 October 2013 and 26 November 2013"
"Twenty cameras were specifically deployed for mammals, while the remaining two were specifically deployed for birds"
"For mammals, an array of between four and nine cameras was deployed for at least three and up to six consecutive trap nights, except for the period 26 October to 11 November, when all traps were deployed continuously"
"Each camera was deployed to monitor specific habitat types within a 250 m radius of the predetermined survey points"
"Cameras were fastened to tree trunks at 600–800 mm above-ground"
"All cameras were set to record three images per trigger-event, and 30-second delays were programmed between consecutive trigger-events"
In total, "Twenty-nine survey cells were surveyed over 42 days (932 trap nights)"

Metadata
Sample number: 3772

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2021-06-08 13:10:24

Modified: 2021-06-08 03:13:39

Abundance distribution
20 species
6 singletons
total count 215
extrapolated richness: 35.5
Fisher's α: 5.389
geometric series k: 0.8076
Hurlbert's PIE: 0.8448
Shannon's H: 2.2250
Good's u: 0.9722
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cephalophus callipygus120 kg frugivore-folivore
Cephalophus dorsalis4015 kg frugivore-folivore
Philantomba monticola584.3 kg frugivore-folivore
"Cephalophus monticola"
Cephalophus silvicultor127 kg frugivore-folivore
Tragelaphus spekii354 kg browser-grazer
Mandrillus sphinx3814 kg frugivore
Bdeogale nigripes24.1 kg invertivore-carnivore
Xenogale naso162.3 kg carnivore-invertivore
"Herpestes naso"
Atherurus africanus143.2 kg frugivore
Phataginus tricuspis12.5 kg
Loxodonta cyclotis11419 kg browser
"Loxodonta africana cyclotis"
Funisciurus isabella11110 g frugivore
Funisciurus pyrropus1297 g frugivore-insectivore
Potamochoerus porcus766 kg
Hyemoschus aquaticus311 kg frugivore-folivore
Nandinia binotata62.7 kg frugivore-invertivore
Guttera pucherani51.1 kg omnivore
"Guttera pucherani verreauxi"
Peliperdix lathami4
Picathartes oreas1220 g
Pitta reichenowi2