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=653 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=653SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=333SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=653 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericotrupes' AND (junior_species='niger' OR junior_species='niger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericotrupes' AND (species='niger' OR species='niger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericotrupes' AND (species='niger' OR species='niger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericotrupes' AND (junior_species='niger' OR junior_species='niger')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='Sericotrupes' AND (species='niger' OR species='niger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trypocopris' AND (junior_species='vernalis' OR junior_species='vernalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trypocopris' AND (species='vernalis' OR species='vernalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trypocopris' AND (species='vernalis' OR species='vernalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trypocopris' AND (junior_species='vernalis' OR junior_species='vernalis')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='Trypocopris' AND (species='vernalis' OR species='vernalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='biguttatus' OR junior_species='biguttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='biguttatus' OR species='biguttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='biguttatus' OR species='biguttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='biguttatus' OR junior_species='biguttatus')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='biguttatus' OR species='biguttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' 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='Aphodius' AND (species='erraticus' OR species='erraticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='erraticus' OR species='erraticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' 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='Aphodius' 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='Aphodius' 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='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' 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='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='obscurus' OR junior_species='obscurus')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='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='paracoenosus' OR junior_species='paracoenosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='paracoenosus' OR species='paracoenosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='paracoenosus' OR species='paracoenosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='paracoenosus' OR junior_species='paracoenosus')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='paracoenosus' OR species='paracoenosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='pusillus' OR junior_species='pusillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='pusillus' OR species='pusillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='pusillus' OR species='pusillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='pusillus' OR junior_species='pusillus')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='pusillus' OR species='pusillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='schaefferi' OR junior_species='schaefferii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='schaefferi' OR species='schaefferii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='schaefferi' OR species='schaefferii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='schaefferi' OR junior_species='schaefferii')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='schaefferi' OR species='schaefferii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euoniticellus' AND (junior_species='fulvus' OR junior_species='fulvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euoniticellus' AND (species='fulvus' OR species='fulvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euoniticellus' AND (species='fulvus' OR species='fulvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euoniticellus' AND (junior_species='fulvus' OR junior_species='fulvus')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='Euoniticellus' AND (species='fulvus' OR species='fulvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonthophagus' AND (junior_species='gibbosus' OR junior_species='gibbosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonthophagus' AND (species='gibbosus' OR species='gibbosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonthophagus' AND (species='gibbosus' OR species='gibbosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonthophagus' AND (junior_species='gibbosus' OR junior_species='gibbosus')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='Euonthophagus' AND (species='gibbosus' OR species='gibbosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='emarginatus' OR junior_species='emarginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='emarginatus' OR species='emarginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='emarginatus' OR species='emarginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='emarginatus' OR junior_species='emarginatus')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='emarginatus' OR species='emarginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='fracticornis' OR junior_species='fracticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='fracticornis' OR species='fracticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='fracticornis' OR species='fracticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='fracticornis' OR junior_species='fracticornis')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='fracticornis' OR species='fracticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='grossepunctatus' OR junior_species='grossepunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='grossepunctatus' OR species='grossepunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='grossepunctatus' OR species='grossepunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='grossepunctatus' OR junior_species='grossepunctatus')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='grossepunctatus' OR species='grossepunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='illyricus' OR junior_species='illyricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='illyricus' OR species='illyricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='illyricus' OR species='illyricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='illyricus' OR junior_species='illyricus')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='illyricus' OR species='illyricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='joannae' OR junior_species='joannae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='joannae' OR species='joannae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='joannae' OR species='joannae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='joannae' OR junior_species='joannae')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='joannae' OR species='joannae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='lemur' OR junior_species='lemur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='lemur' OR species='lemur') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='lemur' OR species='lemur')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='lemur' OR junior_species='lemur')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='lemur' OR species='lemur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='ovatus' OR junior_species='ovatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='ovatus' OR species='ovatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='ovatus' OR species='ovatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='ovatus' OR junior_species='ovatus')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='ovatus' OR species='ovatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='vacca' OR junior_species='vacca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='vacca' OR species='vacca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='vacca' OR species='vacca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='vacca' OR junior_species='vacca')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='vacca' OR species='vacca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='verticicornis' OR junior_species='verticicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='verticicornis' OR species='verticicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='verticicornis' OR species='verticicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='verticicornis' OR junior_species='verticicornis')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='verticicornis' OR species='verticicornis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=653 The Ecological Register: Verdon Valley M[1] (July)
Verdon Valley M[1] (July)
Basic information
Sample name: Verdon Valley M[1] (July)

Reference: F. Errouissi, P. Jay-Robert, J.-P. Lumaret, and O. Piau. 2004. Composition and structure of dung beetle (Coleoptera: Aphodiidae, Geotrupidae, Scarabaeidae) assemblages in mountain grasslands of the Southern Alps. Annals of the Entomological Society of America 97(4):701-709 [ER 333]
Geography
Country: France


Coordinate: 43° 51' N, 6° 31' E
Coordinate basis: based on nearby landmark

Geography comments: shown as perhaps 2 km north of Castellane (basis of coordinate)

Environment
Habitat: temperate savanna

Substrate: ground surface

WMT: 24.3

CMT: 8.9

MAP: 756.0

Habitat comments: Mediterranean "Bromus erectus grassland"
climate data based on station 76900 (St-Laurent-du-Var airport)

Methods
Life forms: scarab beetles

Sites: 1

Site length: 10

Site width: 10

Sampling methods: baited,pitfall traps

Sample size: 3380 individuals

Days: 7

Nets or traps: 4

Net or trap nights: 28

Sampling comments: four dung baited pitfall traps at the corners of a 10 x 10 m square: "The trap contents were collected 1 wk later, and fresh dung baits were deposited 3 wk later for a further sampling event" (presumably meaning that there was a single one-week sampling period during this month)

Metadata
Sample number: 653

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-30 08:32:09

Modified: 2015-10-01 10:25:33

Abundance distribution
21 species
2 singletons
total count 3380
extrapolated richness: 28.3
Fisher's α: 2.986
geometric series k: 0.6761
Hurlbert's PIE: 0.4350
Shannon's H: 1.0594
Good's u: 0.9994
Each square represents a species. Square sizes are proportional to counts.
Register