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=4403 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4403SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3988SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4403 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeoloxodon' AND (junior_species='antiquus' OR junior_species='antiquus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeoloxodon' AND (species='antiquus' OR species='antiquus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeoloxodon' AND (species='antiquus' OR species='antiquus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeoloxodon' AND (junior_species='antiquus' OR junior_species='antiquus')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='Palaeoloxodon' AND (species='antiquus' OR species='antiquus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='roberti' OR junior_species='robertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dama' AND (species='roberti' OR species='robertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dama' AND (species='roberti' OR species='robertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='roberti' OR junior_species='robertii')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='Dama' AND (species='roberti' OR species='robertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')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='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bovidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bovidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bovidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bovidae' AND (junior_species='indet.' OR junior_species='indet.')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='Bovidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippopotamus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippopotamus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamus' AND (junior_species='sp.' OR junior_species='sp.')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='Hippopotamus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='etruscus' OR junior_species='etruscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stephanorhinus' AND (species='etruscus' OR species='etruscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stephanorhinus' AND (species='etruscus' OR species='etruscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='etruscus' OR junior_species='etruscus')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='Stephanorhinus' AND (species='etruscus' OR species='etruscus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4403 The Ecological Register: Soleihac
Soleihac
Basic information
Sample name: Soleihac

Reference: E. Bonifay, M.-F. Bonifay, R. Panattoni, and J.-J. Tiercelin. 1976. Soleihac (Blanzac, Haute-Loire), nouveau site préhistorique du début du Pléistocène moyen. Bulletin de la Société préhistorique française 73(1):293-304 [ER 3988]
Geography
Country: France


Coordinate: 45.11° N, 3.86° E
Coordinate basis: estimated from map

Time interval: Middle Pleistocene

Max Ma: 0.781

Min Ma: 0.58

Age basis: other

Geography comments: near the farm of Soleihac about 1 km east of Blanzac (coordinate estimated from map in Fig. 1)
from a normal polarity interval interpreted as "younger than the Brunhes-Matuyama boundary" based on an Ar-Ar date of 0.58 ± 0.02 Ma for a pumice ash-fall layer said to be below bed C; the authors apparently mean above bed C based on other statements and on Fig. 2, so the age range is 0.781 to 0.58 Ma (Muttoni et al. 2010)

•
Environment
Lithology: claystone

Taphonomic context: lake deposit

Archaeology: stone tools

Habitat comments: "Mode I lithic tools were found in a 1-2 m-thick level of gray silts and sands termed bed C pertaining to a lacustrine succession contained in a maar depression" (Muttoni et al. 2010)
the level C sediments are specifically from a lake border and consist of loamy clay intercalated with fissures and may have been deposited on a beach or entirely underwater; they are 1.0 to 1.2 m thick
the bones are said to have probably been broken by human activity, but the accumulation agent per se is not discussed
about a score of lithic artefacts was recovered

Methods
Life forms: ungulates

Sampling methods: quarry,screenwash

Sample size: 24 specimens

Years: 1974, 1975

Sampling comments: the site was first discovered by F. Robert in 1829, but the reported collection was made in 1974 and 1975
the sediments were also screenwashed with water (mesh size not stated)
carnivores are entirely absent, and the fishes are not described

Metadata
Sample number: 4403

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-12-10 12:59:39

Modified: 2023-12-10 01:59:39

Abundance distribution
6 species
3 singletons
total count 24
extrapolated richness: 15.7
Fisher's α: 2.568
geometric series k: 0.6310
Hurlbert's PIE: 0.6594
Shannon's H: 1.3369
Good's u: 0.8785
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Palaeoloxodon antiquus9
Dama roberti10
"cf. Euctenoceros": see Breda and Lister (2013); minimum count, more molars and postcrania may exist
Capreolus capreolus suessenbornensis122 kg browser
"Capreolus cf. suessenbornensis"
Bovidae indet.1
medium sized
Hippopotamus sp.1
Stephanorhinus etruscus2
"Dicerorhinus etruscus"