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=1524 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1524SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1029SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1524 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='gorilla/gorilloides' OR junior_species='gorilla/gorilloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='gorilla/gorilloides' OR species='gorilla/gorilloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='gorilla/gorilloides' OR species='gorilla/gorilloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='gorilla/gorilloides' OR junior_species='gorilla/gorilloides')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='Catharsius' AND (species='gorilla/gorilloides' OR species='gorilla/gorilloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocopris' AND (junior_species='helleri' OR junior_species='hellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliocopris' AND (species='helleri' OR species='hellerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliocopris' AND (species='helleri' OR species='hellerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocopris' AND (junior_species='helleri' OR junior_species='hellerii')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='Heliocopris' AND (species='helleri' OR species='hellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaria' AND (junior_species='oblonga' OR junior_species='oblonga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaria' AND (species='oblonga' OR species='oblonga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaria' AND (species='oblonga' OR species='oblonga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaria' AND (junior_species='oblonga' OR junior_species='oblonga')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='Pedaria' AND (species='oblonga' OR species='oblonga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanoplatynus' AND (junior_species='gilleti' OR junior_species='gilletii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drepanoplatynus' AND (species='gilleti' OR species='gilletii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drepanoplatynus' AND (species='gilleti' OR species='gilletii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanoplatynus' AND (junior_species='gilleti' OR junior_species='gilletii')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='Drepanoplatynus' AND (species='gilleti' OR species='gilletii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oniticellus' AND (junior_species='pseudoplanatus' OR junior_species='pseudoplanatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oniticellus' AND (species='pseudoplanatus' OR species='pseudoplanatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oniticellus' AND (species='pseudoplanatus' OR species='pseudoplanatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oniticellus' AND (junior_species='pseudoplanatus' OR junior_species='pseudoplanatus')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='Oniticellus' AND (species='pseudoplanatus' OR species='pseudoplanatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophodonitis' AND (junior_species='carinatus' OR junior_species='carinatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophodonitis' AND (species='carinatus' OR species='carinatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophodonitis' AND (species='carinatus' OR species='carinatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophodonitis' AND (junior_species='carinatus' OR junior_species='carinatus')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='Lophodonitis' AND (species='carinatus' OR species='carinatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastellopalpus' AND (junior_species='laevibasis' OR junior_species='laevibasis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diastellopalpus' AND (species='laevibasis' OR species='laevibasis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diastellopalpus' AND (species='laevibasis' OR species='laevibasis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastellopalpus' AND (junior_species='laevibasis' OR junior_species='laevibasis')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='Diastellopalpus' AND (species='laevibasis' OR species='laevibasis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastellopalpus' AND (junior_species='murrayi' OR junior_species='murrayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diastellopalpus' AND (species='murrayi' OR species='murrayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diastellopalpus' AND (species='murrayi' OR species='murrayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastellopalpus' AND (junior_species='murrayi' OR junior_species='murrayii')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='Diastellopalpus' AND (species='murrayi' OR species='murrayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milichus' AND (junior_species='merzi' OR junior_species='merzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Milichus' AND (species='merzi' OR species='merzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Milichus' AND (species='merzi' OR species='merzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milichus' AND (junior_species='merzi' OR junior_species='merzii')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='Milichus' AND (species='merzi' OR species='merzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimonthophagus' AND (junior_species='apicehirtus' OR junior_species='apicehirtus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimonthophagus' AND (species='apicehirtus' OR species='apicehirtus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimonthophagus' AND (species='apicehirtus' OR species='apicehirtus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimonthophagus' AND (junior_species='apicehirtus' OR junior_species='apicehirtus')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='Mimonthophagus' AND (species='apicehirtus' OR species='apicehirtus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='barriorum' OR junior_species='barriorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='barriorum' OR species='barriorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='barriorum' OR species='barriorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='barriorum' OR junior_species='barriorum')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='Onthophagus' AND (species='barriorum' OR species='barriorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='umbratus' OR junior_species='umbratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='umbratus' OR species='umbratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='umbratus' OR species='umbratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='umbratus' OR junior_species='umbratus')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='Onthophagus' AND (species='umbratus' OR species='umbratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='densipilis' OR junior_species='densipilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='densipilis' OR species='densipilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='densipilis' OR species='densipilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='densipilis' OR junior_species='densipilis')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='Onthophagus' AND (species='densipilis' OR species='densipilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='fuscidorsis' OR junior_species='fuscidorsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='fuscidorsis' OR species='fuscidorsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='fuscidorsis' OR species='fuscidorsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='fuscidorsis' OR junior_species='fuscidorsis')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='Onthophagus' AND (species='fuscidorsis' OR species='fuscidorsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='intricatus' OR junior_species='intricatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='intricatus' OR species='intricatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='intricatus' OR species='intricatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='intricatus' OR junior_species='intricatus')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='Onthophagus' AND (species='intricatus' OR species='intricatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='justei' OR junior_species='justeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='justei' OR species='justeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='justei' OR species='justeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='justei' OR junior_species='justeii')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='Onthophagus' AND (species='justei' OR species='justeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='vesanus' OR junior_species='vesanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='vesanus' OR species='vesanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='vesanus' OR species='vesanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='vesanus' OR junior_species='vesanus')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='Onthophagus' AND (species='vesanus' OR species='vesanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='semiiris' OR junior_species='semiiris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proagoderus' AND (species='semiiris' OR species='semiiris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proagoderus' AND (species='semiiris' OR species='semiiris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='semiiris' OR junior_species='semiiris')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='Proagoderus' AND (species='semiiris' OR species='semiiris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tomogonus' AND (junior_species='crassus' OR junior_species='crassus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tomogonus' AND (species='crassus' OR species='crassus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tomogonus' AND (species='crassus' OR species='crassus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tomogonus' AND (junior_species='crassus' OR junior_species='crassus')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='Tomogonus' AND (species='crassus' OR species='crassus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='angulicollis' OR junior_species='angulicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='angulicollis' OR species='angulicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='angulicollis' OR species='angulicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='angulicollis' OR junior_species='angulicollis')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='Neosisyphus' AND (species='angulicollis' OR species='angulicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='sp.' OR junior_species='sp.')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='Neosisyphus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='sp.' OR junior_species='sp.')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='Sisyphus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='sp.' OR junior_species='sp.')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='Sisyphus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1524 The Ecological Register: La Belgique (old secondary forest)
La Belgique (old secondary forest)
Basic information
Sample name: La Belgique (old secondary forest)

Sample aka: Dja Biosphere Reserve

Reference: C.-A. Petre, M.-H. Zinque, N. Tagg, R.-C. Beudels-Jamar, B. Haurez, J.-F. Josso, P. Moretto, and J.-L. Doucet. 2015. Differences in dung beetle activity at western gorilla defecation sites in south-east Cameroon: implications for establishment of Uapaca spp. seedlings. Journal of Tropical Ecology 31(2):165-174 [ER 1029]
Geography
Country: Cameroon


Coordinate: 3° 25' N, 13° 9' E
Coordinate basis: stated in text as range

Geography comments: coordinate is the midpoint of ranges stated in the text
elevation 600 to 700 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Protection: biosphere reserve

Substrate: ground surface

MAT: 23.5

MAP: 1573.0

Habitat comments: "in the transition zone between evergreen and semi-deciduous forests... a humid tropical climate with two rainy seasons... The site is dominated by old secondary forests and comprises a dense network of watercourses and swamps"
daily min/max temp 19.8 and 22.7; MAT 1315 to 1831 mm

Methods
Life forms: scarab beetles

Sites: 8

Sample size: 308 individuals

Years: 2012

Days: 2

Nets or traps: 8

Net or trap nights: 16

Sampling comments: trapping was "in five gorilla sleeping sites and five patches of old secondary forest, followed 4–7 d later by secondary-dispersal experiments in these same experimental stations and an additional three of each type (totalling eight per habitat type)... all experimental samples comprised 300 g... of fresh (<24 h old) gorilla faeces collected from the research site... maintained for 48 h" and with one pitfall trap per site

Metadata
Sample number: 1524

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-03 20:20:48

Modified: 2015-05-03 10:20:48

Abundance distribution
23 species
7 singletons
total count 308
extrapolated richness: 39.1
Fisher's α: 5.751
geometric series k: 0.8070
Hurlbert's PIE: 0.8249
Shannon's H: 2.2675
Good's u: 0.9773
Each square represents a species. Square sizes are proportional to counts.
Register