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=589 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=589SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=292SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=589 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='colonicus' OR junior_species='colonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='colonicus' OR species='colonicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='colonicus' OR species='colonicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='colonicus' OR junior_species='colonicus')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='Dichotomius' AND (species='colonicus' OR species='colonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='satanas' OR junior_species='satanas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='satanas' OR species='satanas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='satanas' OR species='satanas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='satanas' OR junior_species='satanas')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='Dichotomius' AND (species='satanas' OR species='satanas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='ohausi' OR junior_species='ohausii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='ohausi' OR species='ohausii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='ohausi' OR species='ohausii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='ohausi' OR junior_species='ohausii')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='Coprophanaeus' AND (species='ohausi' OR species='ohausii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='chiriquensis' OR junior_species='chiriquensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='chiriquensis' OR species='chiriquensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='chiriquensis' OR species='chiriquensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='chiriquensis' OR junior_species='chiriquensis')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='Coprophanaeus' AND (species='chiriquensis' OR species='chiriquensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sulcophanaeus' AND (junior_species='velutinus' OR junior_species='velutinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sulcophanaeus' AND (species='velutinus' OR species='velutinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sulcophanaeus' AND (species='velutinus' OR species='velutinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sulcophanaeus' AND (junior_species='velutinus' OR junior_species='velutinus')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='Sulcophanaeus' AND (species='velutinus' OR species='velutinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='magnus' OR junior_species='magnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='magnus' OR species='magnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='magnus' OR species='magnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='magnus' OR junior_species='magnus')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='Eurysternus' AND (species='magnus' OR species='magnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ontherus' AND (junior_species='didymus' OR junior_species='didymus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ontherus' AND (species='didymus' OR species='didymus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ontherus' AND (species='didymus' OR species='didymus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ontherus' AND (junior_species='didymus' OR junior_species='didymus')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='Ontherus' AND (species='didymus' OR species='didymus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='atroseiceus' OR junior_species='atroseiceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='atroseiceus' OR species='atroseiceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='atroseiceus' OR species='atroseiceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='atroseiceus' OR junior_species='atroseiceus')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='atroseiceus' OR species='atroseiceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cyanellus' OR junior_species='cyanellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='cyanellus' OR species='cyanellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='cyanellus' OR species='cyanellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cyanellus' OR junior_species='cyanellus')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='cyanellus' OR species='cyanellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='dicranius' OR junior_species='dicranius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='dicranius' OR species='dicranius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='dicranius' OR species='dicranius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='dicranius' OR junior_species='dicranius')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='dicranius' OR species='dicranius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='incensus' OR junior_species='incensus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='incensus' OR species='incensus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='incensus' OR species='incensus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='incensus' OR junior_species='incensus')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='incensus' OR species='incensus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='landolti' OR junior_species='landoltii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='landolti' OR species='landoltii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='landolti' OR species='landoltii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='landolti' OR junior_species='landoltii')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='landolti' OR species='landoltii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='nyctopus' OR junior_species='nyctopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='nyctopus' OR species='nyctopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='nyctopus' OR species='nyctopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='nyctopus' OR junior_species='nyctopus')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='nyctopus' OR species='nyctopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scatimus' AND (junior_species='quadridentatus' OR junior_species='quadridentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scatimus' AND (species='quadridentatus' OR species='quadridentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scatimus' AND (species='quadridentatus' OR species='quadridentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scatimus' AND (junior_species='quadridentatus' OR junior_species='quadridentatus')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='Scatimus' AND (species='quadridentatus' OR species='quadridentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='planovultum' OR junior_species='planovultum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='planovultum' OR species='planovultum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='planovultum' OR species='planovultum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='planovultum' OR junior_species='planovultum')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='Canthidium' AND (species='planovultum' OR species='planovultum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='tenebrosum' OR junior_species='tenebrosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='tenebrosum' OR species='tenebrosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='tenebrosum' OR species='tenebrosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='tenebrosum' OR junior_species='tenebrosum')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='Canthidium' AND (species='tenebrosum' OR species='tenebrosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='tuberifrons' OR junior_species='tuberifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='tuberifrons' OR species='tuberifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='tuberifrons' OR species='tuberifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='tuberifrons' OR junior_species='tuberifrons')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='Canthidium' AND (species='tuberifrons' OR species='tuberifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='variolosum' OR junior_species='variolosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='variolosum' OR species='variolosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='variolosum' OR species='variolosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='variolosum' OR junior_species='variolosum')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='Canthidium' AND (species='variolosum' OR species='variolosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='vespertinum' OR junior_species='vespertinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='vespertinum' OR species='vespertinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='vespertinum' OR species='vespertinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='vespertinum' OR junior_species='vespertinum')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='Canthidium' AND (species='vespertinum' OR species='vespertinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' AND (junior_species='bidentis' OR junior_species='bidentis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroxys' AND (species='bidentis' OR species='bidentis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uroxys' AND (species='bidentis' OR species='bidentis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' AND (junior_species='bidentis' OR junior_species='bidentis')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='Uroxys' AND (species='bidentis' OR species='bidentis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' AND (junior_species='depressifrons' OR junior_species='depressifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroxys' AND (species='depressifrons' OR species='depressifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uroxys' AND (species='depressifrons' OR species='depressifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' AND (junior_species='depressifrons' OR junior_species='depressifrons')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='Uroxys' AND (species='depressifrons' OR species='depressifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaridium' AND (junior_species='pilosum' OR junior_species='pilosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaridium' AND (species='pilosum' OR species='pilosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaridium' AND (species='pilosum' OR species='pilosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaridium' AND (junior_species='pilosum' OR junior_species='pilosum')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='Pedaridium' AND (species='pilosum' OR species='pilosum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=589 The Ecological Register: El Hato del Volcan (large traps)
El Hato del Volcan (large traps)
Basic information
Sample name: El Hato del Volcan (large traps)

Reference: S. B. Peck and H. F. Howden. 1984. Response of a dung beetle guild to different sizes of dung bait in a Panamanian rainforest. Biotropica 16(3):235-238 [ER 292]
Geography
Country: Panama

State: Chiriqui


Coordinate: 8° 46' N, 82° 38' W
Coordinate basis: based on nearby landmark

Geography comments: "near El Hato del Volcan" (coordinate based on Volcan)
elevation 1000 to 1760 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

Habitat comments: "remnant tracts of lower montane rainforest"
there is no nearby climate station and apparently no published literature giving any useful climate information

Methods
Life forms: scarab beetles

Sampling methods: baited,other traps

Sample size: 2341 individuals

Net or trap nights: 34

Sampling comments: large baits suspended over 2-liter plastic buckets

Metadata
Sample number: 589

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-27 10:05:36

Modified: 2015-09-28 08:06:01

Abundance distribution
22 species
5 singletons
total count 2341
extrapolated richness: 31.8
Fisher's α: 3.360
geometric series k: 0.7003
Hurlbert's PIE: 0.4143
Shannon's H: 1.0577
Good's u: 0.9979
Each square represents a species. Square sizes are proportional to counts.
Register