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=672 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=672SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=345SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=672 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='pilularius' OR junior_species='pilularius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='pilularius' OR species='pilularius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='pilularius' OR species='pilularius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='pilularius' OR junior_species='pilularius')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='pilularius' OR species='pilularius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='praticola' OR junior_species='praticola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='praticola' OR species='praticola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='praticola' OR species='praticola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='praticola' OR junior_species='praticola')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='praticola' OR species='praticola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='nuchicornis' OR junior_species='nuchicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='nuchicornis' OR species='nuchicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='nuchicornis' OR species='nuchicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='nuchicornis' OR junior_species='nuchicornis')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='nuchicornis' OR species='nuchicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobopterus' AND (junior_species='erraticus' OR junior_species='erraticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobopterus' AND (species='erraticus' OR species='erraticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobopterus' AND (species='erraticus' OR species='erraticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobopterus' AND (junior_species='erraticus' OR junior_species='erraticus')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='Colobopterus' AND (species='erraticus' OR species='erraticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='fimetarius' OR junior_species='fimetarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='fimetarius' OR species='fimetarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='fimetarius' OR species='fimetarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='fimetarius' OR junior_species='fimetarius')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='Aphodius' AND (species='fimetarius' OR species='fimetarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planolinellus' AND (junior_species='vittatus' OR junior_species='vittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Planolinellus' AND (species='vittatus' OR species='vittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Planolinellus' AND (species='vittatus' OR species='vittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planolinellus' AND (junior_species='vittatus' OR junior_species='vittatus')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='Planolinellus' AND (species='vittatus' OR species='vittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calamosternus' AND (junior_species='granarius' OR junior_species='granarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calamosternus' AND (species='granarius' OR species='granarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calamosternus' AND (species='granarius' OR species='granarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calamosternus' AND (junior_species='granarius' OR junior_species='granarius')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='Calamosternus' AND (species='granarius' OR species='granarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilothorax' AND (junior_species='distinctus' OR junior_species='distinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilothorax' AND (species='distinctus' OR species='distinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilothorax' AND (species='distinctus' OR species='distinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilothorax' AND (junior_species='distinctus' OR junior_species='distinctus')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='Chilothorax' AND (species='distinctus' OR species='distinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melinopterus' AND (junior_species='prodromus' OR junior_species='prodromus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melinopterus' AND (species='prodromus' OR species='prodromus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melinopterus' AND (species='prodromus' OR species='prodromus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melinopterus' AND (junior_species='prodromus' OR junior_species='prodromus')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='Melinopterus' AND (species='prodromus' OR species='prodromus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teuchestes' AND (junior_species='fossor' OR junior_species='fossor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Teuchestes' AND (species='fossor' OR species='fossor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Teuchestes' AND (species='fossor' OR species='fossor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teuchestes' AND (junior_species='fossor' OR junior_species='fossor')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='Teuchestes' AND (species='fossor' OR species='fossor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagolius' AND (junior_species='coloradensis' OR junior_species='coloradensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagolius' AND (species='coloradensis' OR species='coloradensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagolius' AND (species='coloradensis' OR species='coloradensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagolius' AND (junior_species='coloradensis' OR junior_species='coloradensis')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='Pseudagolius' AND (species='coloradensis' OR species='coloradensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otophorus' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otophorus' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otophorus' AND (species='haemorrhoidalis' OR species='haemorrhoidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otophorus' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')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='Otophorus' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=672 The Ecological Register: Purple Springs Grazing Reserve C
Purple Springs Grazing Reserve C
Basic information
Sample name: Purple Springs Grazing Reserve C

Reference: N. Kadiri, J.-P. Lumaret, and K. D. Floate. 2014. Functional diversity and seasonal activity of dung beetles (Coleoptera: Scarabaeoidea) on native grasslands in southern Alberta, Canada. Canadian Entomologist 146(3):291-305 [ER 345]
Geography
Country: Canada

State: Alberta


Coordinate: 49° 50' 56" N, 111° 53' 21" W
Coordinate basis: stated in text

•
Environment
Habitat: temperate savanna

Substrate: ground surface

WMT: 18.8

CMT: -8.6

MAP: 368.0

Habitat comments: "short grass prairie"

Methods
Life forms: scarab beetles

Sampling methods: baited,pitfall traps

Sample size: 72922 individuals

Years: 2008 - 2010

Days: 504

Nets or traps: 5

Net or trap nights: 2520

Sampling comments: five dung-baited pitfall traps "operated from 19 May to 17 October 2008, 20 April to 9 October 2009, and 20 April to 15 October 2010" (i.e., over 504 days)

Metadata
Sample number: 672

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-31 09:49:44

Modified: 2015-10-01 11:01:03

Abundance distribution
12 species
0 singletons
total count 72922
extrapolated richness: 12.0
Fisher's α: 1.079
geometric series k: 0.5884
Hurlbert's PIE: 0.6349
Shannon's H: 1.3092
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Canthon pilularius2147
Canthon praticola457
Onthophagus nuchicornis35904
Colobopterus erraticus4532
Aphodius fimetarius2404
Planolinellus vittatus642
Calamosternus granarius941
Chilothorax distinctus24887
Melinopterus prodromus583
Teuchestes fossor105
Pseudagolius coloradensis145
Otophorus haemorrhoidalis175