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=1436 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1436SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=951SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1436 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='delgadoi' OR junior_species='delgadoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='delgadoi' OR species='delgadoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='delgadoi' OR species='delgadoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='delgadoi' OR junior_species='delgadoii')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='Canthon' AND (species='delgadoi' OR species='delgadoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' 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='Canthon' AND (species='cyanellus' OR species='cyanellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='cyanellus' OR species='cyanellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' 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='Canthon' AND (species='cyanellus' OR species='cyanellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='humectus' OR junior_species='humectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='humectus' OR species='humectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='humectus' OR species='humectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='humectus' OR junior_species='humectus')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='Canthon' AND (species='humectus' OR species='humectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='indigaceus' OR junior_species='indigaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='indigaceus' OR species='indigaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='indigaceus' OR species='indigaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='indigaceus' OR junior_species='indigaceus')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='Canthon' AND (species='indigaceus' OR species='indigaceus') 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='Coprophanaeus' AND (junior_species='corythus' OR junior_species='corythus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='corythus' OR species='corythus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='corythus' OR species='corythus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='corythus' OR junior_species='corythus')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='corythus' OR species='corythus') ORDER BY year,last_namesSELECT 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='Onthophagus' AND (junior_species='crinitus' OR junior_species='crinitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='crinitus' OR species='crinitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='crinitus' OR species='crinitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='crinitus' OR junior_species='crinitus')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='crinitus' OR species='crinitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='igualensis' OR junior_species='igualensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='igualensis' OR species='igualensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='igualensis' OR species='igualensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='igualensis' OR junior_species='igualensis')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='igualensis' OR species='igualensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' AND (junior_species='endymion' OR junior_species='endymion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phanaeus' AND (species='endymion' OR species='endymion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phanaeus' AND (species='endymion' OR species='endymion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' AND (junior_species='endymion' OR junior_species='endymion')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='Phanaeus' AND (species='endymion' OR species='endymion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' 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='Phanaeus' AND (species='tridens' OR species='tridens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phanaeus' AND (species='tridens' OR species='tridens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' 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='Phanaeus' AND (species='tridens' OR species='tridens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1436 The Ecological Register: San Fernando (pasture with Acacia shrubs)
San Fernando (pasture with Acacia shrubs)
Basic information
Sample name: San Fernando (pasture with Acacia shrubs)

Reference: L. Arellano, J. L. León-Cortés, G. Halffter, and J. Montero. 2013. Acacia woodlots, cattle and dung beetles (Coleoptera: Scarabaeinae) in a Mexican silvopastoral landscape. Revista Mexicana de Biodiversidad 84:650-660 [ER 951]
Geography
Country: Mexico

State: Chiapas


Coordinate: 16° 50' 42" N, 93° 13' 18" W
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: pasture

Substrate: ground surface

Habitat comments: there is apparently no primary forest in the area

Methods
Life forms: scarab beetles

Sites: 1

Site length: 150

Sampling methods: line transect,baited,pitfall traps

Sample size: 326 individuals

Years: 2003, 2004

Days: 2

Nets or traps: 6

Net or trap nights: 12

Sampling comments: six "human excrement, cow dung and squid" baited pitfall traps placed along a 150 m transect; "Traps remained functional for 48 h"

Metadata
Sample number: 1436

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-01 15:27:46

Modified: 2015-03-01 04:27:46

Abundance distribution
11 species
2 singletons
total count 326
extrapolated richness: 15.1
Fisher's α: 2.197
geometric series k: 0.6051
Hurlbert's PIE: 0.7249
Shannon's H: 1.6663
Good's u: 0.9939
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Canthon (Glaphyrocanthon) delgadoi60
Canthon cyanellus cyanellus20
Canthon humectus sayi22
Canthon indigaceus chiapas152
Copris lugubris2
Coprophanaeus corythus8
Dichotomius colonicus1
Onthophagus crinitus7
Onthophagus igualensis22
Phanaeus endymion1
Phanaeus tridens31