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=2542 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2542SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2367SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2542 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='quercinus' OR junior_species='quercinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eliomys' AND (species='quercinus' OR species='quercinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eliomys' AND (species='quercinus' OR species='quercinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='quercinus' OR junior_species='quercinus')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='Eliomys' AND (species='quercinus' OR species='quercinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenocranius' AND (species='gregalis' OR species='gregalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')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='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')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='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicola' AND (species='amphibius' OR species='amphibius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arvicola' AND (species='amphibius' OR species='amphibius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')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='Arvicola' AND (species='amphibius' OR species='amphibius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrostonyx' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrostonyx' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrostonyx' AND (junior_species='torquatus' OR junior_species='torquatus')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='Dicrostonyx' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neomys' AND (species='fodiens' OR species='fodiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')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='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2542 The Ecological Register: Bois Roche (layer 1c)
Bois Roche (layer 1c)
Basic information
Sample name: Bois Roche (layer 1c)

Reference: C. Sesé and P. Villa. 2008. Micromammals (rodents and insectivores) from the early Late Pleistocene cave site of Bois Roche (Charente, France): Systematics and paleoclimatology. Geobios 41:399-414 [ER 2367]
Geography
Country: France


Coordinate: 45° 42' N, 0° 20' W
Coordinate basis: based on nearby landmark

Time interval: Late Pleistocene

Ma: 0.071

Geography comments: "near the city of Cognac" (coordinate based on Cognac)
"dated to late OIS 5 or early OIS 4 by preliminary ESR estimates" (i.e., roughly 71 kyr)

Environment
Substrate: ground surface

Lithology: siltstone

Habitat comments: "yellow-brown sandy clay silt with limestone rock fragments"

Methods
Life forms: rodents

Sampling methods: quarry,screenwash

Sample size: 832 specimens

Years: 1995, 1997-2000

Sampling comments: "Our excavations were done by 1-m grid system... All sediments were waters-creened with superimposed screens of 5 and 2 mm mesh"

Metadata
Sample number: 2542

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-15 09:34:38

Modified: 2017-02-14 22:34:38

Abundance distribution
6 species
2 singletons
total count 832
extrapolated richness: 10.9
Fisher's α: 0.875
geometric series k: 0.2655
Hurlbert's PIE: 0.1626
Shannon's H: 0.3426
Good's u: 0.9976
Each square represents a species. Square sizes are proportional to counts.
Register