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=1274 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1274SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=342SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1274 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anachalcos' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anachalcos' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='cupreus' OR junior_species='cupreus')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='Anachalcos' AND (species='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='eburneus' OR junior_species='eburneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='eburneus' OR species='eburneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='eburneus' OR species='eburneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='eburneus' OR junior_species='eburneus')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='eburneus' OR species='eburneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='gazanus' OR junior_species='gazanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='gazanus' OR species='gazanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='gazanus' OR species='gazanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='gazanus' OR junior_species='gazanus')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='gazanus' OR species='gazanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='seminulum' OR junior_species='seminulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='seminulum' OR species='seminulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='seminulum' OR species='seminulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='seminulum' OR junior_species='seminulum')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='seminulum' OR species='seminulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='carmelita' OR junior_species='carmelita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copris' AND (species='carmelita' OR species='carmelita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copris' AND (species='carmelita' OR species='carmelita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='carmelita' OR junior_species='carmelita')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='Copris' AND (species='carmelita' OR species='carmelita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' 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='Catharsius' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' 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='Catharsius' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastellopalpus' AND (junior_species='tridens' OR junior_species='tridens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diastellopalpus' AND (species='tridens' OR species='tridens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diastellopalpus' AND (species='tridens' OR species='tridens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastellopalpus' AND (junior_species='tridens' OR junior_species='tridens')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='tridens' OR species='tridens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='atridorsis' OR junior_species='atridorsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='atridorsis' OR species='atridorsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='atridorsis' OR species='atridorsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='atridorsis' OR junior_species='atridorsis')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='atridorsis' OR species='atridorsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bidens' OR junior_species='bidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='bidens' OR species='bidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='bidens' OR species='bidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bidens' OR junior_species='bidens')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='bidens' OR species='bidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='curvifrons' OR junior_species='curvifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='curvifrons' OR species='curvifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='curvifrons' OR species='curvifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='curvifrons' OR junior_species='curvifrons')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='curvifrons' OR species='curvifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='deplanatus' OR junior_species='deplanatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='deplanatus' OR species='deplanatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='deplanatus' OR species='deplanatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='deplanatus' OR junior_species='deplanatus')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='deplanatus' OR species='deplanatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='feai' OR junior_species='feaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='feai' OR species='feaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='feai' OR species='feaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='feai' OR junior_species='feaii')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='feai' OR species='feaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='fuscatus' OR species='fuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='fuscatus' OR species='fuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='fuscatus' OR junior_species='fuscatus')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='fuscatus' OR species='fuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='ieti' OR junior_species='ietii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='ieti' OR species='ietii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='ieti' OR species='ietii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='ieti' OR junior_species='ietii')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='ieti' OR species='ietii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='liberianus' OR junior_species='liberianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='liberianus' OR species='liberianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='liberianus' OR species='liberianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='liberianus' OR junior_species='liberianus')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='liberianus' OR species='liberianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='mucronatus' OR junior_species='mucronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='mucronatus' OR species='mucronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='mucronatus' OR species='mucronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='mucronatus' OR junior_species='mucronatus')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='mucronatus' OR species='mucronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' 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='Onthophagus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' 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='Onthophagus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' 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='Onthophagus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' 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='Onthophagus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanocerus' AND (junior_species='caelatus' OR junior_species='caelatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drepanocerus' AND (species='caelatus' OR species='caelatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drepanocerus' AND (species='caelatus' OR species='caelatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanocerus' AND (junior_species='caelatus' OR junior_species='caelatus')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='Drepanocerus' AND (species='caelatus' OR species='caelatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiniocellus' AND (junior_species='spinipes' OR junior_species='spinipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiniocellus' AND (species='spinipes' OR species='spinipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiniocellus' AND (species='spinipes' OR species='spinipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiniocellus' AND (junior_species='spinipes' OR junior_species='spinipes')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='Tiniocellus' AND (species='spinipes' OR species='spinipes') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1274 The Ecological Register: Ankasa Conservation Area (plantation)
Ankasa Conservation Area (plantation)
Basic information
Sample name: Ankasa Conservation Area (plantation)

Reference: A. L. V. Davis and T. K. Philips. 2005. Effect of deforestation on a southwest Ghana dung beetle assemblage (Coleoptera: Scarabaeidae) at the periphery of Ankasa Conservation Area. Environmental Entomology 34(5):1081-1088 [ER 342]
Geography
Country: Ghana


Coordinate: 5° 17' N, 2° 35' W
Geography comments: coordinate extrapolated from that of the "Elubo gate" given in text; this is about 20 km due west of the center of the reserve
elevation 6.8 to 109.5 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: plantation

Substrate: ground surface

WMT: 27.9

CMT: 24.6

MAP: 1446.0

Habitat comments: originally "Eastern Upper Guinean rainforest" and now oil palm plantations
climate data based on station 65585 (Adiake)

Methods
Life forms: scarab beetles

Sites: 4

Sampling methods: no design,baited,pitfall traps

Sample size: 8098 individuals

Days: 2

Nets or traps: 12

Net or trap nights: 24

Sampling comments: three pig dung-baited pitfall traps "placed at least 10 m apart" per site; "traps were baited in the morning on two 24-h trapping occasions"

Metadata
Sample number: 1274

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-18 11:40:29

Modified: 2015-10-02 21:52:28

Abundance distribution
20 species
2 singletons
total count 8098
extrapolated richness: 27.6
Fisher's α: 2.471
geometric series k: 0.6322
Hurlbert's PIE: 0.4136
Shannon's H: 0.9131
Good's u: 0.9998
Each square represents a species. Square sizes are proportional to counts.
Register