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=4298 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4298SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3909SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4298 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' 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='Sorex' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' 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='Sorex' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' 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='Crocidura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' 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='Crocidura' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='ferrumequinum' OR junior_species='ferrumequinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='ferrumequinum' OR species='ferrumequinum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='ferrumequinum' OR junior_species='ferrumequinum')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='Rhinolophus' AND (species='ferrumequinum' OR species='ferrumequinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='myotis' OR junior_species='myotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='myotis' OR species='myotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='myotis' OR junior_species='myotis')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='Myotis' AND (species='myotis' OR species='myotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')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='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iberomys' AND (junior_species='brecciensis' OR junior_species='brecciensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iberomys' AND (species='brecciensis' OR species='brecciensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iberomys' AND (species='brecciensis' OR species='brecciensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iberomys' AND (junior_species='brecciensis' OR junior_species='brecciensis')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='Iberomys' AND (species='brecciensis' OR species='brecciensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='episcopalis' OR junior_species='episcopalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pliomys' AND (species='episcopalis' OR species='episcopalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pliomys' AND (species='episcopalis' OR species='episcopalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='episcopalis' OR junior_species='episcopalis')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='Pliomys' AND (species='episcopalis' OR species='episcopalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='flavicollis' OR junior_species='flavicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='flavicollis' OR species='flavicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='flavicollis' OR species='flavicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='flavicollis' OR junior_species='flavicollis')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='Apodemus' AND (species='flavicollis' OR species='flavicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allocricetus' AND (junior_species='bursae' OR junior_species='bursae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allocricetus' AND (species='bursae' OR species='bursae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allocricetus' AND (species='bursae' OR species='bursae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allocricetus' AND (junior_species='bursae' OR junior_species='bursae')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='Allocricetus' AND (species='bursae' OR species='bursae') ORDER BY year,last_namesSELECT 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='Salamandridae' 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='Salamandridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salamandridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salamandridae' 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='Salamandridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelodytes' 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='Pelodytes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelodytes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelodytes' 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='Pelodytes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='spinosus' OR junior_species='spinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='spinosus' OR species='spinosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='spinosus' OR species='spinosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='spinosus' OR junior_species='spinosus')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='Bufo' AND (species='spinosus' OR species='spinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacertidae' 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='Lacertidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacertidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacertidae' 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='Lacertidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='girondica' OR junior_species='girondica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coronella' AND (species='girondica' OR species='girondica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coronella' AND (species='girondica' OR species='girondica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='girondica' OR junior_species='girondica')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='Coronella' AND (species='girondica' OR species='girondica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='maura' OR junior_species='maura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Natrix' AND (species='maura' OR species='maura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Natrix' AND (species='maura' OR species='maura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='maura' OR junior_species='maura')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='Natrix' AND (species='maura' OR species='maura') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4298 The Ecological Register: Gruta da Aroeira (Layer Xc)
Gruta da Aroeira (Layer Xc)
Basic information
Sample name: Gruta da Aroeira (Layer Xc)

Reference: J. M. Lopez-García, H. A. Blain, M. Sanz, J. Daura, and J. Zilhao. 2018. Refining the environmental and climatic background of the Middle Pleistocene human cranium from Gruta da Aroeira (Torres Novas, Portugal). Quaternary Science Reviews 200:367-375 [ER 3909]
Geography
Country: Portugal

State: Santarém District


Coordinate: 39.505554° N, -8.615833° W
Coordinate basis: stated in text

Formation: Almonda karst system

Time interval: Middle Pleistocene

Zone: MIS 11c

Section: Xc

Unit number: 2

Unit order: above to below

Max Ma: 0.436

Min Ma: 0.39

Age basis: U/Th

Geography comments: The Gruta da Aroeira site is a part of the Almonda karst system in central Portugal

The karst system consisted of passage excavated across different elevations intersecting a 70 m-high escarpment above the spring of the River Almonda

It has been previously dated to 0.436 - 0.390 Ma based on U/Th dating

•
Environment
Lithology: breccia

Taphonomic context: cave

Archaeology: stone tools

Habitat comments: Aroeira Xc is part of Unit 2, a 2.2 m-thick "mud-supported breccia rich in angular and subangular clasts"

It is stated that "the necessary treatment of the sediment with acetic acid precluded a taphonomic study of these remains"

A human cranium (Aroeira-3) was recovered in association with the small vertebrate assemblage within Unit 2

The small vertebrate assemblage was used to determine a palaeoenvironment of open woodland and mild climatic conditions

Methods
Life forms: bats,rodents,other small mammals,lizards,snakes,frogs,salamanders

Sampling methods: quarry,screenwash

Sample size: 350 specimens

Years: 2013

Sampling comments: Five brecciated samples were treated with ~20 kg of sediment being wet-sieved using a 0.5 mm mesh screen

362 identified remains were recovered from Layer Xc consisting of 17 taxa

Counts excluded:
Ophidia indet. - 5
Anura indet. - 1

Life forms with no counts:
Dama sp.
Cervus sp.
Equidae indet.

Metadata
Sample number: 4298

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-06-13 13:52:02

Modified: 2023-09-11 10:54:42

Abundance distribution
16 species
2 singletons
total count 350
extrapolated richness: 24.1
Fisher's α: 3.458
geometric series k: 0.7214
Hurlbert's PIE: 0.7805
Shannon's H: 1.8653
Good's u: 0.9944
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Sorex sp.12
Crocidura sp.48
Rhinolophus ferrumequinum220.0 g insectivore
Myotis myotis1225.7 g
Miniopterus schreibersii212.4 g insectivore
questionably assigned
Iberomys brecciensis61
Pliomys episcopalis4
Apodemus cf. flavicollis134
"Apodemus cf. A. flavicollis"
Allocricetus bursae47
Eliomys quercinus17
Salamandridae indet.1
Pelodytes sp.2
Bufo spinosus2
Lacertidae indet.2
Coronella girondica1
questionably assigned
Natrix cf. maura3