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=4269 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4269SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3889SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4269 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='gombaszoegensis' OR junior_species='gombaszoegensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='gombaszoegensis' OR species='gombaszoegensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panthera' AND (species='gombaszoegensis' OR species='gombaszoegensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='gombaszoegensis' OR junior_species='gombaszoegensis')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='Panthera' AND (species='gombaszoegensis' OR species='gombaszoegensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycrocuta' AND (junior_species='brevirostris' OR junior_species='brevirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycrocuta' AND (junior_species='brevirostris' OR junior_species='brevirostris')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='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mosbachensis' OR junior_species='mosbachensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='mosbachensis' OR species='mosbachensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='mosbachensis' OR species='mosbachensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mosbachensis' OR junior_species='mosbachensis')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='Canis' AND (species='mosbachensis' OR species='mosbachensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' 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='Vulpes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vulpes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' 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='Vulpes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' 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='Meles' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meles' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' 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='Meles' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephantidae' 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='Elephantidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elephantidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephantidae' 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='Elephantidae' AND (species='indet.' OR species='indet.') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='altidens' OR junior_species='altidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='altidens' OR species='altidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='altidens' OR species='altidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='altidens' OR junior_species='altidens')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='Equus' AND (species='altidens' OR species='altidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='suessenbornensis' OR junior_species='suessenbornensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='suessenbornensis' OR species='suessenbornensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='suessenbornensis' OR species='suessenbornensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='suessenbornensis' OR junior_species='suessenbornensis')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='Equus' AND (species='suessenbornensis' OR species='suessenbornensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' 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='Bison' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bison' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' 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='Bison' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' 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='Praemegaceros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praemegaceros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' 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='Praemegaceros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='giberti' OR junior_species='gibertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryctolagus' AND (species='giberti' OR species='gibertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryctolagus' AND (species='giberti' OR species='gibertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='giberti' OR junior_species='gibertii')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='Oryctolagus' AND (species='giberti' OR species='gibertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4269 The Ecological Register: Bois-de-Riquet (Locus 1)
Bois-de-Riquet (Locus 1)
Basic information
Sample name: Bois-de-Riquet (Locus 1)

Reference: L. Bourguignon, J. Y. Crochet, R. Capdevila, J. Ivorra, P. O. Antoine, J. Agusti, D. Barsky, H. A. Blain, N. Boulbes, L. Bruxelles, J. Claude, D. Cochard, A. Filoux, C. Firmat, I. Lozano-Fernandez, P. Magniez, M. Pelletier, J. Rios-Garaizar, A. Testu, P. Valensi, and L. De Weyer. 2016. Bois-de-Riquet (Lezignan-la-Cebe, Herault): A late Early Pleistocene archeological occurrence in southern France. Quaternary International 393:24-40 [ER 3889]
Geography
Country: France

State: Occitania


Coordinate: 43.493275° N, 3.425486° E
Coordinate basis: estimated from map

Time interval: Early Pleistocene

Section: US2

Unit number: 2

Unit order: below to above

Max Ma: 1.3

Min Ma: 1.1

Age basis: other

Geography comments: Located in the Middle Herault Valley, in a recently abandoned basalt quarry near Lezignan-la-Cebe. Locus 1 is a dense basalt outcrop in the mid-sector of the Lezignan-la-Cebe quarry

"The bio-chronological analyses carried out on small and large mammal assemblages now concur for an age around 1.3-1.1 Ma for level US2 which encloses the fossils and the basalt artifacts"

•
Environment
Lithology: siliciclastic (mixed)

Taphonomic context: fissure fill,fluvial deposit

Habitat comments: US1 basalt flow (corresponding to the "apex of the colonnade of the 1.57 Ma eruptive event recorded in the quarry") encloses the fossiliferous US2. US2 is an "infill situated within the eroded breach separating the layered base and the entablature of the basalt flowstone"

"US2: Stratigraphical Unit 2 (50 cm thick) is a sedimentary accumulation with numerous angular basalt blocks throughout. This unit has been divided into three sub-units"

US2 C: Base of US2, beige-grey coloured sands with some red clays and small-med size basalt blocks. Abundant and well-preserved microfauna. Well-fossilized but fragmentary large herbivore and carnivore remains.

US2 B: Bone slurry, indiscriminate bone/tooth fragments, coprolites

US2 A: Clayey sandy sediment, red-orange colour containing med-large sized angular basalt blocks, well-fossilized bones, and small coprolites

Methods
Life forms: carnivores,ungulates,other small mammals

Sampling methods: quarry

Sample size: 805 specimens

Years: 2008, 2009, 2010, 2011, 2012

Sampling comments: Faunal analyses were based on 805 identified mammal specimens attributed to 62 individuals

A total of 12 taxa were identified

Unidentified specimens include
Carnivora 29
Equidae 93
Bovinae 4
Cervidae 17
Leporidae 646

Metadata
Sample number: 4269

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-05-17 10:47:37

Modified: 2023-05-17 01:12:20

Abundance distribution
14 species
3 singletons
total count 805
extrapolated richness: 19.2
Fisher's α: 2.407
geometric series k: 0.6512
Hurlbert's PIE: 0.7552
Shannon's H: 1.6973
Good's u: 0.9963
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Panthera gombaszoegensis16
"Panthera onca gombaszoegensis"
Pachycrocuta brevirostris31
Canis mosbachensis26
Vulpes sp.1
Meles sp.1
Elephantidae indet.5
Stephanorhinus etruscus42
Equus altidens131
Equus cf. suessenbornensis4
Bison sp.8
Praemegaceros sp.260
Cervidae indet.1
"Dama-like cervid"
Oryctolagus cf. giberti264
Lepus sp.15