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=2543 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2543SELECT 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=2543 ORDER BY register_no ASCSELECT 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='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 * FROM register WHERE sample_no=2543 The Ecological Register: Bois Roche (layer 1d)
Bois Roche (layer 1d)
Basic information
Sample name: Bois Roche (layer 1d)

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: limestone

Habitat comments: "a grey-brown, sinter-like layer, 5–15 cm thick, with localized calcitic laminae, locally eroded by burrows"

Methods
Life forms: rodents

Sampling methods: quarry,screenwash

Sample size: 4 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: 2543

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-15 09:36:24

Modified: 2017-02-14 22:36:24

Abundance distribution
2 species
1 singleton
total count 4
extrapolated richness: 6.0
Fisher's α: NULL
geometric series k: 0.3333
Hurlbert's PIE: 0.1667
Shannon's H: 0.5623
Good's u: 0.7500
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Stenocranius gregalis3
"Microtus gregalis"
Arvicola amphibius1
"Arvicola terrestris"