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=590 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=590SELECT 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=590 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='Copris' AND (junior_species='lugubris' OR junior_species='lugubris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copris' AND (species='lugubris' OR species='lugubris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copris' AND (species='lugubris' OR species='lugubris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='lugubris' OR junior_species='lugubris')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='lugubris' OR species='lugubris') 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='belorhinus' OR junior_species='belorhinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='belorhinus' OR species='belorhinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='belorhinus' OR species='belorhinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='belorhinus' OR junior_species='belorhinus')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='belorhinus' OR species='belorhinus') 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='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='Onthophagus' AND (junior_species='sharpi' OR junior_species='sharpii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='sharpi' OR species='sharpii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='sharpi' OR species='sharpii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='sharpi' OR junior_species='sharpii')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='sharpi' OR species='sharpii') 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='ardens' OR junior_species='ardens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='ardens' OR species='ardens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='ardens' OR species='ardens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='ardens' OR junior_species='ardens')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='ardens' OR species='ardens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='leucopterum' OR junior_species='leucopterum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='leucopterum' OR species='leucopterum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='leucopterum' OR species='leucopterum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='leucopterum' OR junior_species='leucopterum')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='leucopterum' OR species='leucopterum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='pallidoalatum' OR junior_species='pallidoalatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='pallidoalatum' OR species='pallidoalatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='pallidoalatum' OR species='pallidoalatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='pallidoalatum' OR junior_species='pallidoalatum')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='pallidoalatum' OR species='pallidoalatum') 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 * FROM register WHERE sample_no=590 The Ecological Register: El Hato del Volcan (small traps)
El Hato del Volcan (small traps)
Basic information
Sample name: El Hato del Volcan (small 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,pitfall traps

Sample size: 768 individuals

Days: 6

Nets or traps: 35

Net or trap nights: 210

Sampling comments: small baits suspended over 200-ml plastic cups

Metadata
Sample number: 590

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-27 10:12:37

Modified: 2015-09-28 08:05:40

Abundance distribution
22 species
4 singletons
total count 768
extrapolated richness: 31.2
Fisher's α: 4.224
geometric series k: 0.7754
Hurlbert's PIE: 0.8100
Shannon's H: 2.0350
Good's u: 0.9948
Each square represents a species. Square sizes are proportional to counts.
Register