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=4276 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4276SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3895SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4276 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocerotidae' 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='Rhinocerotidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinocerotidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocerotidae' 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='Rhinocerotidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparion' 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='Hipparion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipparion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparion' 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='Hipparion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamodon' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippopotamodon' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippopotamodon' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamodon' AND (junior_species='major' OR junior_species='major')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='Hippopotamodon' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschidae' 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='Moschidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moschidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschidae' 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='Moschidae' AND (species='indet.' OR species='indet.') 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='Decennatherium' AND (junior_species='rex' OR junior_species='rex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Decennatherium' AND (species='rex' OR species='rex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Decennatherium' AND (species='rex' OR species='rex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decennatherium' AND (junior_species='rex' OR junior_species='rex')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='Decennatherium' AND (species='rex' OR species='rex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Promegantereon' AND (junior_species='ogygia' OR junior_species='ogygia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Promegantereon' AND (species='ogygia' OR species='ogygia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Promegantereon' AND (species='ogygia' OR species='ogygia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Promegantereon' AND (junior_species='ogygia' OR junior_species='ogygia')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='Promegantereon' AND (species='ogygia' OR species='ogygia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simocyon' 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='Simocyon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simocyon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simocyon' 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='Simocyon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protictitherium' AND (junior_species='crassum' OR junior_species='crassum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protictitherium' AND (species='crassum' OR species='crassum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protictitherium' AND (species='crassum' OR species='crassum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protictitherium' AND (junior_species='crassum' OR junior_species='crassum')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='Protictitherium' AND (species='crassum' OR species='crassum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomellivora' AND (junior_species='piveteaui' OR junior_species='piveteauii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomellivora' AND (species='piveteaui' OR species='piveteauii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomellivora' AND (species='piveteaui' OR species='piveteauii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomellivora' AND (junior_species='piveteaui' OR junior_species='piveteauii')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='Eomellivora' AND (species='piveteaui' OR species='piveteauii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Titanochelon' AND (junior_species='bolivari' OR junior_species='bolivarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Titanochelon' AND (species='bolivari' OR species='bolivarii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Titanochelon' AND (species='bolivari' OR species='bolivarii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Titanochelon' AND (junior_species='bolivari' OR junior_species='bolivarii')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='Titanochelon' AND (species='bolivari' OR species='bolivarii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='marathonensis' OR junior_species='marathonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='marathonensis' OR species='marathonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='marathonensis' OR species='marathonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='marathonensis' OR junior_species='marathonensis')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='Varanus' AND (species='marathonensis' OR species='marathonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphibia' 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='Amphibia' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphibia' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphibia' 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='Amphibia' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aves' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4276 The Ecological Register: Battalones-10 (Level II)
Battalones-10 (Level II)
Basic information
Sample name: Battalones-10 (Level II)

Reference: D. M. Martin-Perea, J. Morales, E. Cantero, L. A. Courtenay, M. H. Fernandez, and M. S. Domingo. 2021. Taphonomic analysis of Batallones-10, a Late Miocene drought-induced mammalian assemblage (Madrid basin, Spain) within the Cerro de los Batallones complex. Palaeogeography, Palaeoclimatology, Palaeoecology 578(110576):1-18 [ER 3895]
Geography
Country: Spain

State: Community of Madrid


Coordinate: 40.17115° N, -3.716684° W
Coordinate basis: estimated from map

Time interval: Late Miocene

Unit number: 2

Unit order: below to above

Max Ma: 9.95

Min Ma: 9.34

Age basis: other

Geography comments: Battalones-10 is one of the 9 site localities of the Cerro de los Battalones complex 30 km south of Madrid

Faunal assemblage analyses date the site to the early Late Miocene

"Small mammal studies place the Battalones localities either in the J2 local subzone (9.71-9.48 Ma) or in the J3 local subzone (9.34-9.95 Ma), with Battalones-10 being the oldest of the sites"

•
Environment
Lithology: marl

Taphonomic context: fissure fill,lake deposit

Habitat comments: Battalones-10 contains 3 distinct fossiliferous levels "hosted in marls deposited disconformably in a small water-hole that developed over sepiolite-rich mudstones, marls and limestones"

Level II is a defined 2 m vertical section between Level I (below) and Level III (above)

"Mortality at Battalones-10 is most probably related to animals suffering from a shortage of food and water"

The majority of Battalones-10 remains are unweathered, pointing towards a low exposure time (0-1 years) and/or accumulation in shallow water. Level II remains are less weathered than Level I and Level III

Presence of remains found either articulated or in direct assoc. with other remains from the same individual, as well as completely articulated individuals suggests deposition of complete or partially complete individuals

Carnivore-marked remains are very scarce

The three levels display very similar taphonomic histories, with only corrosion levels showing much variation (Level II showing the more than LI but less than L III)

Methods
Life forms: carnivores,ungulates,birds,lizards,turtles,frogs

Sampling methods: quarry

Sample size: 1807 specimens

Sampling comments: Battalones-10 has undergone 14 excavation campaigns between 2007 and 2020

Remains were identified taxonomically and anatomically on-site

Standard spatial data, including trend and plunge of elongated remains, was identified for specimens above 2 cm

3574 of the 7968 remains at Battalones-10 were classified to Level II

30 of the 68 large-mammal individuals were found at Level II

47.9% of recovered remains at Level II were taxonomically unidentified

Counts excluded:
Carnivora indet. - 26

Metadata
Sample number: 4276

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-05-22 12:19:21

Modified: 2023-05-22 02:19:21

Abundance distribution
14 species
3 singletons
total count 1807
extrapolated richness: 19.3
Fisher's α: 2.067
geometric series k: 0.5925
Hurlbert's PIE: 0.6794
Shannon's H: 1.5059
Good's u: 0.9983
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Rhinocerotidae indet.38
Hipparion sp.901
Hippopotamodon major35
Moschidae indet.190
Bovidae indet.32
Decennatherium rex426
Promegantereon ogygia1
Simocyon sp.1
Protictitherium crassum74
Eomellivora piveteaui1
Titanochelon bolivari86
Varanus marathonensis2
Amphibia indet.6
Aves indet.14
"Ave indet."